hive> ADD JAR /usr/lib/hive/lib/hive-hbase-handler-0.10.0-cdh4.5.0.jar;
Added /usr/lib/hive/lib/hive-hbase-handler-0.10.0-cdh4.5.0.jar to class path
Added resource: /usr/lib/hive/lib/hive-hbase-handler-0.10.0-cdh4.5.0.jar
hive> ADD JAR /usr/lib/hive/lib/zookeeper.jar;
Added /usr/lib/hive/lib/zookeeper.jar to class path
Added resource: /usr/lib/hive/lib/zookeeper.jar
hive> ADD JAR /usr/lib/hive/lib/hbase.jar;
Added /usr/lib/hive/lib/hbase.jar to class path
Added resource: /usr/lib/hive/lib/hbase.jar


hive> select count(1) from sample_logs_hbase;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_201312161015_0002, Tracking URL = http://[snip]:50030/jobdetails.jsp?jobid=job_201312161015_0002
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_201312161015_0002
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2013-12-16 10:19:41,443 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:20:41,768 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:21:42,064 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:22:42,350 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:23:42,638 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:24:42,919 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:25:43,199 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:26:43,464 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:27:43,724 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:28:43,992 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:29:44,240 Stage-1 map = 0%,  reduce = 0%
2013-12-16 10:29:52,278 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.61 sec
2013-12-16 10:29:53,297 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.61 sec
2013-12-16 10:29:54,306 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.61 sec
2013-12-16 10:29:55,316 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.61 sec
2013-12-16 10:29:56,326 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.61 sec
2013-12-16 10:29:57,339 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 4.97 sec
2013-12-16 10:29:58,349 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 4.97 sec
2013-12-16 10:29:59,360 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 4.97 sec
MapReduce Total cumulative CPU time: 4 seconds 970 msec
Ended Job = job_201312161015_0002
MapReduce Jobs Launched:
Job 0: Map: 1  Reduce: 1   Cumulative CPU: 4.97 sec   HDFS Read: 288 HDFS Write: 2 SUCCESS
Total MapReduce CPU Time Spent: 4 seconds 970 msec
OK
1
Time taken: 628.001 seconds