下面是我用来创建表的代码:
CREATE TABLE vi_vb(cTime STRING, VI STRING, Vital STRING, VB STRING)
PARTITIONED BY(cTime STRING, VI STRING)
CLUSTERED BY(VI) SORTED BY(cTime) INTO 32 BUCKETS
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '1'
COLLECTION ITEMS TERMINATED BY '2'
MAP KEYS TERMINATED BY '3'
STORED AS SEQUENCEFILE;
我真的不知道问题出在哪里,有人有什么建议吗?
3条答案
按热度按时间5ssjco0h1#
ars1skjm2#
按列划分不应在创建表定义中。按列划分将自动添加到表列中。
zengzsys3#
列“ctime,vi”被定义为普通列和分区列。