RE: Not able to execute this query
Thanks Nitin. I am able to create the table in HUE now. You are right. There was no directory and no permission accordingly. Thanks, Shouvanik From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Monday, September 30, 2013 9:08 PM To: Haldar, Shouvanik Cc: user@hive.apache.org Subject: 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, mailto:shouvanik.hal...@accenture.com>> 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:nitinpawar...@gmail.com<mailto:nitinpawar...@gmail.com>] Sent: Monday, September 30, 2013 8:22 PM To: user@hive.apache.org<mailto:user@hive.apache.org> 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, mailto: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<mailto:nitinpawar...@gmail.com>] Sent: Monday, September 30, 2013 7:34 PM To: user@hive.apache.org<mailto: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, 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 -- Nitin Pawar -- Nitin Pawar
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, 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:nitinpawar...@gmail.com] > *Sent:* Monday, September 30, 2013 8:22 PM > > *To:* user@hive.apache.org > *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, 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, 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
RE: Not able to execute this query
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:nitinpawar...@gmail.com] Sent: Monday, September 30, 2013 8:22 PM To: user@hive.apache.org 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, mailto: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<mailto:nitinpawar...@gmail.com>] Sent: Monday, September 30, 2013 7:34 PM To: user@hive.apache.org<mailto: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, 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 -- Nitin Pawar
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, 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, 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
RE: Not able to execute this query
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, 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
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, 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
Not able to execute this query
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
