Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Columns Vs Rows - HIVE


Columns Vs Rows - HIVE

New Contributor

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.


Re: Columns Vs Rows - HIVE

Master Guru
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.