You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Josh Ferguson <jo...@besquared.net> on 2008/12/10 09:13:27 UTC

Select Partition

Did you guys do away with having table_source statements include  
optional partition clauses? Cause for me it's not working but is  
listed here:

http://wiki.apache.org/hadoop/Hive/HiveQL#head-b7a4dfaec9e317a5ceaf3d13a7c62b7daa445110

I get something like this:

FAILED: Parse Error: line 1:246 mismatched input 'PARTITION' expecting  
EOF

Is this because you can just use a WHERE clause for the same thing?

Josh

Re: Select Partition

Posted by Zheng Shao <zs...@gmail.com>.

Sorry the wiki is outdated.

Please use

SELECT table.* from table WHERE table.pcol = 'pcol_val1';

instead.

Zheng

On Wed, Dec 10, 2008 at 12:13 AM, Josh Ferguson <jo...@besquared.net> wrote:

> Did you guys do away with having table_source statements include optional
> partition clauses? Cause for me it's not working but is listed here:
>
>
> http://wiki.apache.org/hadoop/Hive/HiveQL#head-b7a4dfaec9e317a5ceaf3d13a7c62b7daa445110
>
> I get something like this:
>
> FAILED: Parse Error: line 1:246 mismatched input 'PARTITION' expecting EOF
>
> Is this because you can just use a WHERE clause for the same thing?
>
> Josh
>



-- 
Yours,
Zheng