Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
MIME-Version: 1.0
From: leela prasad Gorrepati <leelaprasad.gorrepati@gmail.com>
Date: Wed, 26 Jul 2017 12:08:45 +0530
Message-ID: <CAHFBHWBXVg62RnmTWPhQy-hRwVBQBSzBDVEniBU8+DQLjoRD4w@mail.gmail.com>
Subject: Issue while creating Hive External table on S3 location
To: dev@hive.apache.org
Content-Type: multipart/alternative; boundary="001a1143dd0c21dbb1055532b31c"
archived-at: Wed, 26 Jul 2017 14:11:35 -0000

--001a1143dd0c21dbb1055532b31c
Content-Type: text/plain; charset="UTF-8"

Hi All,
I am unable to create Hive external table on s3 location. I have followed
the steps mentioned in "
https://cwiki.apache.org/confluence/display/Hive/HiveAws+HivingS3nRemotely"

My Hive commands and received error is,

hive> set hadoop.socks.server=localhost:2600;
hive> set
hadoop.rpc.socket.factory.class.default=org.apache.hadoop.net.SocksSocketFactory;
hive> set hadoop.job.ugi=root,root;
hive> set mapred.map.tasks=40;
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
org.apache.hadoop.hive.ql.exec.DDLTask.
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.

Regards,
Leela Prasad

--001a1143dd0c21dbb1055532b31c--