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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.16.0
• Labels: ready-to-commit
• Assignee: Bohdan Kazydub
• Reporter: Denys Ordynskiy
• Reviewer: Arina Ielchiieva
• Created: 10/Dec/18 19:26
• Updated: 08/Jul/19 16:27
• Resolved: 04/Jan/19 07:03

Description

When S3 storage plugin option "fs.s3a.impl.disable.cache" is true in the config section and Drill is restarted,
CTAS and CTTAS queries throwing error in Sqlline:

create temporary table s3.tmp.`cttastblwithcache2` as select * from cp.`employee.json`;
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)

create table s3.tmp.`ctastblwithcache` as select * from cp.`employee.json`;
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)

Logs and my storage plugin are in the attachments.

Issue Links

• links to: GitHub Pull Request #1576