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
