hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bala Krishna Gangisetty <b...@altiscale.com>
Subject Re: Behaviour of distinct clause
Date Thu, 05 Jun 2014 15:48:31 GMT
Could you paste the "describe <table_name>" output?

--Bala G.


On Thu, Jun 5, 2014 at 8:07 AM, wenlong.pu@changhong.com <
wenlong.pu@changhong.com> wrote:

>  I think,
> it do not care filename column
>
>
>
>  *From:* Rishabh Bhardwaj <rbnext29@yahoo.com>
> *Date:* 2014-06-05 22:48
> *To:* User - Hive <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