cassandra uuid类型
- 作者: 宋大财
- 来源: 51数据库
- 2020-09-29
对于bai使用kudu1.1以及以下的用du户，利用impala创建zhikudu表的语句为：
create table testdb.testtable1(
uuid string,
number int,
name string,
sex string
)distribute by hash(uuid) into 3 buckets, //利用哈希根据daouuid分成三内个桶
Range (number) split rows(('10001'),('10002'),('10003')) //利用number进行容分区
TABLEPROPERTIES(
'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
'kudu.table_name' = 'testtable1',
'kudu.master_addresses' = 'master:7051',
'kudu.key_columns' = 'uuid' //指定主键
);
create table testdb.testtable1(
uuid string,
number int,
name string,
sex string
)distribute by hash(uuid) into 3 buckets, //利用哈希根据daouuid分成三内个桶
Range (number) split rows(('10001'),('10002'),('10003')) //利用number进行容分区
TABLEPROPERTIES(
'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
'kudu.table_name' = 'testtable1',
'kudu.master_addresses' = 'master:7051',
'kudu.key_columns' = 'uuid' //指定主键
);
推荐阅读
