[DRILL-6931] Drill "SHOW FILES" command duplicates empty S3 folders as subfolders

• 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: Arina Ielchiieva
• Reporter: Denys Ordynskiy
• Reviewer: Vova Vysotskyi
• Created: 27/Dec/18 16:10
• Updated: 08/Jul/19 16:28
• Resolved: 04/Jan/19 07:00

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.

Issue Links

• links to: GitHub Pull Request #1590