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**** > > ** ** >
