hive over hbase方式将文本库数据导入hbase

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