Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Not able to execute this query


Copy link to this message
-
Re: Not able to execute this query
Nitin Pawar 2013-09-30, 14:04
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, <[EMAIL PROTECTED]> 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