欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

Kudu建表语句

程序员文章站 2022-07-09 20:51:20
--建表CREATE TABLE kudu_testdb.perf_test_t1( id string ENCODING PLAIN_ENCODING COMPRESSION SNAPPY, int_value int, bigint_value bigint, timestamp_value t ......

--建表
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'
);