Re: Issue while creating Hive External table on S3 location

2017-07-26 Thread Sarath Kumar Sivan
Hi Leela, The Secret Access Key property name should be *fs.s3n.awsSecretAccessKey* NOT *fs.s3.awsSecretAccessKey* Access Key property name should be *fs.s3n.awsAccessKeyId* NOT *fs.s3.awsAccessKeyId* Please try this: hive> set fs.s3n.awsSecretAccessKey=zvpZS8KxMBLK0w73w8yhzWaW0Ove10 Pk+fH

Issue while creating Hive External table on S3 location

2017-07-26 Thread leela prasad Gorrepati
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