[ https://issues.apache.org/jira/browse/DRILL-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16222052#comment-16222052 ]
Arina Ielchiieva commented on DRILL-4640: ----------------------------------------- Will be fixed in the scope of DRILL-5771. > Unable to submit physical plan from Web UI on Windows > ----------------------------------------------------- > > Key: DRILL-4640 > URL: https://issues.apache.org/jira/browse/DRILL-4640 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.6.0 > Reporter: Arina Ielchiieva > Assignee: Arina Ielchiieva > Fix For: Future > > > Unable to submit physical plan from Web UI on Windows: > Steps to reproduce: > 1. Generate physical plan using query: > explain plan for SELECT * FROM cp.`employee.json` LIMIT 20 > 2. Copy output in json column: > {noformat} > { "head" : { "version" : 1, "generator" : { "type" : "ExplainHandler", "info" > : "" }, "type" : "APACHE_DRILL_PHYSICAL", "options" : [ ], "queue" : 0, > "resultMode" : "EXEC" }, "graph" : [ { "pop" : "fs-scan", "@id" : 4, > "userName" : "User", "files" : [ "classpath:/employee.json" ], "storage" : { > "type" : "file", "enabled" : true, "connection" : "classpath:///", "config" : > null, "workspaces" : null, "formats" : { "csv" : { "type" : "text", > "extensions" : [ "csv" ], "delimiter" : "," }, "tsv" : { "type" : "text", > "extensions" : [ "tsv" ], "delimiter" : "\t" }, "json" : { "type" : "json", > "extensions" : [ "json" ] }, "parquet" : { "type" : "parquet" }, "avro" : { > "type" : "avro" }, "csvh" : { "type" : "text", "extensions" : [ "csvh" ], > "extractHeader" : true, "delimiter" : "," } } }, "format" : { "type" : > "json", "extensions" : [ "json" ] }, "columns" : [ "`*`" ], "selectionRoot" : > "classpath:/employee.json", "cost" : 463.0 }, { "pop" : "limit", "@id" : 3, > "child" : 4, "first" : 0, "last" : 20, "initialAllocation" : 1000000, > "maxAllocation" : 10000000000, "cost" : 20.0 }, { "pop" : > "selection-vector-remover", "@id" : 2, "child" : 3, "initialAllocation" : > 1000000, "maxAllocation" : 10000000000, "cost" : 20.0 }, { "pop" : "project", > "@id" : 1, "exprs" : [ { "ref" : "`*`", "expr" : "`*`" } ], "child" : 2, > "initialAllocation" : 1000000, "maxAllocation" : 10000000000, "cost" : 20.0 > }, { "pop" : "screen", "@id" : 0, "child" : 1, "initialAllocation" : 1000000, > "maxAllocation" : 10000000000, "cost" : 20.0 } ] } > {noformat} > 3. Submit physical plan from Web UI > Error: > {noformat} > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > PatternSyntaxException: Unexpected internal error near index 1 \ ^ [Error Id: > 4310ee06-2e84-4241-9317-553382948718 on 10.2.2.62:31010] > {noformat} > Checked in Chrome and Mozilla Firefox. > Works fine on Linux. > The problem was in > [FileSelection|https://github.com/apache/drill/blob/44d5cc8eb1cd197d942a8ac52e9d42e282d30c88/exec/java-exec/src/main/java/org/apache/drill/exec/store/dfs/FileSelection.java#L40] > class. It used {{System.getProperty("file.separator")}} to split given path. > But since we use {{org.apache.hadoop.fs.Path}} which stores path using its > default separator, not systems -> {{org.apache.hadoop.fs.Path.SEPARATOR}}. > Default separator on Windows is \ but given path we had / (even if it came > from Windows) and that's why the error occurred. To fix this problem we just > need to use {{org.apache.hadoop.fs.Path.SEPARATOR}} instead of > {{System.getProperty("file.separator")}}. -- This message was sent by Atlassian JIRA (v6.4.14#64029)