That should work - which revision of hive are you using ?
From: Abhijit Pol [mailto:[email protected]] Sent: Thursday, September 10, 2009 11:51 AM To: [email protected] Subject: Re: enforcing query with partition column Thanks Namit. Setting this parameter in general works. However following query is now not allowed: SELECT a.bar FROM ( SELECT b.bar FROM table1 b WHERE b.partition_key = 1 UNION ALL SELECT c.bar FROM table2 c WHERE c.partition_key = 1 ) a Individual sub queries are allowed here...any suggestions? On Tue, Sep 8, 2009 at 10:22 AM, Namit Jain <[email protected]<mailto:[email protected]>> wrote: If you run in strict mode, that is enforced. set hive.mapred.mode=strict -namit -----Original Message----- From: Abhijit Pol [mailto:[email protected]<mailto:[email protected]>] Sent: Tuesday, September 08, 2009 10:07 AM To: [email protected]<mailto:[email protected]> Subject: enforcing query with partition column Is there a way in hive to enforce use of partition column before accepting the query for execution? Often user make mistake and don't specify them and then end-up waiting a lot more than expected.... Thanks, Abhi
