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

Posted to user@hive.apache.org by t liu <we...@gmail.com> on 2010/08/19 11:27:07 UTC

about partition question

hi all:

    if i create a new partition, like
    'ALTER TABLE page_view ADD PARTITION (dt='2008-08-08') location
'/path/to/us/part080808 ' ';

    i don't know the key word 'location' means location file system or hdfs
?
    i did it both ;
    it always show OK.
    but i can't query any result in this new partition.
    so
    key word location means what ?

Re: about partition question

Posted by Ping Zhu <pi...@sharethis.com>.

location clause specifies a HDFS dir.

please post your query so that others has more information about your
question.

On Thu, Aug 19, 2010 at 2:27 AM, t liu <we...@gmail.com> wrote:

> hi all:
>
>     if i create a new partition, like
>     'ALTER TABLE page_view ADD PARTITION (dt='2008-08-08') location
> '/path/to/us/part080808 ' ';
>
>     i don't know the key word 'location' means location file system or hdfs
> ?
>     i did it both ;
>     it always show OK.
>     but i can't query any result in this new partition.
>     so
>     key word location means what ?
>