Hive query returning empty results

[Nishant Shobhit <ni...@gmail.com>]

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