Denys Ordynskiy created DRILL-6894: -------------------------------------- Summary: CTAS and CTTAS are not working on S3 storage when cache is disabled Key: DRILL-6894 URL: https://issues.apache.org/jira/browse/DRILL-6894 Project: Apache Drill Issue Type: Bug Affects Versions: 1.15.0 Reporter: Denys Ordynskiy Attachments: CTAS_drillbit.log, CTAS_drillbit_queries.json, CTAS_sqlline.log, CTTAS_drillbit.log, CTTAS_drillbit_queries.json, CTTAS_sqlline.log, s3.json
When S3 storage plugin option "fs.s3a.impl.disable.cache" is true in the config section, CTAS and CTTAS queries throwing error in Sqlline: *create temporary table s3.tmp.`cttastblwithcache2` as select * from cp.`employee.json`;* {color:#d04437}Error: SYSTEM ERROR: SdkClientException: Unable to load AWS credentials from any provider in the chain Fragment 0:0 Please, refer to logs for more information. [Error Id: 8e386b68-d4fb-4cc6-ba1c-fb41ae0cc9ed on maprhost:31010] (state=,code=0){color} *create table s3.tmp.`ctastblwithcache` as select * from cp.`employee.json`;* {color:#d04437}Error: SYSTEM ERROR: SdkClientException: Unable to load AWS credentials from any provider in the chain Fragment 0:0 Please, refer to logs for more information. [Error Id: 4346d300-44be-4f17-90b6-4f3a0db0a148 on maprhost:31010] (state=,code=0){color} Logs and my storage plugin are in the attachments. -- This message was sent by Atlassian JIRA (v7.6.3#76005)