网上KUDU的资料很少,建议大家去下载官方文档,
http://download.csdn.net/download/m0_37534613/9772873
这是我整理好的。介绍的还是比较全的
对于KUDU删除表就直接在Linux下运行:
kudu table delete master(master的主机名) 表名
对于使用kudu1.1以及以下的用户,利用impala创建kudu表的语句为:
create table testdb.testtable1(
uuid string,
number int,
name string,
sex string
)distribute by hash(uuid) into 3 buckets, //利用哈希根据uuid分成三个桶
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' //指定主键
);
对于使用kudu1.2的用户,利用impala建kudu表:
CREATE TABLE my_first_table
(
id BIGINT,
name STRING,
PRIMARY KEY(id)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU;
CREATE TABLE new_table
PRIMARY KEY (ts, name)
PARTITION BY HASH(name) PARTITIONS 8
STORED AS KUDU
AS SELECT ts, name, value FROM old_table;
impala+kudu支持insert select插入数据