Hi All,
I see that all the logical plans in project are of old version and I am not
able to use these logical plans on the Drill Web interface.
Could any one please share a simple logical plan which I can use to test on
the web interface.
I need to use very simple operations like :
- read/scan from file
- project few columns
- store out on console/web interface
Also is there any way to view the logical plan directly from sql query as
well (similar to explain plan for <query>) ?
Thanks.
Here is my logical plan. Have tried using the new syntax but not completely
successful. Removed project operator since it was referring to old _MAP
syntax -
> {
> "head" : {
> "version" : 1,
> "generator" : {
> "type" : "manual",
> "info" : "manual"
> },
> "type" : "APACHE_DRILL_LOGICAL",
> "options" : null,
> "queue" : 0,
> "resultMode" : "EXEC"
> },
> "storage" : {
> "fs" : {
> "type" : "file",
> "enabled" : true,
> "connection" : "file:///",
> "workspaces" : null,
> "formats" : null
> }
> },
> "query" : [ {
> "op" : "scan",
> "@id" : 1,
> "storageengine" : "fs",
> "selection" : [ {
> "path" : "text/data/nations.csv"
> } ]
> }, {
> "op" : "store",
> "@id" : 2,
> "input" : 1,
> "target" : null,
> "storageEngine" : "fs"
> } ]
> }
>
>
> QueryResultBatch [header=query_state: FAILED
> query_id {
> part1: -4067623478689576886
> part2: -7119567730027840928
> }
> is_last_chunk: true
> error {
> error_id: "d6b91e72-8f58-4327-91ec-c6ef9d2fc86a"
> endpoint {
> address: "L-yash-tech"
> user_port: 31013
> control_port: 31014
> data_port: 31015
> }
> error_type: 0
> message: "Failure while setting up Foreman. Can not deserialize instance
> of org.apache.drill.exec.store.dfs.FormatSelection out of START_ARRAY
> token\n at [Source: N/A; line: -1, column: -1]
> [d6b91e72-8f58-4327-91ec-c6ef9d2fc86a]"
> }
> , data=null]
