[DRILL-6863] Drop table is not working if path within workspace starts with '/'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.15.0
• Labels: ready-to-commit
• Assignee: Bohdan Kazydub
• Reporter: Denys Ordynskiy
• Reviewer: Vitalii Diravka
• Created: 20/Nov/18 17:48
• Updated: 08/Jul/19 16:23
• Resolved: 29/Nov/18 20:29

Description

Drill works incorrectly if path to the table within workspace starts with '/'

Request "drop table s3.tmp.`drill/transitive_closure/tab1`" works fine,
but if I add '/' in the begining of the tables path "drop table s3.tmp.`/drill/transitive_closure/tab1`", Drill is trying to find table in the root directory but not in workspace path.

Actual result:
Drill returns successfully response
"Table [/drill/transitive_closure/tab1] dropped"
but table was not dropped.

 

Expected result:

Table was droped.

Bug can be reproduced on S3 and DFS storages. On FileSystem storage Drill successfully returns error message if "drop table" query starts with '/' in table path.

Issue Links

• relates to: DRILL-1130 Leading / in a select query should be rooted from the workspace rather than from the file system
• relates to: DRILL-6869 Drill allows to create views outside workspace
• links to: GitHub Pull Request #1557