>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, <shouvanik.hal...@accenture.com> wrote:
> Hi Nitin,****
>
> ** **
>
> PFA hive-site.xml. I wanted to start Hortonworks HIVE. Can you please help.
> ****
>
> ** **
>
> Thanks,****
>
> Shouvanik****
>
> ** **
>
> *From:* Nitin Pawar [mailto:nitinpawar...@gmail.com]
> *Sent:* Tuesday, September 10, 2013 11:15 AM
>
> *To:* user@hive.apache.org
> *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, <shouvanik.hal...@accenture.com> wrote:**
> **
>
> Please help. I am badly stuck on this. Please help.****
>
> ****
>
> *From:* Haldar, Shouvanik
> *Sent:* Tuesday, September 10, 2013 1:03 AM****
>
>
> *To:* 'user@hive.apache.org'
> *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:* 'user@hive.apache.org'
> *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:* user@hive.apache.org
> *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:nitinpawar...@gmail.com<nitinpawar...@gmail.com>]
> ****
>
> *Sent:* Saturday, September 07, 2013 2:25 AM****
>
> *To:* user@hive.apache.org
> *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 ? ****
>
> ****
>
> On Sat, Sep 7, 2013 at 2:18 AM, <shouvanik.hal...@accenture.com> wrote:***
> *
>
> Hi,****
>
> ****
>
> Can anybody please reply to this below? I am stuck up very bad.****
>
> ****
>
> Regards,****
>
> Shouvanik****
>
> ****
>
> *From:* Haldar, Shouvanik
> *Sent:* Friday, September 06, 2013 11:22 PM
> *To:* user@hive.apache.org
> *Subject:* RE: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
> ****
>
> Hi,****
>
> ****
>
> Is it possible to permanently set the below parameters? Please help.****
>
> ****
>
> Thanks,****
>
> SHouvanik****
>
> ****
>
> *From:* Jitendra Yadav
> [mailto:jeetuyadav200...@gmail.com<jeetuyadav200...@gmail.com>]
>
> *Sent:* Thursday, September 05, 2013 6:02 PM****
>
>
> *To:* user@hive.apache.org
> *Subject:* Re: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
> ****
>
> OK got your point, As an alternative you can set these variables in hive
> environment before creating the table****
>
> ****
>
> Hive > set fs.s3n.awsSecretAccessKey='value'
> Hive > set fs.s3n.awsAccessKeyId='Value'****
>
> ****
>
> Hope this will help you.****
>
> ****
>
> Thanks****
>
> Jitendra
> On Thu, Sep 5, 2013 at 5:19 PM, <shouvanik.hal...@accenture.com> wrote:***
> *
>
> Hi,****
>
> ****
>
> Thanks for the reply.****
>
> ****
>
> I had seen in some posts, that you could mention these keys on the Hive
> CLI. If things work, then I am later planning to include it in
> core-site.xml of Hadoop config. Presently, I am not allowed to restart
> Hadoop services. ****
>
> ****
>
> “create external table ….****
>
> …..****
>
> LOCATION 's3n:// <fs.s3n.awsAccessKeyId:
> fs.s3n>.<awsSecretAccessKey>@ap-hw-dev/service-names';
> ****
>
> ****
>
> Please help me.****
>
> ****
>
> Thanks,****
>
> Shouvanik****
>
> ****
>
> *From:* Jitendra Yadav [mailto:jeetuyadav200...@gmail.com]
> *Sent:* Thursday, September 05, 2013 5:11 PM
> *To:* user@hive.apache.org
> *Subject:* Re: error executing the tutorial ->
> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
> ****
>
> ****
>
> Hi,****
>
> ****
>
> Did you configured fs.s3n.awsAccessKeyId or fs.s3n.awsSecretAccessKey
> properties****
>
> in your core-site.xml file?****
>
> ****
>
> Regards****
>
> Jitendra****
>
> On Thu, Sep 5, 2013 at 3:52 PM, <shouvanik.hal...@accenture.com> wrote:***
> *
>
> Hi,****
>
> ****
>
> I am executing the example, but got initial roadblock while trying out
> “Setting up tables (DDL Statements)” section.****
>
> ****
>
> When I executed the command “hive> create external table kv (key int,
> values string) location 's3n://data.s3ndemo.hive/kv';”****
>
> ****
>
> I got the 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****
>
> hive>****
>
> ****
>
> Please help.****
>
> ****
>
> ****
>
> 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
