1,创建hbase表
Corpus
>>
create '
Corpus
','CF'
2,创建hive->hbase外表logic_
Corpus,并对应hbase中的
Corpus表
>>
CREATE EXTERNAL TABLE logic_
Corpus (
rowkey string,
Text string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,
CF:T
ext
")
TBLPROPERTIES("hbase.table.name" = "
Corpus");
//创建目录
hadoop fs -mkdir -p /user/maoxiao/2015/aud/weiboUserData/input
//上传文件
hadoop fs -put weiboUserData.txt /user/maoxiao/2015/aud/weiboUserData/input
创建外部表
CREATE EXTERNAL TABLE data_Corpus (
Text string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LOCATION '/user/cloudera/input';