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

Drill "SHOW FILES" command duplicates empty S3 folders as subfolders

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.16.0
    • Component/s: None
    • Labels:

      Description

      Description:
      If folder was created by pressing "+ Create folder" button on the S3 management console,
      Drill "SHOW FILES" command showing in this folder another subfolder with the same name.
      But this subfolder doesn't exist.

      Example:

      • login to the S3 management console;
      • open your bucket `some_bucket`;
      • create an empty folder `my_test_folder` by pressing "+ Create folder" button;
      • run Drill and open sqlline client;
      • exec query "show files in s3.tmp.`my_test_folder`;"

      Actual result:

      name isDirectory isFile length owner group permissions accessTime modificationTime
      my_test_folder true false 0     rwxrwxrwx 1970-01-01 03:00:00.0 1970-01-01 03:00:00.0

      1 row selected (1.318 seconds)

      Expected result:
      an empty result set.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                denysord88 Denys Ordynskiy
                Reviewer:
                Vova Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: