hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Not able to execute this query
Date Mon, 30 Sep 2013 14:04:29 GMT
you are trying to bucket and partition on same column?

I could create a hive table if I change the bucketing column to
non-partition column


On Mon, Sep 30, 2013 at 7:23 PM, <shouvanik.haldar@accenture.com> wrote:

>  When I executing the query to create table in HIVE, I am getting this
> error.****
>
> ** **
>
> 'NoneType' object has no attribute 'columns'****
>
> ** **
>
> ** **
>
> The table script below****
>
> ** **
>
> ** **
>
> create external table test1(****
>
> ** **
>
> -----****
>
> )****
>
> PARTITIONED BY (col1 timestamp,****
>
>                     col2  timestamp)****
>
>   CLUSTERED BY(col1)****
>
>   SORTED BY(col1 ASC) into 40 buckets****
>
>    ****
>
>   ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'****
>
>   STORED AS TEXTFILE****
>
>   LOCATION '/user/test/'****
>
> ** **
>
> ** **
>
> Thanks,****
>
> Shouvanik****
>
> ------------------------------
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise confidential information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the e-mail by you is prohibited.
>
> Where allowed by local law, electronic communications with Accenture and
> its affiliates, including e-mail and instant messaging (including content),
> may be scanned by our systems for the purposes of information security and
> assessment of internal compliance with Accenture policy.
>
>
> ______________________________________________________________________________________
>
> www.accenture.com
>



-- 
Nitin Pawar

Mime
View raw message