「SequoiaDB巨杉数据库」Hive建表、导入表及查询数据

建表

启动 Hive Shell 命令行窗口，执行如下命令创建表；

hive> create external table sdb_tab(id INT, name STRING, value DOUBLE) stored by "com.sequoiadb.hive.SdbHiveStorageHandler" tblproperties("sdb.address" = "localhost:11810");

OK
Time taken: 0.386 seconds

 

其中 sdb.address 用于指定 SequoiaDB 协调节点的 IP 和端口，如果有多个协调节点，可以写入多个，之间用逗号隔开。表所在的数据库对应 SequoiaDB 的集合空间，而表对应该集合空间中的集合。

 

从hdfs上导入表

从 HDFS 文件中导入数据到 SequoiaDB 表

hive> insert overwrite table sdb_tab select * from hdfs_tab;

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201310172156_0010, Tracking URL = http://bl465-5:50030/jobdetails.jsp?jobid=job_201310172156_0010
Kill Command = /opt/hadoop-hive/hadoop-1.2.1/libexec/../bin/hadoop job  -kill job_201310172156_0010
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 0
2013-10-18 04:44:47,733 Stage-0 map = 0%,  reduce = 0%
2013-10-18 04:44:49,763 Stage-0 map = 100%,  reduce = 0%, Cumulative CPU 1.85 sec
2013-10-18 04:44:50,777 Stage-0 map = 100%,  reduce = 0%, Cumulative CPU 1.85 sec
2013-10-18 04:44:51,795 Stage-0 map = 100%,  reduce = 100%, Cumulative CPU 1.85 sec
MapReduce Total cumulative CPU time: 1 seconds 850 msec
Ended Job = job_201310172156_0010
10 Rows loaded to sdb_tab
MapReduce Jobs Launched:
Job 0: Map: 1   Cumulative CPU: 1.85 sec   HDFS Read: 2301 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 1 seconds 850 msec
OK
Time taken: 12.201 seconds

 

查询数据

查询数据执行：

hive> select * from new_tab;
OK
0       false   0.0     ALGERIA
1       true    1.0     ARGENTINA
2       true    1.0     BRAZIL
3       true    1.0     CANADA
4       true    4.0     EGYPT
5       false   0.0     ETHIOPIA
6       true    3.0     FRANCE
7       true    3.0     GERMANY
8       true    2.0     INDIA
9       true    2.0     INDONESIA
Time taken: 0.306 seconds, Fetched: 10 row(s)