Posted
by Russ Bradberry
on Stack Overflow
See other posts from Stack Overflow
or by Russ Bradberry
Published on 2010-03-15T19:16:30Z
Indexed on
2010/03/15
19:19 UTC
Read the original article
Hit count: 361
What is the Vertica equivalent of crosstab or pivot table found in PostgreSQL and other RDBMS's?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
What is the Vertica equivalent of crosstab or pivot table found in PostgreSQL and other RDBMS's?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
My company uses Vertica. We have Python applications that connect to it with pyodbc. I do most of my development on a Mac (Snow Leopard) and unfortunately Vertica has not released ODBC drivers for Mac. They do have JDBC drivers though. I don't think developing in Jython is a good compromise. …
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I basically have 7 select statement that I need to have the results output into separate columns. Normally I would use a crosstab for this but I need a fast efficient way to go about this as there are over 7 billion rows in the table. I am using the vertica database system. Below is an example…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
The more I read about NoSQL, the more it begins to sound like a column oriented database to me.
What's the difference between NoSQL (e.g. CouchDB, Cassandra, MongoDB) and a column oriented database (e.g. Vertica, MonetDB)?
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
A while back I spoke about having to go back to BIP's original crosstabbing solution to achieve a certain layout. Hok Min has provided a 'man' page for the new crosstab/pivot builder for 10.1.3.4.1 users. This will make the documentation drop but for now, get it here!
The old, hand method is still…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How to access crosstab formula field in another column? I have report like with Dues & total both formula fields:
Amount Dues(Done by a Formula) Total (Done by a Formula)
------ ------------------------- ---------------------------
500 20 % someAmount
Formula…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows…
>>> More
