Re: Behaviour of distinct clause

14 at 8:07 AM, wenlong...@changhong.com < >> wenlong...@changhong.com> wrote: >> >>> I think, >>> it do not care filename column >>> >>> >>> >>> *From:* Rishabh Bhardwaj >>> *Date:* 2014-06-05 22:48 >>> *To:

Re: Behaviour of distinct clause

> > --Bala G. > > > On Thu, Jun 5, 2014 at 8:07 AM, wenlong...@changhong.com > < > wenlong...@changhong.com > > wrote: > >> I think, >> it do not care filename column >> >> >> >> *From:* Rishabh Bhardwaj >> >> *Date:*

Re: Behaviour of distinct clause

> > --Bala G. > > > On Thu, Jun 5, 2014 at 8:07 AM, wenlong...@changhong.com < > wenlong...@changhong.com> wrote: > >> I think, >> it do not care filename column >> >> >> >> *From:* Rishabh Bhardwaj >> *Date:* 2014-06-05 22:48 >>

Re: Behaviour of distinct clause

To:* User - Hive > *Subject:* Behaviour of distinct clause > Hi All, > I have a table named tetsing, > name age filename > A 21 file1 > A 21 file2 > B 21 file3 > C 23 file3 > (partitioned on filename) > Now,If I run a query like > select distinct name,age from test

Re: Behaviour of distinct clause

I think, it do not care filename column From: Rishabh Bhardwaj Date: 2014-06-05 22:48 To: User - Hive Subject: Behaviour of distinct clause Hi All, I have a table named tetsing, name age filename A 21 file1 A 21 file2 B 21 file3 C 23 file3 (partitioned on filename) Now,If I run a query like

Behaviour of distinct clause

Hi All, I have a table named tetsing, name age filename A 21 file1 A 21 file2 B 21 file3 C 23 file3  (partitioned on filename) Now,If I run a query like select distinct name,age from testing; It outputs, A 21 B 21 C 21 I want to know whether A 21 is from file1 or file2. Thanks, Rishabh.