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