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. >
