Simply run this query: select distinct name,age, filename from testing; you will be able to get the answer what you want.
On Thu, Jun 5, 2014 at 11:53 AM, Rahul Channe <drah...@googlemail.com> wrote: > How does it matter , you are running distinct on name and age so one record is > displayed > > If you add file name in you select then hopefully you will get what you > are looking for > > > On Thursday, June 5, 2014, 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 >>> *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 >>> 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. >>> >> >>
