How do I do a Crosstab in Vertica

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: 418

Filed under:

vertica

|

crosstab

|

pivot-table

|

pivot

What is the Vertica equivalent of crosstab or pivot table found in PostgreSQL and other RDBMS's?

© Stack Overflow or respective owner

Related posts about vertica

How do I do a Crosstab in Vertica

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
Using an ODBC application with a JDBC driver

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
How do I Put Several Select Statements into Different Columns

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
What's the difference been NoSQL and a Column-Oriented database?

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

Related posts about crosstab

New Skool Crosstabbing

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
Access crosstab formula field in another crosstab column?

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
Tips for Simplifying Crosstab Query Statements

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
All About the Crosstab Query

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
MySQL CASE Statements in Multi-Aggregated Crosstab Columns

as seen on Internet.com - Search for 'Internet.com'
Inserting additional columns to a crosstab query is less straightforward than adding row data, because SQL naturally groups data by rows. Moreover, the efficacy of the CASE statement within an aggregate function decreases in direct proportion to the complexity of the criteria. Read on to learn more... >>> More