hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <>
Subject RE: error executing the tutorial ->
Date Thu, 05 Sep 2013 11:49:40 GMT

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.


From: Jitendra Yadav []
Sent: Thursday, September 05, 2013 5:11 PM
Subject: Re: error executing the tutorial ->


Did you configured fs.s3n.awsAccessKeyId or fs.s3n.awsSecretAccessKey properties
in your core-site.xml file?

On Thu, Sep 5, 2013 at 3:52 PM, <<>>

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

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
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Please help.


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.


View raw message