hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Channe <drah...@googlemail.com>
Subject Re: Behaviour of distinct clause
Date Thu, 05 Jun 2014 15:53:31 GMT
How does it matter , you are running distinct on name and age so one record is
displayed

If you add file name in you select then hopefully you will get what you are
looking for

On Thursday, June 5, 2014, Bala Krishna Gangisetty <bala@altiscale.com>
wrote:

> Could you paste the "describe <table_name>" output?
>
> --Bala G.
>
>
> On Thu, Jun 5, 2014 at 8:07 AM, wenlong.pu@changhong.com
> <javascript:_e(%7B%7D,'cvml','wenlong.pu@changhong.com');> <
> wenlong.pu@changhong.com
> <javascript:_e(%7B%7D,'cvml','wenlong.pu@changhong.com');>> wrote:
>
>>  I think,
>> it do not care filename column
>>
>>
>>
>>  *From:* Rishabh Bhardwaj
>> <javascript:_e(%7B%7D,'cvml','rbnext29@yahoo.com');>
>> *Date:* 2014-06-05 22:48
>> *To:* User - Hive <javascript:_e(%7B%7D,'cvml','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.
>>
>
>

Mime
View raw message