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

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


+
shouvanik.haldar@... 2013-09-30, 13:53
+
Nitin Pawar 2013-09-30, 14:04
+
shouvanik.haldar@... 2013-09-30, 14:15
Copy link to this message
-
Re: Not able to execute this query
Nitin Pawar 2013-09-30, 14:51
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, <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
> *Sent:* Monday, September 30, 2013 7:34 PM
> *To:* [EMAIL PROTECTED]
> *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, <[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****
>

--
Nitin Pawar
+
shouvanik.haldar@... 2013-09-30, 15:28
+
Nitin Pawar 2013-09-30, 15:37
+
shouvanik.haldar@... 2013-09-30, 16:59