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