hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rishabh Bhardwaj <rbnex...@yahoo.com>
Subject Behaviour of distinct clause
Date Thu, 05 Jun 2014 14:48:27 GMT
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.

Mime
View raw message