Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (1) SchemaRDD[173] at RDD at SchemaRDD.scala:108
- == Query Plan ==
- == Physical Plan ==
- InsertIntoHiveTable (MetastoreRelation tpch_100gb, q3_shipping_priority, None), Map(), true
- Project [l_orderkey#496,revenue#474,CAST(o_orderdate#491, StringType) AS o_orderdate#512,o_shippriority#494]
- TakeOrdered 10, [revenue#474 DESC,o_orderdate#491 ASC]
- Aggregate false, [l_orderkey#496,o_orderdate#491,o_shippriority#494], [l_orderkey#496,SUM(PartialSum#514) AS revenue#474,o_orderdate#491,o_shippriority#494]
- Exchange (HashPartitioning [l_orderkey#496,o_orderdate#491,o_shippriority#494], 200)
- Aggregate true, [l_orderkey#496,o_orderdate#491,o_shippriority#494], [l_orderkey#496,o_orderdate#491,o_shippriority#494,SUM((l_extendedprice#501 * (1.0 - l_discount#502))) AS PartialSum#514]
- Project [l_orderkey#496,o_orderdate#491,o_shippriority#494,l_extendedprice#501,l_discount#502]
- ShuffledHashJoin [o_orderkey#487], [l_orderkey#496], BuildRight
- Exchange (HashPartitioning [o_orderkey#487], 200)
- Project [o_shippriority#494,o_orderkey#487,o_orderdate#491]
- ShuffledHashJoin [c_custkey#479], [o_custkey#488], BuildLeft
- Exchange (HashPartitioning [c_custkey#479], 200)
- Project [c_custkey#479]
- Filter (c_mktsegment#485 = BUILDING)
- HiveTableScan [c_custkey#479,c_mktsegment#485], (MetastoreRelation tpch_100gb, customer, None), None
- Exchange (HashPartitioning [o_custkey#488], 200)
- Filter (o_orderdate#491 < 1995-03-15)
- HiveTableScan [o_shippriority#494,o_orderkey#487,o_orderdate#491,o_custkey#488], (MetastoreRelation tpch_100gb, orders, None), None
- Exchange (HashPartitioning [l_orderkey#496], 200)
- Project [l_orderkey#496,l_extendedprice#501,l_discount#502]
- Filter (l_shipdate#506 > 1995-03-15)
- HiveTableScan [l_orderkey#496,l_extendedprice#501,l_discount#502,l_shipdate#506], (MetastoreRelation tpch_100gb, lineitem, None), None []
- | ParallelCollectionRDD[213] at parallelize at commands.scala:46 []
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement