Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB