I'm running hive-0.10.0 on hbase. I was able to map the hbase table and could run a few queries to check if the data is being mapped correctly.
hive> describe hive_hbase_data; OK id string from deserializer time timestamp from deserializer type string from deserializer mid string from deserializer country1 string from deserializer folio string from deserializer country2 string from deserializer cost float from deserializer code string from deserializer Time taken: 5.709 seconds One particular query: select count1 from hive_hbase_data limit 10; works and then returns 0 results in the second try for the same hive CLI invocation. If I quit and restart hive CLI, the query returns data. I haven't seen anything suspicious in the CLI output. hive> select dest_country from hive_sms_handler_sms limit 10; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks is set to 0 since there's no reduce operator 13/04/26 11:38:13 WARN mapred.JobClient: Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 13/04/26 11:38:13 WARN mapred.LocalJobRunner: LocalJobRunner does not support symlinking into current working dir. Starting Job = job_local1505188031_0002, Tracking URL = http://localhost:8080/ Kill Command = //usr/lib/hadoop/bin/hadoop job -kill job_local1505188031_0002 13/04/26 11:38:14 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 13/04/26 11:38:14 WARN mapreduce.Counters: Counter name MAP_INPUT_BYTES is deprecated. Use FileInputFormatCounters as group name and BYTES_READ as counter name instead Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0 2013-04-26 11:38:15,948 Stage-1 map = 0%, reduce = 0% Ended Job = job_local1505188031_0002 MapReduce Jobs Launched: Job 0: HDFS Read: 65034 HDFS Write: 65034 SUCCESS Total MapReduce CPU Time Spent: 0 msec OK <-- why are no results returned with the status? Time taken: 2.999 seconds hive> /tmp/hdfs/hive.log doesn't have anything. I was not able to find the hadoop job logs as well. Any pointers/help? TIA
