superset中有个时间字段区分查询必须为时间字段
kylin中创建也必须是时间字段
kylin时间字段为
2018-12-10只有年月日创建的时候为date类型
2018-11-02 07:52:00有年月日时分秒的为Timestamp类型
样例:
CREATE EXTERNAL TABLE orderbusiness(
key string,
RECORD_DATE Timestamp,
log_date date,
session_id string,
)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf9:RECORD_DATE,cf9:log_date,cf9:session_id")
TBLPROPERTIES("hbase.table.name" = "orderbusiness");