Re: Querying HBase Records with null valued-columns using hive

2012-06-11 Thread sagar naik
Sorry for the late reply, Ashutosh. Thanks for the pointers. I will soon try it out with the hive version -Sagar On Sat, Jun 2, 2012 at 10:30 AM, Ashutosh Chauhan wrote: > Hey Sagar, > > Seems like you have inserted data in your hbase table directly through > hbase client and not through hive c

Re: Querying HBase Records with null valued-columns using hive

2012-06-02 Thread Ashutosh Chauhan
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

Re: Querying HBase Records with null valued-columns using hive

2012-06-01 Thread sagar naik
I am using hive-0.7-cdh3u0 Thanks Again On Fri, Jun 1, 2012 at 9:20 PM, sagar naik 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 1