Hey Sagar, Seems like you have inserted data in your hbase table directly through hbase client and not through hive client. If so, you need https://issues.apache.org/jira/browse/HIVE-1634 to correctly read pre-existing data in hbase. Hive-1634 is available as a part of 0.9 release. So, upgrade to 0.9 and your problem should go away.
Hope it helps, Ashutosh On Fri, Jun 1, 2012 at 9:31 PM, sagar naik <sn...@attributor.com> wrote: > I am using hive-0.7-cdh3u0 > > Thanks Again > > On Fri, Jun 1, 2012 at 9:20 PM, sagar naik <sn...@attributor.com> wrote: > > Hi , > > I am seeing a very weird hive-hbase query behaviour. > > I have an externally mounted hbase table in hive > > > > > > select creation_ts, length(url), isnull(url), ! (isnull(url)) from > > task_table 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 > > Starting Job = job_201206011557_0023, Tracking URL = > > http://xxxxxxxx:50030/jobdetails.jsp?jobid=job_201206011557_0023 > > Kill Command = /xxxxxx/xxxxx/xxxxx/../bin/hadoop job > > -Dmapred.job.tracker=xxxxxx:54311 -kill job_201206011557_0023 > > 2012-06-01 20:37:09,878 Stage-1 map = 0%, reduce = 0% > > 2012-06-01 20:37:15,920 Stage-1 map = 100%, reduce = 0% > > 2012-06-01 20:37:16,929 Stage-1 map = 100%, reduce = 100% > > Ended Job = job_201206011557_0023 > > OK > > 1337061992484 NULL false true > > 1334307650105 184 false true > > 1336532379103 229 false true > > 1335226875331 NULL false true > > 1335746654565 NULL false true > > 1335400140889 NULL false true > > 1338419117954 NULL false true > > 1338425256315 NULL false true > > 1336554120401 NULL false true > > 1338002526497 NULL false true > > Time taken: 10.528 seconds > > > > Notice that isnull(url) is false for all strings even if length reported > is null > > > > My ultimate aim is to get the number of records where url is null and > > join those records with another table > > > > > > > > I noticed that FilterOPerator passes (returns TRUE) > > however, when it is forwarded (forward (...,...) ) it returns FALSE :O > > > > Any pointers / help is highly appreciated. > > > > > > -Sagar >