作者官方网站:http://www.wxl568.cn
分区整理创建表
inc_day=天存储
INC_MON=月存储
------------引号处理
create table
dm_hrssgps.pmp_agnt_operation_log_big
(
opt_menucount string comment '统计数据',
opt_menu string comment '菜单',
opt_time string comment '日志搜集表日期'
)
PARTITIONED by (
inc_day string comment '分区'
)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
;
-------------------
CREATE TABLE `dm_ecas_dcs.fvp_kq_record`(
`mandt` string,
`barscantm` string,
`pernr` string,
`wdate` string,
`tdate` string,
`ttime` string,
`cnt` int COMMENT 'Number')
PARTITIONED BY (
`inc_day` string)----------------分区
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat';
不分区创建表
CREATE TABLE `dm_ecas_dcs.check_tmp1`(
`year_month` string,
`hq_code` string,
`area_code` string,
`dept_code` string,
`pernr` string,
`lgart` string,
`month_code` string,
`sj_tickets` double,
`sj_weight` double,
`sj_fee` double,
`pj_tickets` double,
`pj_weight` double,
`pj_fee` double,
`sync_time` string,
`betrg` decimal(27,2))
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat';