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.