建表语句
CREATE external TABLE `login_number`(
serial_number string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'='\t',
'serialization.format'='\t')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'hdfs://test/apps/hive/datahouse/cmbh_bus.db/login_number'
表下边放以\t分割的文件直接查询
hadoop fs -put serial_number.txt /apps/hive/datahouse/cmbh_bus.db/login_number/