Ah perfectly what i was looking for. Thanks lot Aditya and Bob. On 08/10/2014 5:05 am, "Aditya" <[email protected]> wrote:
> "!set maxwidth 10000" is the key :) > > The JSON representation did not show up without it when I ran "explain plan > WITHOUT IMPLEMENTATION...". > > On Tue, Oct 7, 2014 at 4:31 PM, Bob Rumsby <[email protected]> wrote: > > > The EXPLAIN syntax for both physical plans and logical plans is > documented > > here: > > > > https://cwiki.apache.org/confluence/display/DRILL/EXPLAIN+Commands > > > > On Tue, Oct 7, 2014 at 4:24 PM, Aditya <[email protected]> wrote: > > > >> Here is the logical plan for the following query: > >> > >> SELECT employee_id , full_name FROM cp.`employee.json` where > department_id > >> = 16 order by last_name limit 50; > >> > >> { > >> "head" : { > >> "version" : 1, > >> "generator" : { > >> "type" : "org.apache.drill.exec.planner.logical.DrillImplementor", > >> "info" : "" > >> }, > >> "type" : "APACHE_DRILL_LOGICAL", > >> "options" : null, > >> "queue" : 0, > >> "resultMode" : "LOGICAL" > >> }, > >> "storage" : { > >> "cp" : { > >> "type" : "file", > >> "enabled" : true, > >> "connection" : "classpath:///", > >> "workspaces" : null, > >> "formats" : { > >> "csv" : { > >> "type" : "text", > >> "extensions" : [ "csv" ], > >> "delimiter" : "," > >> }, > >> "json" : { > >> "type" : "json" > >> }, > >> "parquet" : { > >> "type" : "parquet" > >> } > >> } > >> } > >> }, > >> "query" : [ { > >> "op" : "scan", > >> "@id" : 1, > >> "storageengine" : "cp", > >> "selection" : { > >> "format" : { > >> "type" : "named", > >> "name" : "json" > >> }, > >> "files" : [ "/employee.json" ] > >> } > >> }, { > >> "op" : "project", > >> "@id" : 2, > >> "input" : 1, > >> "projections" : [ { > >> "ref" : "`department_id`", > >> "expr" : "`department_id`" > >> }, { > >> "ref" : "`employee_id`", > >> "expr" : "`employee_id`" > >> }, { > >> "ref" : "`full_name`", > >> "expr" : "`full_name`" > >> }, { > >> "ref" : "`last_name`", > >> "expr" : "`last_name`" > >> } ] > >> }, { > >> "op" : "filter", > >> "@id" : 3, > >> "input" : 2, > >> "expr" : "equal(cast( (`department_id` ) as INT ), 16) " > >> }, { > >> "op" : "project", > >> "@id" : 4, > >> "input" : 3, > >> "projections" : [ { > >> "ref" : "`employee_id`", > >> "expr" : "`employee_id`" > >> }, { > >> "ref" : "`full_name`", > >> "expr" : "`full_name`" > >> }, { > >> "ref" : "`last_name`", > >> "expr" : "`last_name`" > >> } ] > >> }, { > >> "op" : "order", > >> "@id" : 5, > >> "input" : 4, > >> "within" : null, > >> "orderings" : [ { > >> "order" : "ASC", > >> "expr" : "`last_name`", > >> "nullDirection" : "UNSPECIFIED" > >> } ] > >> }, { > >> "op" : "limit", > >> "@id" : 6, > >> "input" : 5, > >> "first" : 0, > >> "last" : 50 > >> }, { > >> "op" : "project", > >> "@id" : 7, > >> "input" : 6, > >> "projections" : [ { > >> "ref" : "`employee_id`", > >> "expr" : "`employee_id`" > >> }, { > >> "ref" : "`full_name`", > >> "expr" : "`full_name`" > >> } ] > >> }, { > >> "op" : "store", > >> "@id" : 8, > >> "input" : 7, > >> "target" : null, > >> "storageEngine" : "--SCREEN--" > >> } ] > >> } > >> > >> I couldn't find a way to print this but I think could be useful. Can you > >> please create a JIRA? > >> > >> > >> On Tue, Oct 7, 2014 at 11:31 AM, Yash Sharma <[email protected]> wrote: > >> > >> > 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] > >> > > >> > > > > >
