Partitioning on Vertica tables!... ?
Posted: Mon Feb 25, 2013 2:37 pm
Can we partition a table in vertica?
Ex: I need to partition employee table based on dept number.
1. i think, since vertica stores all the data of the table as columns under super projection and all the columns will be sorted. In this case do we need a partition?
2. Whenever a table is created and the data is inserted, by default a super projection is created. is this SP will have all the column sorted and compressed or Encoded by default? or it only happens when we create a projection and force it for compression/Encoding?
3. If Partition can be created, can you give me a example SQL to create on emp table for deptno?
Thanks,
Jagadeesh.
Ex: I need to partition employee table based on dept number.
1. i think, since vertica stores all the data of the table as columns under super projection and all the columns will be sorted. In this case do we need a partition?
2. Whenever a table is created and the data is inserted, by default a super projection is created. is this SP will have all the column sorted and compressed or Encoded by default? or it only happens when we create a projection and force it for compression/Encoding?
3. If Partition can be created, can you give me a example SQL to create on emp table for deptno?
Thanks,
Jagadeesh.