[ https://issues.apache.org/jira/browse/DRILL-6931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16737491#comment-16737491 ]
Denys Ordynskiy commented on DRILL-6931: ---------------------------------------- Successfully tested on Drill Explorer and Sqlline for storages: - MapRFS - S3 - FileSystem > Drill "SHOW FILES" command duplicates empty S3 folders as subfolders > -------------------------------------------------------------------- > > Key: DRILL-6931 > URL: https://issues.apache.org/jira/browse/DRILL-6931 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.14.0 > Reporter: Denys Ordynskiy > Assignee: Arina Ielchiieva > Priority: Major > Labels: ready-to-commit > Fix For: 1.16.0 > > > *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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)