hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From leela prasad Gorrepati <>
Subject Issue while creating Hive External table on S3 location
Date Wed, 26 Jul 2017 06:38:45 GMT
Hi All,
I am unable to create Hive external table on s3 location. I have followed
the steps mentioned in ""

My Hive commands and received error is,

hive> set hadoop.socks.server=localhost:2600;
hive> set;
hive> set hadoop.job.ugi=root,root;
hive> set;
hive> set mapred.reduce.tasks=-1;
hive> set fs.s3.awsSecretAccessKey=zvpZS8KxMBLK0w73w8yhzWaW0Ove10Pk+fHeit/I;
hive> set fs.s3.awsAccessKeyId=AKIAINIHCWDZMRWJEI3A;
hive> create external table empl (id int, name string, location string)
location 's3://leela-2507-test/employee';
FAILED: Execution Error, return code 1 from
MetaException(message:java.lang.IllegalArgumentException: AWS Access Key ID
and Secret Access Key must be specified by setting the fs.s3.awsAccessKeyId
and fs.s3.awsSecretAccessKey properties (respectively).)

Any one can try with the above valid access key, I have created for trail
purpose and test data is in s3://leela-2507-test/employee

Configuring in hive-site.xml also results in same error.

Any suggestions are appreciated.

Thanks in Advance.

Leela Prasad

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message