[jira] [Created] (DRILL-7197) Drill attempts to create table on Amazon when configured for on premise S3A

["Matt Keranen (JIRA)" <ji...@apache.org>]

Matt Keranen created DRILL-7197:
-----------------------------------

             Summary: Drill attempts to create table on Amazon when configured for on premise S3A
                 Key: DRILL-7197
                 URL: https://issues.apache.org/jira/browse/DRILL-7197
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.15.0
         Environment: {{{}}
{{ "type": "file",}}
{{ "connection": "s3a://logs",}}
{{ "config": {}}
{{  "fs.s3a.endpoint": "x.x.x.x:9001",}}
{{  "fs.s3a.connection.ssl.enabled": "false",}}
{{  "fs.s3a.access.key": "xxx",}}
{{  "fs.s3a.secret.key": "xxx"}}
{{ },}}
{{ "workspaces": {}}
{{  "tmp": {}}
{{   "location": "/tmp",}}
{{   "writable": true,}}
{{   "defaultInputFormat": null,}}
{{   "allowAccessOutsideWorkspace": false}}
{{  },}}
{{  "logs": {}}
{{  "location": "/",}}
{{  "writable": true,}}
{{  "defaultInputFormat": null,}}
{{  "allowAccessOutsideWorkspace": false }}
{{ }}}
{{ },}}
            Reporter: Matt Keranen


Able to SELECT from local S3 storage (Minio), but CTAS seems to be trying to go to Amazon S3:

    SELECT * FROM s3.logs LIMIT 1;

works, but

    CREATE TABLE s3.logs.`test` SELECT ... FROM s3.logs

results in error:

{{Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request ID: XXX, AWS Error Code: InvalidAccessKeyId, AWS Error Message: The AWS Access Key Id you provided does not exist in our records.}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)