I am running Hive 0.6.
On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > What is the hive version that you are using? > > > On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck <comptechge...@gmail.com>wrote: > >> I am not sure about the data, but when we do >> >> SELECT count(*) from data_realtime where dt='20120730' and uid is null >> >> I get the count >> >> but If I do- >> >> SELECT * from data_realtime where dt='20120730' and uid is null >> >> I get zero record back. But if all the record is NULL then I should be >> getting NULL record back right? >> >> >> But I am not getting anything back and that is the reason it is making me >> more confuse. >> >> >> >> >> >> >> On Tue, Aug 7, 2012 at 10:31 AM, Yue Guan <pipeha...@gmail.com> wrote: >> >> > Just in case, all Record is null when uid is null? >> > >> > On Tue, Aug 7, 2012 at 1:14 PM, Techy Teck <comptechge...@gmail.com> >> > wrote: >> > > SELECT count(*) from data_realtime where dt='20120730' and uid is null >> > > >> > > >> > > >> > > I get the count as 1509 >> > > >> > > >> > > >> > > So that means If I will be doing >> > > >> > > >> > > >> > > SELECT * from data_realtime where dt='20120730' and uid is null >> > > >> > > >> > > >> > > I should be seeing those records in which uid is null? right? >> > > >> > > But I get zero record back with the above query. Why is it so? Its >> very >> > > strange and why is it happening like this. Something wrong with the >> Hive? >> > > >> > > >> > > >> > > Can anyone suggest me what is happening? >> > > >> > > >> > > >> > > >> > >> > > > > -- > Swarnim >
