Home | About | Sematext search-lucene.com search-hadoop.com
 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
Do the hue user have permissions to access '/user/hue'?
is that directory existing ?
On Mon, Sep 30, 2013 at 8:58 PM, <[EMAIL PROTECTED]> wrote:

>  Hi Nitin,****
>
> ** **
>
> Thanks. That answers my previous query. But, if I add LOCATION
> '/user/hue/' string below, I get a big fat exception in beeswax.****
>
> ** **
>
> Thanks,****
>
> Shouvanik****
>
> ** **
>
> *From:* Nitin Pawar [mailto:[EMAIL PROTECTED]]
> *Sent:* Monday, September 30, 2013 8:22 PM
>
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: Not able to execute this query****
>
> ** **
>
> 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****
>

--
Nitin Pawar