ueries
> which are common in a world of unstructured and un-clean data.
>
> ** **
>
> -Marcin
>
> ** **
>
> *From:* Sunita Arvind [mailto:sunitarv...@gmail.com]
> *Sent:* Tuesday, July 30, 2013 11:00 AM
> *To:* user@hive.apache.org
> *Subject:* Hive Jo
Tuesday, July 30, 2013 11:00 AM
To: user@hive.apache.org
Subject: Hive Join with distinct rows
Hi Praveen / All,
I also have a requirement similar to the one explained (by Praveen) below:
distinct rows on a single column with corresponding data from other columns.
http://mail-archives.a
Hi Praveen / All,
I also have a requirement similar to the one explained (by Praveen) below:
distinct rows on a single column with corresponding data from other columns.
http://mail-archives.apache.org/mod_mbox/hive-user/201211.mbox/%3ccahmb8ta+r0h5a+armutookhkp8fxctown68qoz6lkfmwbrk...@mail.gmai
But I think Hive should support distinct on single column along with
fetching corresponding data from other columns mentioned in the query.
Something like
"Select distinct(col1), col2, col3 from TB1"
For example
hive> SELECT col1, col2 FROM t1;
1 3
1 3
1 4
2 5
-- Selects distinct col1, col2 tup
Thank you very much Mark
Yes query1 is doing just fine, but using query1 I will not be able to get
the data in other columns in table T1
On Fri, Nov 9, 2012 at 10:04 PM, Mark Grover wrote:
> I see. I re-read your first email and you would like to query "select all
> the unique ID's in T1 which
I see. I re-read your first email and you would like to query "select all
the unique ID's in T1 which are not in T2"
Query 1 seems to be doing just fine so I would say that's the way to go. I
personally use "IS" operator when comparing something with NULLs instead of
"=".
There are some optimizat
S
Date: Fri, 9 Nov 2012 21:30:28
To:
Reply-To: user@hive.apache.org
Subject: Re: Hive Join with distinct rows
Thanks Mark, I do understand that how Hive works with Distinct keyword.
What I was looking for is a solution for my requirement in Hive, I am not
an expert in SQL, hence looking for
Thanks Mark, I do understand that how Hive works with Distinct keyword.
What I was looking for is a solution for my requirement in Hive, I am not
an expert in SQL, hence looking for suggestions
On Fri, Nov 9, 2012 at 9:54 AM, Mark Grover wrote:
> Hi Praveen,
> Let's take an example:
> (from
> h
Hi Praveen,
Let's take an example:
(from
https://cwiki.apache.org/Hive/languagemanual-select.html#LanguageManualSelect-ALLandDISTINCTClauses
)
-- Print out contents of the table
hive> SELECT col1, col2 FROM t1;
1 3
1 3
1 4
2 5
-- Selects distinct col1, col2 tuple
hive> SELECT DISTINCT col1, col2
