1.Kudu的数据类型:
bool, int8, int16, int32, bigint, int64, float, double, string, binary, timestamp.
但 decimal,char,varchar,date 和 array 等复杂类型不受支持.
2.Kudu数据库的使用
2.1创建数据库
CREATE DATABASE IF NOT EXISTS POC_TEST;
2.2.创建表(我这是基于cdh使用的hue)
注意:
CREATE TABLE IF NOT EXISTS POC_TEST.sdc(
id string,
name string,
PRIMARY KEY (id)
) PARTITION BY HASH(id) PARTITIONS 2
STORED AS KUDU;
TBLPROPERTIES('kudu.master_addresses'='master.msxf.hadoop:7051','kudu.num_tablet_replicas' = '1');
2.3删除表和删除数据库
DROP TABLE [表名];
DROP DATABASE [数据库名];
2.4删除试图
DROP VIEW [视图名];
2.5获取某一天的时间(时间类型转string类型,在截取时间)
select substr(cast(CREATE_DATE as string),1,10) from CBEE_ELIST WHERE substr(cast(CREATE_DATE as string),1,10) = '2001-02-01'
2.6字符串切割(一个汉字=三个英文或者字母)