I am using ~15 days old version from 0.4 branch......


On Thu, Sep 10, 2009 at 5:55 PM, Namit Jain <[email protected]> wrote:

>  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]> 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
>
>
>

Reply via email to