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]> wrote: > If you run in strict mode, that is enforced. > > set hive.mapred.mode=strict > > > > -namit > > > -----Original Message----- > From: Abhijit Pol [mailto:[email protected]] > Sent: Tuesday, September 08, 2009 10:07 AM > To: [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 >
