Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely


Copy link to this message
-
Re: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
>From the config file it looks ok. Not really sure why it is not picking up
when you run it via hive cli.

Can you try putting these in core-site.xml of hdfs.

<property>
    <name>fs.s3n.awsAccessKeyId</name>
    <value>ID</value>
</property>
<property>
    <name>fs.s3n.awsSecretAccessKey</name>
    <value>SECRET</value>
</property>

On Tue, Sep 10, 2013 at 3:11 PM, <[EMAIL PROTECTED]> wrote:

>  Hi Nitin,****
>
> ** **
>
> PFA hive-site.xml. I wanted to start Hortonworks HIVE. Can you please help.
> ****
>
> ** **
>
> Thanks,****
>
> Shouvanik****
>
> ** **
>
> *From:* Nitin Pawar [mailto:[EMAIL PROTECTED]]
> *Sent:* Tuesday, September 10, 2013 11:15 AM
>
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
> ** **
>
> if you have set these values inside hive-site.xml and restarted hive
> service. It should work. ****
>
> ** **
>
> Share your hive-site.xml (please remove values for s3naccess key and
> secret ) ****
>
> ** **
>
> On Tue, Sep 10, 2013 at 3:17 AM, <[EMAIL PROTECTED]> wrote:**
> **
>
> Please help. I am badly stuck on this. Please help.****
>
>  ****
>
> *From:* Haldar, Shouvanik
> *Sent:* Tuesday, September 10, 2013 1:03 AM****
>
>
> *To:* '[EMAIL PROTECTED]'
> *Subject:* RE: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
>  ****
>
> When I set values inside hive-site.xml & test whether values are set by
> typing hive> set; I see that the values are set.****
>
>  ****
>
> Yet, when I run “CREATE EXTERNAL TABLE…” command, I get the same error****
>
>  ****
>
> FAILED: Error in metadata:
> MetaException(message:java.lang.IllegalArgumentException: AWS Access Key ID
> and Secret Access Key must be specified as the username or password
> (respectively) of a s3n URL, or by setting the fs.s3n.awsAccessKeyId or
> fs.s3n.awsSecretAccessKey properties (respectively).)****
>
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask****
>
>  ****
>
> Please help.****
>
>  ****
>
> Thanks,****
>
> Shouvanik****
>
>  ****
>
> *From:* Haldar, Shouvanik ****
>
> *Sent:* Tuesday, September 10, 2013 12:39 AM****
>
> *To:* '[EMAIL PROTECTED]'
> *Subject:* RE: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
>  ****
>
> Hi Nitin,****
>
>  ****
>
> Please help me with the below?****
>
>  ****
>
> Thanks,****
>
> Shouvanik****
>
>  ****
>
> *From:* Haldar, Shouvanik ****
>
> *Sent:* Saturday, September 07, 2013 2:30 AM****
>
> *To:* [EMAIL PROTECTED]
> *Subject:* RE: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
>  ****
>
> Hi ,****
>
>  ****
>
> I tried to set the parameters inside hive-site.xml on the node from where
> I am running hive. Even “hive>set;” command showed me that the parameters
> were successfully set. Yet, when running hive “CREATE EXTERNAL TABLE…”, I
> am getting the following error****
>
>  ****
>
> FAILED: Error in metadata:
> MetaException(message:java.lang.IllegalArgumentException: AWS Access Key ID
> and Secret Access Key must be specified as the username or password
> (respectively) of a s3n URL, or by setting the fs.s3n.awsAccessKeyId or
> fs.s3n.awsSecretAccessKey properties (respectively).)****
>
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask   ****
>
>  ****
>
>  ****
>
> Please help.****
>
>  ****
>
> Thanks,****
>
> Shouvanik****
>
>  ****
>
> *From:* Nitin Pawar [mailto:[EMAIL PROTECTED]<[EMAIL PROTECTED]>]
> ****
>
> *Sent:* Saturday, September 07, 2013 2:25 AM****
>
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
>  ****
>
> did you try setting them in hive-site.xml file ? ****

Nitin Pawar
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB