-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpysicalPlan
7 lines (7 loc) · 4.56 KB
/
pysicalPlan
1
2
3
4
5
6
7
{
"columns" : [ "text", "json" ],
"rows" : [ {
"json" : "{ \"head\" : { \"version\" : 1, \"generator\" : { \"type\" : \"ExplainHandler\", \"info\" : \"\" }, \"type\" : \"APACHE_DRILL_PHYSICAL\", \"options\" : [ ], \"queue\" : 0, \"resultMode\" : \"EXEC\" }, \"graph\" : [ { \"pop\" : \"fs-scan\", \"@id\" : 7, \"userName\" : \"root\", \"files\" : [ \"hdfs://parasilo-3.rennes.grid5000.fr:8020/user/meterdata/file0.csv\" ], \"storage\" : { \"type\" : \"file\", \"enabled\" : true, \"connection\" : \"hdfs://parasilo-3.rennes.grid5000.fr:8020/\", \"config\" : null, \"workspaces\" : { \"root\" : { \"location\" : \"/user/root/drill\", \"writable\" : true, \"defaultInputFormat\" : null }, \"meterdata\" : { \"location\" : \"/user/meterdata\", \"writable\" : true, \"defaultInputFormat\" : null }, \"sdata\" : { \"location\" : \"/user/sample-data\", \"writable\" : true, \"defaultInputFormat\" : null } }, \"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\", \"extensions\" : [ \"json\" ] }, \"avro\" : { \"type\" : \"avro\" }, \"sequencefile\" : { \"type\" : \"sequencefile\", \"extensions\" : [ \"seq\" ] }, \"csvh\" : { \"type\" : \"text\", \"extensions\" : [ \"csvh\" ], \"extractHeader\" : true, \"delimiter\" : \",\" } } }, \"format\" : { \"type\" : \"text\", \"extensions\" : [ \"csv\" ], \"delimiter\" : \",\" }, \"columns\" : [ \"`columns`[2]\", \"`columns`[1]\" ], \"selectionRoot\" : \"hdfs://parasilo-3.rennes.grid5000.fr:8020/user/meterdata/file0.csv\", \"cost\" : 86913.0 }, { \"pop\" : \"project\", \"@id\" : 6, \"exprs\" : [ { \"ref\" : \"`ITEM`\", \"expr\" : \"`columns`[2]\" }, { \"ref\" : \"`ITEM1`\", \"expr\" : \"`columns`[1]\" } ], \"child\" : 7, \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 86913.0 }, { \"pop\" : \"filter\", \"@id\" : 5, \"child\" : 6, \"expr\" : \"booleanAnd(greater_than(cast( (`ITEM1` ) as INT ), 5) , less_than(cast( (`ITEM1` ) as INT ), 49000) ) \", \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 21728.25 }, { \"pop\" : \"selection-vector-remover\", \"@id\" : 4, \"child\" : 5, \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 21728.25 }, { \"pop\" : \"project\", \"@id\" : 3, \"exprs\" : [ { \"ref\" : \"`$f0`\", \"expr\" : \"cast( (`ITEM` ) as FLOAT8 )\" } ], \"child\" : 4, \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 21728.25 }, { \"pop\" : \"streaming-aggregate\", \"@id\" : 2, \"child\" : 3, \"keys\" : [ ], \"exprs\" : [ { \"ref\" : \"`EXPR$0`\", \"expr\" : \"sum(`$f0`) \" } ], \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 1.0 }, { \"pop\" : \"project\", \"@id\" : 1, \"exprs\" : [ { \"ref\" : \"`EXPR$0`\", \"expr\" : \"`EXPR$0`\" } ], \"child\" : 2, \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 1.0 }, { \"pop\" : \"screen\", \"@id\" : 0, \"child\" : 1, \"initialAllocation\" : 1000000, \"maxAllocation\" : 10000000000, \"cost\" : 1.0 } ]}",
"text" : "00-00 Screen00-01 Project(EXPR$0=[$0])00-02 StreamAgg(group=[{}], EXPR$0=[SUM($0)])00-03 Project($f0=[CAST($0):DOUBLE])00-04 SelectionVectorRemover00-05 Filter(condition=[AND(>(CAST($1):INTEGER, 5), <(CAST($1):INTEGER, 49000))])00-06 Project(ITEM=[ITEM($0, 2)], ITEM1=[ITEM($0, 1)])00-07 Scan(groupscan=[EasyGroupScan [selectionRoot=hdfs://parasilo-3.rennes.grid5000.fr:8020/user/meterdata/file0.csv, numFiles=1, columns=[`columns`[2], `columns`[1]], files=[hdfs://parasilo-3.rennes.grid5000.fr:8020/user/meterdata/file0.csv]]])"
} ]
}