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
did you try setting them in hive-site.xml file ?
On Sat, Sep 7, 2013 at 2:18 AM, <[EMAIL PROTECTED]> 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:* [EMAIL PROTECTED]
> *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:[EMAIL PROTECTED]<[EMAIL PROTECTED]>]
>
> *Sent:* Thursday, September 05, 2013 6:02 PM
>
> *To:* [EMAIL PROTECTED]
> *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, <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
> *Sent:* Thursday, September 05, 2013 5:11 PM
> *To:* [EMAIL PROTECTED]
> *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, <[EMAIL PROTECTED]> 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.
>
>
> ______________________________________________________________________________________

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