GP SQL：table

table创建语句:

create table <schema>.<table> (

<column_list>

)

tablespace <tbs_name>

distributed by (<distKeyColumn_list>)

partition by range (<partKeyColumn>)(

partition <partition_name1> start (<value1>) [end (<value2>)],

partition <partition_name2> start (<value2>) end (<value2>)

);

 

 

 

 

distributed by (id)

partition by list (gender)

(partition girls values('F'),

partition boys values('M'),

default partition othet

);