nt: Tue, March 8, 2011 4:36:08 PM
Subject: Re: How to support SQL NOT IN function in Hive QL
Re: How to support SQL NOT IN function in Hive QL Bejoy – If timestamp of the
dates is not of much importance to you, you can alternatively use >=
‘start_date’ and <= ‘end_date’.
Thanks,
Rekha.
On
From: Rekha Joshi
To: "user@hive.apache.org"
Sent: Tue, March 8, 2011 3:08:08 PM
Subject: Re: How to support SQL NOT IN function in Hive QL
Re: How to support SQL NOT IN function in Hive QL @Bejoy - AFAIK, NOT IN is not
directly supported in current hive. Workaround
BY T1_field1,T1_field2_ID,T1_field3,T1_field4;
Regards
Bejoy.K.S
From: Rekha Joshi
To: "user@hive.apache.org"
Sent: Tue, March 8, 2011 3:08:08 PM
Subject: Re: How to support SQL NOT IN function in Hive QL
Re: How to support SQL NOT IN function i
@Bejoy - AFAIK, NOT IN is not directly supported in current hive. Workaround,
you can write an outer join instead of antijoin. HIVE-1740, mentions another
workaround - NOT(x LIKE p).
Thanks,
Rekha.
On 3/8/11 2:12 PM, "Bejoy Ks" wrote:
Hi Experts
I'm facing a hurdle in transforming a SQL qu
Hi Experts
I'm facing a hurdle in transforming a SQL query to equivalent Hive QL with
SQL NOT IN functionality. My SQL query would like this
INSERT INTO Table1
(T1_field1,T1_field2_ID,T1_field3,T1_field4)
SELECT field1,field2,field3,field4
FROM Table2 JOIN Table3 T3
WHERE (field1,field2,fiel
