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.
Basically I need to know what would be better for HIVE. An structure based on rows or based on columns.