| { |
| "head" : { |
| "version" : 1, |
| "generator" : { |
| "type" : "ExplainHandler", |
| "info" : "" |
| }, |
| "type" : "APACHE_DRILL_PHYSICAL", |
| "options" : [ ], |
| "queue" : 0, |
| "resultMode" : "EXEC" |
| }, |
| "graph" : [ { |
| "pop" : "fs-scan", |
| "@id" : 23, |
| "files" : [ "maprfs:/drill/testdata/json_storage/lineitem/lineitem.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/lineitem", |
| "cost" : 26016.0 |
| }, { |
| "pop" : "project", |
| "@id" : 20, |
| "exprs" : [ { |
| "ref" : "`T73¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 23, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "fs-scan", |
| "@id" : 9, |
| "files" : [ "maprfs:/drill/testdata/json_storage/orders/orders.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/orders", |
| "cost" : 4403.0 |
| }, { |
| "pop" : "project", |
| "@id" : 7, |
| "exprs" : [ { |
| "ref" : "`T77¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 9, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 4403.0 |
| }, { |
| "pop" : "fs-scan", |
| "@id" : 24, |
| "files" : [ "maprfs:/drill/testdata/json_storage/supplier/supplier.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/supplier", |
| "cost" : 26.0 |
| }, { |
| "pop" : "project", |
| "@id" : 21, |
| "exprs" : [ { |
| "ref" : "`T72¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 24, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26.0 |
| }, { |
| "pop" : "hash-join", |
| "@id" : 18, |
| "left" : 21, |
| "right" : 20, |
| "conditions" : [ { |
| "relationship" : "==", |
| "left" : "`T72¦¦s_suppkey`", |
| "right" : "`T73¦¦l_suppkey`" |
| } ], |
| "joinType" : "INNER", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "fs-scan", |
| "@id" : 15, |
| "files" : [ "maprfs:/drill/testdata/json_storage/partsupp/partsupp.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/partsupp", |
| "cost" : 1931.0 |
| }, { |
| "pop" : "project", |
| "@id" : 13, |
| "exprs" : [ { |
| "ref" : "`T75¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 15, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 1931.0 |
| }, { |
| "pop" : "fs-scan", |
| "@id" : 12, |
| "files" : [ "maprfs:/drill/testdata/json_storage/nation/nation.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/nation", |
| "cost" : 4.0 |
| }, { |
| "pop" : "project", |
| "@id" : 10, |
| "exprs" : [ { |
| "ref" : "`T76¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 12, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 4.0 |
| }, { |
| "pop" : "fs-scan", |
| "@id" : 25, |
| "files" : [ "maprfs:/drill/testdata/json_storage/part/part.json" ], |
| "storage" : { |
| "type" : "file", |
| "enabled" : true, |
| "connection" : "maprfs:///", |
| "workspaces" : { |
| "root" : { |
| "location" : "/", |
| "writable" : false, |
| "storageformat" : null |
| }, |
| "tmp" : { |
| "location" : "/tmp", |
| "writable" : true, |
| "storageformat" : "csv" |
| }, |
| "drillTestDir" : { |
| "location" : "/drill/testdata/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirAmplab" : { |
| "location" : "/drill/testdata/amplab", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirP1" : { |
| "location" : "/drill/testdata/p1tests", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirStress" : { |
| "location" : "/drill/testdata/stress", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExchanges" : { |
| "location" : "/drill/testdata/exchanges_test", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirExplicit" : { |
| "location" : "/drill/testdata/explicit_cast", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchema" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirInformationSchemaHbase" : { |
| "location" : "/drill/testdata/information_schema", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirViews" : { |
| "location" : "/drill/testdata/views", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirJson" : { |
| "location" : "/drill/testdata/json_storage", |
| "writable" : true, |
| "storageformat" : "json" |
| }, |
| "drillTestDirText" : { |
| "location" : "/drill/testdata/text", |
| "writable" : true, |
| "storageformat" : "text" |
| }, |
| "drillTestDirUdfs" : { |
| "location" : "/drill/testdata/udfs", |
| "writable" : true, |
| "storageformat" : "parquet" |
| }, |
| "drillTestDirDatetime" : { |
| "location" : "/drill/testdata/datetime/datasources/", |
| "writable" : true, |
| "storageformat" : "parquet" |
| } |
| }, |
| "formats" : { |
| "psv" : { |
| "type" : "text", |
| "extensions" : [ "tbl" ], |
| "delimiter" : "|" |
| }, |
| "csv" : { |
| "type" : "text", |
| "extensions" : [ "csv" ], |
| "delimiter" : "," |
| }, |
| "tsv" : { |
| "type" : "text", |
| "extensions" : [ "tsv" ], |
| "delimiter" : "\t" |
| }, |
| "parquet" : { |
| "type" : "parquet" |
| }, |
| "json" : { |
| "type" : "json" |
| } |
| } |
| }, |
| "format" : { |
| "type" : "json" |
| }, |
| "selectionRoot" : "/drill/testdata/json_storage/part", |
| "cost" : 550.0 |
| }, { |
| "pop" : "project", |
| "@id" : 22, |
| "exprs" : [ { |
| "ref" : "`T74¦¦*`", |
| "expr" : "`*`" |
| } ], |
| "child" : 25, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 550.0 |
| }, { |
| "pop" : "filter", |
| "@id" : 19, |
| "child" : 22, |
| "expr" : "like(`T74¦¦p_name`, '%yellow%') ", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 137.5 |
| }, { |
| "pop" : "selection-vector-remover", |
| "@id" : 17, |
| "child" : 19, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 137.5 |
| }, { |
| "pop" : "hash-join", |
| "@id" : 16, |
| "left" : 18, |
| "right" : 17, |
| "conditions" : [ { |
| "relationship" : "==", |
| "left" : "`T73¦¦l_partkey`", |
| "right" : "`T74¦¦p_partkey`" |
| } ], |
| "joinType" : "INNER", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "project", |
| "@id" : 14, |
| "exprs" : [ { |
| "ref" : "`T74¦¦*`", |
| "expr" : "`T74¦¦*`" |
| }, { |
| "ref" : "`T72¦¦*`", |
| "expr" : "`T72¦¦*`" |
| }, { |
| "ref" : "`T73¦¦*`", |
| "expr" : "`T73¦¦*`" |
| } ], |
| "child" : 16, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "hash-join", |
| "@id" : 11, |
| "left" : 14, |
| "right" : 13, |
| "conditions" : [ { |
| "relationship" : "==", |
| "left" : "`T73¦¦l_suppkey`", |
| "right" : "`T75¦¦ps_suppkey`" |
| }, { |
| "relationship" : "==", |
| "left" : "`T73¦¦l_partkey`", |
| "right" : "`T75¦¦ps_partkey`" |
| } ], |
| "joinType" : "INNER", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "hash-join", |
| "@id" : 8, |
| "left" : 11, |
| "right" : 10, |
| "conditions" : [ { |
| "relationship" : "==", |
| "left" : "`T72¦¦s_nationkey`", |
| "right" : "`T76¦¦n_nationkey`" |
| } ], |
| "joinType" : "INNER", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "hash-join", |
| "@id" : 6, |
| "left" : 8, |
| "right" : 7, |
| "conditions" : [ { |
| "relationship" : "==", |
| "left" : "`T73¦¦l_orderkey`", |
| "right" : "`T77¦¦o_orderkey`" |
| } ], |
| "joinType" : "INNER", |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "project", |
| "@id" : 5, |
| "exprs" : [ { |
| "ref" : "`T76¦¦n_name`", |
| "expr" : "`T76¦¦n_name`" |
| }, { |
| "ref" : "`o_year`", |
| "expr" : "extractYear(`T77¦¦o_orderdate`) " |
| }, { |
| "ref" : "`amount`", |
| "expr" : "subtract(multiply(`T73¦¦l_extendedprice`, subtract(1, `T73¦¦l_discount`) ) , multiply(`T75¦¦ps_supplycost`, `T73¦¦l_quantity`) ) " |
| } ], |
| "child" : 6, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 26016.0 |
| }, { |
| "pop" : "hash-aggregate", |
| "@id" : 4, |
| "child" : 5, |
| "cardinality" : 1.0, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 19512.0, |
| "groupByExprs" : [ { |
| "ref" : "`T76¦¦n_name`", |
| "expr" : "`T76¦¦n_name`" |
| }, { |
| "ref" : "`o_year`", |
| "expr" : "`o_year`" |
| } ], |
| "aggrExprs" : [ { |
| "ref" : "`sum_profit`", |
| "expr" : "sum(`amount`) " |
| } ] |
| }, { |
| "pop" : "external-sort", |
| "@id" : 3, |
| "child" : 4, |
| "orderings" : [ { |
| "order" : "ASC", |
| "expr" : "`T76¦¦n_name`", |
| "nullDirection" : "UNSPECIFIED" |
| }, { |
| "order" : "DESC", |
| "expr" : "`o_year`", |
| "nullDirection" : "UNSPECIFIED" |
| } ], |
| "reverse" : false, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 2601.6 |
| }, { |
| "pop" : "selection-vector-remover", |
| "@id" : 2, |
| "child" : 3, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 2601.6 |
| }, { |
| "pop" : "project", |
| "@id" : 1, |
| "exprs" : [ { |
| "ref" : "`nation`", |
| "expr" : "`T76¦¦n_name`" |
| }, { |
| "ref" : "`o_year`", |
| "expr" : "`o_year`" |
| }, { |
| "ref" : "`sum_profit`", |
| "expr" : "`sum_profit`" |
| } ], |
| "child" : 2, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 2601.6 |
| }, { |
| "pop" : "screen", |
| "@id" : 0, |
| "child" : 1, |
| "initialAllocation" : 1000000, |
| "maxAllocation" : 10000000000, |
| "cost" : 2601.6 |
| } ] |
| } |
