hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jitendra Yadav <jeetuyadav200...@gmail.com>
Subject Re: error executing the tutorial -> https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely
Date Thu, 05 Sep 2013 12:32:25 GMT
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.haldar@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:jeetuyadav200890@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.haldar@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****
>
> ** **
>

Mime
View raw message