https://community.cloudera.com/t5/Support-Questions/Pass-the-hadoop-security-credential-provider-path-to-beeline/m-p/221341#M183215 <P>Hi,</P><P>I followed the below document to create my hadoop.security.credential.provider.path file and i am trying to pass it from beeline command string. </P><P><A href="https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_cloud-data-access/content/s3-credential-providers.html" target="_blank">https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_cloud-data-access/content/s3-credential-providers.html</A></P><P>But when ever i try to create a external table from S3 data it throws the below error. </P><P>i even followed the steps from <A href="https://community.hortonworks.com/questions/54123/how-to-pass-hadoopsecuritycredentialproviderpath-i.html?childToView=212393" target="_blank">https://community.hortonworks.com/questions/54123/how-to-pass-hadoopsecuritycredentialproviderpath-i.html?childToView=212393</A> </P><P>I have whitelisted the property hadoop.security.credential.provider.path in such a way that it can be set at connection time in the JDBC connection string between beeline and hiveserver2. In hive-site:</P><OL> <LI>hive.security.authorization.sqlstd.confwhitelist.append = hadoop.security.credential.provider.path</LI></OL><P>Also tried passing the credential path as part of jdbc string as suggested from above forum answer but no luck it still throws the same error. Can someone please help me.</P><P>bash-4.2$ beeline --hive-conf hadoop.security.credential.provider.path=jceks://hdfs@clustername/pedev/user/myuser/myuser.jceks -u "jdbc:hive2://zookeeperlist:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;"</P><P>Beeline version 1.2.1000.2.6.3.0-235 by Apache Hive</P><P>0: jdbc:hive2://hostname:2&gt; CREATE EXTERNAL TABLE <CODE>HDFSaudit_data8</CODE>(<CODE>access</CODE> string, <CODE>action</CODE>string, <CODE>agenthost</CODE> string , <CODE>cliip</CODE> string , <CODE>clitype</CODE> string , <CODE>enforcer</CODE> string , <CODE>event_count</CODE> bigint , <CODE>event_dur_ms</CODE> bigint , <CODE>evttime</CODE>timestamp , <CODE>id</CODE> string , <CODE>logtype</CODE> string , <CODE>policy</CODE> bigint , <CODE>reason</CODE> string , <CODE>repo</CODE> string , <CODE>repotype</CODE> bigint , <CODE>reqdata</CODE> string , <CODE>requser</CODE> string , <CODE>restype</CODE> string , <CODE>resource</CODE> string , <CODE>result</CODE> bigint , <CODE>seq_num</CODE> bigint , <CODE>sess</CODE> string ) ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 's3a://bucketname/hivetest2';</P><P><STRONG>Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.io.InterruptedIOException: doesBucketExist on bucketname: com.amazonaws.AmazonClientException: No AWS Credentials provided by BasicAWSCredentialsProvider EnvironmentVariableCredentialsProvider SharedInstanceProfileCredentialsProvider : com.amazonaws.AmazonClientException: Unable to load credentials from Amazon EC2 metadata service) (state=08S01,code=1)</STRONG></P> Wed, 15 Aug 2018 20:22:43 GMT prashanth_rames 2018-08-15T20:22:43Z