Data Partitioning

Once your data is stored in Treasure Data, it is partitioned according to its timestamps. Your data is partitioned by the hour.

By constraining the ‘time’ column, you can avoid processing the whole dataset. This results in better performance.

SELECT COUNT(1) FROM table WHERE time > 1338311795

Last modified: Jul 07 2012 02:23:16 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.