New Contributor
Posts: 2
Registered: ‎05-05-2015

Columns Vs Rows - HIVE

Hi everyone!
The question is What is better for the performace, we have a table with a PK and a measure variable day by day:
- To have the PK and one column with the measure day by day (365 columns for a given year)

- To have the PK, the date column and one columsn with the measure.

Posts: 1,896
Kudos: 433
Solutions: 303
Registered: ‎07-31-2013

Re: Columns Vs Rows - HIVE

The decision depends on your majority type of queries. If you're going to extract specific days often, it makes sense to keep them separated, etc.