hive从hdfs文件系统里面读取数据

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')