I am really not sure what your entire query is but the below one works . If possible share your entire ddl and mask or hide cols if there is something you can not share
create table test1( col3 int, col4 string) PARTITIONED BY (col1 timestamp, col2 timestamp) CLUSTERED BY(col3) SORTED BY(col3 ASC) into 40 buckets ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE; On Mon, Sep 30, 2013 at 7:45 PM, <shouvanik.hal...@accenture.com> wrote: > 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> 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**** > -- Nitin Pawar
