hadoop三----基于hadoop伪分布式整合hive和hbase
分别启动hive和hbase shellhive> CREATE TABLE pokes (foo INT, bar STRING);
OK
Time taken: 6.294 seconds
hive> show tables;
OK
pokes
Time taken: 0.131 seconds, Fetched: 1 row(s)
.在hive中创建表，语句如下：
hive> CREATE TABLE hbase_table_1(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("hbase.table.name" = "xyz");
OK
Time taken: 63.667 seconds
创建之后分别查看hbase和hive中的变化：
hive> show tables; OK
hbase_table_1
pokes
Time taken: 0.718 seconds, Fetched: 2 row(s)
hive> select * from hbase_table_1;
OK
1abc
Time taken: 32.543 seconds, Fetched: 1 row(s)
hbase(main):047:0> list
TABLE
xyz
1 row(s) in 17.3310 seconds
=> ["xyz"]
hbase(main):048:0> put 'xyz','1','cf1:val','abc'
0 row(s) in 7.9590 seconds
hbase(main):049:0> scan 'xyz'
ROW COLUMN+CELL
1 column=cf1:val, timestamp=1413433021803, value=abc
1 row(s) in 1.1650 seconds
页:
[1]