| buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | write [%0->$$18, %0->$$19] |
| 2 | -- SINK_WRITE |PARTITIONED| |
| 3 | project ([$$18, $$19]) |
| 4 | -- STREAM_PROJECT |PARTITIONED| |
| 5 | exchange |
| 6 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 7 | group by ([$$17 := %0->$$23]) decor ([]) { |
| 8 | aggregate [$$18, $$19] <- [function-call: hive:sum(FINAL), Args:[%0->$$21], function-call: hive:sum(FINAL), Args:[%0->$$22]] |
| 9 | -- AGGREGATE |LOCAL| |
| 10 | nested tuple source |
| 11 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 12 | } |
| 13 | -- EXTERNAL_GROUP_BY[$$23] |PARTITIONED| |
| 14 | exchange |
| 15 | -- HASH_PARTITION_EXCHANGE [$$23] |PARTITIONED| |
| 16 | group by ([$$23 := %0->$$9]) decor ([]) { |
| 17 | aggregate [$$21, $$22] <- [function-call: hive:sum(PARTIAL1), Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.UDFAbs, Args:[%0->$$5]], function-call: hive:sum(PARTIAL1), Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPMultiply, Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPMultiply, Args:[%0->$$6, function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPMinus, Args:[1, %0->$$7]], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPPlus, Args:[1, %0->$$8]]]] |
| 18 | -- AGGREGATE |LOCAL| |
| 19 | nested tuple source |
| 20 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 21 | } |
| 22 | -- EXTERNAL_GROUP_BY[$$9] |LOCAL| |
| 23 | exchange |
| 24 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 25 | project ([$$9, $$5, $$6, $$7, $$8]) |
| 26 | -- STREAM_PROJECT |PARTITIONED| |
| 27 | select (function-call: algebricks:le, Args:[%0->$$11, 1998-09-02]) |
| 28 | -- STREAM_SELECT |PARTITIONED| |
| 29 | exchange |
| 30 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 31 | data-scan [$$5, $$6, $$7, $$8, $$9, $$11]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9, $$10, $$11, $$12, $$13, $$14, $$15, $$16] <- default.lineitem |
| 32 | -- DATASOURCE_SCAN |PARTITIONED| |
| 33 | exchange |
| 34 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 35 | empty-tuple-source |
| 36 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |