Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7197

Drill attempts to create table on Amazon when configured for on premise S3A

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 1.15.0
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None
    • Environment:

      Description

      Attempting to create Parquet tables from JSON data both within an on premises Minio S3A cluster.

      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 the following error. Drill appears to attempt a connection to Amazon on a CTAS but not a SELECT alone:

       

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mattk Matt Keranen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: