kudu基础使用

创建表

CREATE TABLE if not exists test_table
(
  id BIGINT,
  name STRING,
  PRIMARY KEY(id)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU;

将数据插入Kudu表

INSERT INTO test_table VALUES (99, "sarah");
INSERT INTO test_table VALUES (1, "john"), (2, "jane"), (3, "jim");
INSERT INTO test_table SELECT * FROM other_table;

更新一行数据

UPDATE test_table SET name="bob" where id = 3;

删除一行数据

DELETE FROM test_table WHERE id < 3;

映射已有kudu表到Impala中

CREATE EXTERNAL TABLE my_mapping_table
STORED AS KUDU
TBLPROPERTIES (
  'kudu.table_name' = 'test_table'
);