kudu环境测试

drop table kddb.zhangsan_kudutabletest;
CREATE TABLE kddb.zhangsan_kudutabletest
(
meta_table string,
id bigint comment ' 自增ID',
order_id string comment ' 订单编号',
risk_order_id bigint comment ' ',
PRIMARY KEY (meta_table, id)
)
PARTITION BY HASH (id) PARTITIONS 3
comment 'XX 信息'
STORED AS KUDU
TBLPROPERTIES ('kudu.master_addresses'=XXXX', 'kudu.table_name'='kddb_zhangsan_kudutabletest');

-- 更新插入kudu表

upsert into kddb.zhangsan_kudutabletest values('zhangsan_kudutabletest',13,'order_id001',9999999999999);

select * from kddb.zhangsan_kudutabletest ;

posted @ 2020-11-10 17:53  bjxdd  阅读(205)  评论(0)    收藏  举报