4 ms·
Yeah but it's nitpicky :) Maybe "past 5 years" mean "over everything" and then it might technically be one column. Or if you're using something like S3 with P
by glogla 5y ago
Yeah but it's nitpicky :)
Maybe "past 5 years" mean "over everything" and then it might technically be one column.
Or if you're using something like S3 with Parquet for "columnar database" and it is partitioned by date, then the date values are stored in metadata - so you would logically read two columns but physically only read one from storage. Same story for something like Redshift and using date as sortkey.
- coldacid 5y agoOh, I'm definitely being nitpicky :D