| 123456789101112131415161718 |
- CREATE TABLE pokes
- (
- foo INT,
- bar STRING
- );
- create table if not exists t_account
- (
- id bigint,
- sex tinyint COMMENT '性别',
- name String COMMENT '姓名',
- create_time timestamp,
- primary key(id) disable novalidate
- ) COMMENT '用户表'
- partitioned by (year string)
- clustered by (id) into 2 buckets
- row format delimited fields terminated by '\t'
- stored as orc TBLPROPERTIES('transactional'='true');
|
