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.
