hive中不同数据类型存储在Hbase中的格式解析

来源：互联网发布：linux 分辨率命令编辑：程序博客网时间：2024/05/05 00:26

1. Hive中操作

./bin/beeline!connect jdbc:hive2://localhost:10000rootrootdeveCREATE TABLE hbase_table_hyy1(key int, c1_tinyint tinyint,c2_smallint smallint,c3_int int,c4_bigint bigint,c5_float float ,c6_double double,c7_string string,c8_binary binary,c9_timestamp timestamp, c10_decimal decimal,c11_char char(30),c12_varchar  varchar(30),c13_date date) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f1:c1,f1:c2,f1:c3,f1:c4,f1:c5,f1:c6,f1:c7,f1:c8,f1:c9,f1:c10,f1:c11,f1:c12,f1:c13")TBLPROPERTIES ("hbase.table.name" = "hyy1", "hbase.mapred.output.outputtable" = "hyy1");

插入一条数据

insert into hbase_table_hyy1 values(5,2,32,800000,3398888222299,12.12,32.34232,'kf panda','kf panda','2015-12-25 11:23:46',45.345672,'kf panda','kf panda','2015-12-25');

2.Hbase中查询

hbase(main):409:0* scan "hyy1"ROW                                           COLUMN+CELL                                                                                                                           5                                            column=f1:c1, timestamp=1461203860561, value=2  5                                            column=f1:c10, timestamp=1461203860561, value=45 5                                            column=f1:c11, timestamp=1461203860561, value=kf panda  5                                            column=f1:c12, timestamp=1461203860561, value=kf panda   5                                            column=f1:c13, timestamp=1461203860561, value=2015-12-25   5                                            column=f1:c2, timestamp=1461203860561, value=32   5                                            column=f1:c3, timestamp=1461203860561, value=800000   5                                            column=f1:c4, timestamp=1461203860561, value=3398888222299   5                                            column=f1:c5, timestamp=1461203860561, value=12.12  5                                            column=f1:c6, timestamp=1461203860561, value=32.34232 5                                            column=f1:c7, timestamp=1461203860561, value=kf panda  5                                            column=f1:c8, timestamp=1461203860561, value=a2YgcGFuZGE=  5                                            column=f1:c9, timestamp=1461203860561, value=2015-12-25 11:23:46

3.Hive中插入下面数据（下面的时间没有进去，格式不对）

insert into hbase_table_hyy1 values(6,2,32,800000,3398888222299,12.12,32.34232,'kf panda','kf panda','2015/12/25 11:23:46',45.345672,'kf panda','kf panda','2015/12/25');

4. Hbase中查询

 6                                            column=f1:c1, timestamp=1461203991093, value=2 6                                            column=f1:c10, timestamp=1461203991093, value=45 6                                            column=f1:c11, timestamp=1461203991093, value=kf panda 6                                            column=f1:c12, timestamp=1461203991093, value=kf panda 6                                            column=f1:c2, timestamp=1461203991093, value=32 6                                            column=f1:c3, timestamp=1461203991093, value=800000 6                                            column=f1:c4, timestamp=1461203991093,value=3398888222299 6                                            column=f1:c5, timestamp=1461203991093, value=12.12 6                                            column=f1:c6, timestamp=1461203991093, value=32.34232 6                                            column=f1:c7, timestamp=1461203991093, value=kf panda 6                                            column=f1:c8, timestamp=1461203991093, value=a2YgcGFuZGE=

5.java程序读取

ROW: 5Family:f1  Qualifier :c1  value: 2 ValueLength: 1Family:f1  Qualifier :c10  value: 45 ValueLength: 2Family:f1  Qualifier :c11  value: kf panda                       ValueLength: 30Family:f1  Qualifier :c12  value: kf panda ValueLength: 8Family:f1  Qualifier :c13  value: 2015-12-25 ValueLength: 10Family:f1  Qualifier :c2  value: 32 ValueLength: 2Family:f1  Qualifier :c3  value: 800000 ValueLength: 6Family:f1  Qualifier :c4  value: 3398888222299 ValueLength: 13Family:f1  Qualifier :c5  value: 12.12 ValueLength: 5Family:f1  Qualifier :c6  value: 32.34232 ValueLength: 8Family:f1  Qualifier :c7  value: kf panda ValueLength: 8Family:f1  Qualifier :c8  value: a2YgcGFuZGE= ValueLength: 12Family:f1  Qualifier :c9  value: 2015-12-25 11:23:46 ValueLength: 19ROW: 6Family:f1  Qualifier :c1  value: 2 ValueLength: 1Family:f1  Qualifier :c10  value: 45 ValueLength: 2Family:f1  Qualifier :c11  value: kf panda                       ValueLength: 30Family:f1  Qualifier :c12  value: kf panda ValueLength: 8Family:f1  Qualifier :c2  value: 32 ValueLength: 2Family:f1  Qualifier :c3  value: 800000 ValueLength: 6Family:f1  Qualifier :c4  value: 3398888222299 ValueLength: 13Family:f1  Qualifier :c5  value: 12.12 ValueLength: 5Family:f1  Qualifier :c6  value: 32.34232 ValueLength: 8Family:f1  Qualifier :c7  value: kf panda ValueLength: 8Family:f1  Qualifier :c8  value: a2YgcGFuZGE= ValueLength: 12

发现出过binary类型，其余类型都是以字符串存储在hbase中的。

0 0