[
https://issues.apache.org/jira/browse/DRILL-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva resolved DRILL-4640.
-------------------------------------
Resolution: Fixed
Merged into Apache master with commit id
7506cfbb5c8522d371c12dbdc2268d48a9449a48
> 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: 1.12.0
>
>
> 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)
