above query
select * from customer where (cust_id =12022 OR cust_id=11783);
Regards
Bejoy KS
From: Puneet Khatod
To: "user@hive.apache.org"
Sent: Wednesday, July 18, 2012 2:11 PM
Subject: Not in clause in hive query
Hi,
I am working on Hive
Hi,
I am working on Hive 0.7. I am migrating SQL queries to hive and facing issues
with the queries that have 'Not in' clause usage.
Example:
select * from customer where cust_id not in (12022,11783);
I am getting:
FAILED: Parse Error: line 1:38 cannot recognize input near ' cust_id ' 'not'
'
