Kudu建表语句

最新推荐文章于 2024-01-04 14:16:41 发布

转载最新推荐文章于 2024-01-04 14:16:41 发布 · 5.3k 阅读

3 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/whattaman/p/11096666.html

文章标签：

#数据库 #shell #python

--建表
CREATE TABLE kudu_testdb.perf_test_t1
(
id string ENCODING PLAIN_ENCODING COMPRESSION SNAPPY,
int_value int,
bigint_value bigint,
timestamp_value timestamp,
bool_value int,
PRIMARY KEY (histdate,id)
)
PARTITION BY HASH (histdate,id) PARTITIONS 2
STORED AS KUDU
TBLPROPERTIES (
'kudu.table_name' = 'testdb.perf_test_t1',
'kudu.master_addresses' = '192.172.2.2:7051,192.172.2.3:7051,192.172.2.4:7051'
);

转载于:https://www.cnblogs.com/whattaman/p/11096666.html