You lose a lot of the benefits, but you can still take advantage of time range partition elimination just as long as your data is still physically partitioned b

You lose a lot of the benefits, but you can still take advantage of time range partition elimination just as long as your data is still physically partitioned by the timestamp column. That's the most important thing when processing time series data--never read from disk any of the data that's outside the time range you actually need for your query.