Simply run this query:
select distinct name,age, filename from testing;
you will be able to get the answer what you want.
On Thu, Jun 5, 2014 at 11:53 AM, Rahul Channe
wrote:
> How does it matter , you are running distinct on name and age so one record is
> displayed
>
> If you add file name i
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
wrote:
> Could you paste the "describe " output?
>
> --Bala G.
>
>
A 21 file1
A 21 file2
B 21 file3
C 23 file3
from this data if you do select distinct name,age
then the field file is completely ignored as you have not queried for it.
On Thu, Jun 5, 2014 at 9:18 PM, Bala Krishna Gangisetty
wrote:
> Could you paste the "describe " output?
>
> --Bala G.
>
>
> O
Could you paste the "describe " output?
--Bala G.
On Thu, Jun 5, 2014 at 8:07 AM, wenlong...@changhong.com <
wenlong...@changhong.com> wrote:
> I think,
> it do not care filename column
>
>
>
> *From:* Rishabh Bhardwaj
> *Date:* 2014-06-05 22:48
> *To:* User - Hive
> *Subject:* Behaviour of
I think,
it do not care filename column
From: Rishabh Bhardwaj
Date: 2014-06-05 22:48
To: User - Hive
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
