1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| CREATE EXTERNAL TABLE `ods_o_mdt_huawei_log_mdt_h_fenqu`(
`recloggrpttimestamp` string,
`measstarabsolutetimestamp` string
)
PARTITIONED BY (
`dayid` string,
`hourid` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'=',',
'serialization.format'=',')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://192.168.1.34:9000/apps/hive/warehouse/hiveods.db/ods_o_mdt_huawei_log_mdt_h'
TBLPROPERTIES (
'bucketing_version'='2',
'last_modified_by'='ica',
'last_modified_time'='1607600876',
'transient_lastDdlTime'='1607600876')
|
