- 4381 Views
- 3 replies
- 5 kudos
Resolved! Z-Ordering Timestamp Column
Hi,I've large Delta Table for IoT data for over 10K different sensors with timestamp, sensor name and value columns at 1 second precision.Query pattern is usually random 5-100 sensors at a time. But typically involves specific year/month/day interval...
- 4381 Views
- 3 replies
- 5 kudos
Latest Reply
- 5 kudos
@numersoz did you z-order on the timestamp column or on less granular columns, like Year, Month, or Day. timestamp column is very granular (high cardinality) since it also includes hour, minute, second...
- 5 kudos