Hi,

Have you used HUE WEB console. Actually I have not used same columns. But, when 
I give a query, I get that error.!

Please help?

Thanks,
Shouvanik

From: Nitin Pawar [mailto:nitinpawar...@gmail.com]
Sent: Monday, September 30, 2013 7:34 PM
To: user@hive.apache.org
Subject: 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, 
<shouvanik.hal...@accenture.com<mailto:shouvanik.hal...@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<http://www.accenture.com>



--
Nitin Pawar

Reply via email to