I have a n00b question, I wanted to know whether its possible to specify names for the individual partitions that we create in the CREATE TABLE statement.
For example, is something like this possible (?) :
CREATE TABLE DATABASENAME.SALES_DETAIL
PRIMARY INDEX SALES_DETAIL ( CUST_ORD_ID )
PARTITION BY RANGE_N
PART_1 2007011 AND 2007527 EACH 1 ,
PART_2 2008011 AND 2008527 EACH 1 ,
PART_3 2009011 AND 2009527 EACH 1 ,
PART_4 2010011 AND 2010527 EACH 1 ,
Or is there some other syntax to implement the same? That is, naming the individual partitions ?