09-25-2013 11:22 AM
I am having issues accessing S3 with hive. I have my keys and ID under hive-site.xml and i am able to see them when I run
I get a list of all the attributes for hive but when I try to access s3 to create a table i get 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 s3 URL, or by setting the fs.s3.awsAccessKeyId or fs.s3.awsSecretAccessKey properties (respectively).)
I even set the fs.s3 and fs.s3n attributes manually using the set command under hive.
Still no luck . Any suggestions or ideas
Thanks so much
10-17-2013 10:26 AM
09-12-2014 08:03 AM
Do you copy the entire block of XML into the Value text box? Like:
I did that, deployed the client configuration, and then went to /etc/hadoop/conf/core-site.xml and there were no changes. STill can't see S3 buckets.
07-26-2017 04:18 AM
Do you able to resolve this issue. I understand that its been a long time, since you have posted this. Now I am facing the same Issue, your suggession for resolving this would be helpful for me.
Thanks in advance.
10-05-2017 05:25 AM
We are also facing the same issue , we have already added aprameters in hdfs-site.xml and core-site.xml but still getting the error while runing create external table statement.
message:java.lang.IllegalArgumentException: AWS Access Key ID and Secret Access Key must be specified as the username or password (respectively) of a s3 URL,
any help on this would be realy helpful
10-09-2017 06:01 AM