CREATE EXTERNAL TABLE `old_user_info`(
`user_id` bigint ,
`PlatformId` string ,
`SelfChannel` string ,
`ChannelToken` string ,
`lv` bigint ,
`gm_stone` bigint ,
`charge_stone` bigint ,
`create_time` bigint ,
`last_act_time` bigint )
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://127.0.0.1:9000/user/input/'
TBLPROPERTIES (
'COLUMN_STATS_ACCURATE'='false',
'numFiles'='0',
'numRows'='-1',
'rawDataSize'='-1',
'totalSize'='0',
'transient_lastDdlTime'='1439809315')
转载请注明原文地址: https://ju.6miu.com/read-12348.html