hive 包含所有字段的建表语句

drop table if exists sk_test_create_hive_create_all_fields;
create table if not exists sk_test_create_hive_create_all_fields(
`user_id` bigint COMMENT ‘产品id‘,
`user_name` string COMMENT ‘登录名‘,
`status` TINYINT COMMENT ‘用户状态 0正常 1冻结‘,
`user_name_init` INT COMMENT ‘用户名是否已修改 0 未修改 1 已修改‘,
`ctime` TIMESTAMP COMMENT ‘创建时间‘,
`invalid` SMALLINT COMMENT ‘Y:无效,N:有效‘,
`last_login_time` date COMMENT ‘最后登录时间‘,
`size` float COMMENT ‘size‘,
`dou` DOUBLE,
`dec` DECIMAL,
`success` BOOLEAN,
`file` BINARY,
`arr` array<string>,
`map` MAP<STRING,INT>,
`struct` struct<name:STRING, age:INT>

) comment ‘‘ partitioned by (ds string comment ‘‘) stored as orc;

hive 包含所有字段的建表语句

原文：https://www.cnblogs.com/shengkai126126/p/13259871.html