[jira] [Created] (DRILL-6894) CTAS and CTTAS are not working on S3 storage when cache is disabled

[Denys Ordynskiy (JIRA)]

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)