| buyingyi | c73348c | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | write [%0->$$26, %0->$$29, %0->$$30] |
| 2 | -- SINK_WRITE |PARTITIONED| |
| 3 | project ([$$26, $$29, $$30]) |
| 4 | -- STREAM_PROJECT |PARTITIONED| |
| 5 | assign [$$29, $$30] <- [function-call: hive:org.apache.hadoop.hive.ql.udf.UDFToDouble, Args:[%0->$$27], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFToDouble, Args:[%0->$$28]] |
| 6 | -- ASSIGN |PARTITIONED| |
| 7 | exchange |
| 8 | -- SORT_MERGE_EXCHANGE [$$26(ASC) ] |PARTITIONED| |
| 9 | order (ASC, %0->$$26) |
| 10 | -- STABLE_SORT [$$26(ASC)] |LOCAL| |
| 11 | exchange |
| 12 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 13 | group by ([$$26 := %0->$$34]) decor ([]) { |
| 14 | aggregate [$$27, $$28] <- [function-call: hive:sum(FINAL), Args:[%0->$$32], function-call: hive:sum(FINAL), Args:[%0->$$33]] |
| 15 | -- AGGREGATE |LOCAL| |
| 16 | nested tuple source |
| 17 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 18 | } |
| 19 | -- EXTERNAL_GROUP_BY[$$34] |PARTITIONED| |
| 20 | exchange |
| 21 | -- HASH_PARTITION_EXCHANGE [$$34] |PARTITIONED| |
| 22 | group by ([$$34 := %0->$$24]) decor ([]) { |
| 23 | aggregate [$$32, $$33] <- [function-call: hive:sum(PARTIAL1), Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.generic.GenericUDFWhen, Args:[function-call: algebricks:or, Args:[function-call: algebricks:eq, Args:[%0->$$6, 1-URGENT], function-call: algebricks:eq, Args:[%0->$$6, 2-HIGH]], 1, 0]], function-call: hive:sum(PARTIAL1), Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.generic.GenericUDFWhen, Args:[function-call: algebricks:and, Args:[function-call: algebricks:neq, Args:[%0->$$6, 1-URGENT], function-call: algebricks:neq, Args:[%0->$$6, 2-HIGH]], 1, 0]]] |
| 24 | -- AGGREGATE |LOCAL| |
| 25 | nested tuple source |
| 26 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 27 | } |
| 28 | -- EXTERNAL_GROUP_BY[$$24] |LOCAL| |
| 29 | exchange |
| 30 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 31 | project ([$$6, $$24]) |
| 32 | -- STREAM_PROJECT |PARTITIONED| |
| 33 | exchange |
| 34 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 35 | join (function-call: algebricks:eq, Args:[%0->$$10, %0->$$1]) |
| 36 | -- HYBRID_HASH_JOIN [$$10][$$1] |PARTITIONED| |
| 37 | exchange |
| 38 | -- HASH_PARTITION_EXCHANGE [$$10] |PARTITIONED| |
| 39 | project ([$$10, $$24]) |
| 40 | -- STREAM_PROJECT |PARTITIONED| |
| 41 | select (function-call: algebricks:and, Args:[function-call: algebricks:lt, Args:[%0->$$22, 1995-01-01], function-call: algebricks:ge, Args:[%0->$$22, 1994-01-01], function-call: algebricks:lt, Args:[%0->$$20, %0->$$21], function-call: algebricks:lt, Args:[%0->$$21, %0->$$22], function-call: algebricks:lt, Args:[%0->$$20, %0->$$21], function-call: algebricks:ge, Args:[%0->$$22, 1994-01-01], function-call: algebricks:lt, Args:[%0->$$22, 1995-01-01], function-call: algebricks:or, Args:[function-call: algebricks:eq, Args:[%0->$$24, MAIL], function-call: algebricks:eq, Args:[%0->$$24, SHIP]], function-call: algebricks:or, Args:[function-call: algebricks:eq, Args:[%0->$$24, MAIL], function-call: algebricks:eq, Args:[%0->$$24, SHIP]]]) |
| 42 | -- STREAM_SELECT |PARTITIONED| |
| 43 | exchange |
| 44 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 45 | data-scan [$$21, $$20, $$22, $$24, $$10]<-[$$10, $$11, $$12, $$13, $$14, $$15, $$16, $$17, $$18, $$19, $$20, $$21, $$22, $$23, $$24, $$25] <- default.lineitem |
| 46 | -- DATASOURCE_SCAN |PARTITIONED| |
| 47 | exchange |
| 48 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 49 | empty-tuple-source |
| 50 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| 51 | exchange |
| 52 | -- HASH_PARTITION_EXCHANGE [$$1] |PARTITIONED| |
| 53 | data-scan [$$1, $$6]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9] <- default.orders |
| 54 | -- DATASOURCE_SCAN |PARTITIONED| |
| 55 | exchange |
| 56 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 57 | empty-tuple-source |
| 58 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |