[DRILL-4305] Querying folders broken in 1.4.0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.3.0
• Component/s: Functions - Drill

Environment

Local Embedded Drill 1.4.0 Version running on Windows 10 and Java 8

• Flags: Patch
• Assignee: Unassigned
• Reporter: Andre Pomp
• Created: 23/Jan/16 09:47
• Updated: 14/Oct/19 20:42
• Resolved: 14/Oct/19 20:42

Description

Hey all,

today I updated drill 1.3.0 to 1.4.0 and I explored that querying folders (using the Syntax of 1.3.0) is not possible anymore.

So on Drill 1.3.0 the following sqline command was possible:

SELECT * FROM dfs.`C:\Users\someuser\Desktop\testdir`;
Moreover, I also tested queries like

SELECT * FROM dfs.`C:\Users\someuser\Desktop\testdir\`;
SELECT * FROM dfs.`C:\Users\someuser\Desktop\testdir*`;
SELECT * FROM dfs.`C:\Users\someuser\Desktop\testdir*.json`;

All those commands work fine with Drill 1.3.0.
However, when switiching to 1.4.0, I get the following Exceptions:

Error: VALIDATION ERROR: Unexpected internal error near index 1
\
^

Can someone explain why the old queries are not working anymore on 1.4.0? How can I query folders with 1.4.0?
Currently, I assume that there is a bug.

Best regards,
André

Issue Links

• duplicates: DRILL-4416 Quote path separator for windows