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

["Denys Ordynskiy (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Denys Ordynskiy closed DRILL-6894.
----------------------------------

> 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.14.0
>            Reporter: Denys Ordynskiy
>            Assignee: Bohdan Kazydub
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 1.16.0
>
>         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 and Drill is restarted,
> 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)