Table Partition


#1
  1. How we can do table partition based on some specific criteria ? for example - Daily Partition
  2. If first part is possible, is it possible to Truncate the table.

#2

Hi @sumit -

While MapD supports sharding for performance, coarse-grained partitioning like you are describing isn’t one of our current features.

You can call truncate table within MapD, but it will remove the entire table results, not just a partition.

Thanks,
Randy


#3

Hi Randy,

Thanks for quick response.


#4

Hi @sumit,

This may not exactly solve your use case but we do support a max_rows clause (doc here) at table creation time which will roll off/delete the oldest partition/fragment of rows when the table grows beyond that size.

Regards