A 21 file1 A 21 file2 B 21 file3 C 23 file3 from this data if you do select distinct name,age then the field file is completely ignored as you have not queried for it.
On Thu, Jun 5, 2014 at 9:18 PM, Bala Krishna Gangisetty <b...@altiscale.com> wrote: > Could you paste the "describe <table_name>" output? > > --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 <rbnex...@yahoo.com> >> *Date:* 2014-06-05 22:48 >> *To:* User - Hive <user@hive.apache.org> >> *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 testing; >> >> It outputs, >> A 21 >> B 21 >> C 21 >> >> I want to know whether A 21 is from file1 or file2. >> >> Thanks, >> Rishabh. >> > > -- Nitin Pawar
