1 、先在hive上创建hbase能识别的表
CREATE TABLE hbase_scores(key string, grade string,math string,art string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,grade:grade,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "hbase_scores");
2、创建hive表,并导入数据
CREATE TABLE scores(key string, grade string,math string,art string)
row format delimited fields terminated by '\t';
3、把hive表导入hbase能识别的表,就可以在hive和hbase中查询了和使用了。
INSERT OVERWRITE TABLE hbase_scores SELECT * FROM scores;
------------
hbase表只有列族,没有列的,对应关系应该怎么写?
CREATE TABLE hbase_scores1(key string, grade string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,grade:,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "hbase_scoresjin");
-----
hbase上已经存在表,在hive上创建外部表
CREATE EXTERNAL TABLE scores_h(key string,math string,art string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "scores");
hive关联hbase的外部表无法用load导入数据。
CREATE TABLE hbase_scores(key string, grade string,math string,art string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,grade:grade,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "hbase_scores");
2、创建hive表,并导入数据
CREATE TABLE scores(key string, grade string,math string,art string)
row format delimited fields terminated by '\t';
3、把hive表导入hbase能识别的表,就可以在hive和hbase中查询了和使用了。
INSERT OVERWRITE TABLE hbase_scores SELECT * FROM scores;
------------
hbase表只有列族,没有列的,对应关系应该怎么写?
CREATE TABLE hbase_scores1(key string, grade string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,grade:,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "hbase_scoresjin");
-----
hbase上已经存在表,在hive上创建外部表
CREATE EXTERNAL TABLE scores_h(key string,math string,art string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,course:math,course:art")
TBLPROPERTIES ("hbase.table.name" = "scores");
hive关联hbase的外部表无法用load导入数据。