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.

Reply via email to