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:Text")
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';