| buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | write [%0->$$22, %0->$$23] |
| 2 | -- SINK_WRITE |PARTITIONED| |
| 3 | project ([$$22, $$23]) |
| 4 | -- STREAM_PROJECT |PARTITIONED| |
| 5 | assign [$$22, $$23] <- [function-call: hive:org.apache.hadoop.hive.ql.udf.UDFToInteger, Args:[%0->$$20], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFToInteger, Args:[%0->$$21]] |
| 6 | -- ASSIGN |PARTITIONED| |
| 7 | exchange |
| 8 | -- SORT_MERGE_EXCHANGE [$$21(DESC), $$20(DESC) ] |PARTITIONED| |
| 9 | order (DESC, %0->$$21) (DESC, %0->$$20) |
| 10 | -- STABLE_SORT [$$21(DESC), $$20(DESC)] |LOCAL| |
| 11 | exchange |
| 12 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 13 | group by ([$$20 := %0->$$28]) decor ([]) { |
| 14 | aggregate [$$21] <- [function-call: hive:count(FINAL), Args:[%0->$$27]] |
| 15 | -- AGGREGATE |LOCAL| |
| 16 | nested tuple source |
| 17 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 18 | } |
| 19 | -- EXTERNAL_GROUP_BY[$$28] |PARTITIONED| |
| 20 | exchange |
| 21 | -- HASH_PARTITION_EXCHANGE [$$28] |PARTITIONED| |
| 22 | group by ([$$28 := %0->$$19]) decor ([]) { |
| 23 | aggregate [$$27] <- [function-call: hive:count(PARTIAL1), Args:[1]] |
| 24 | -- AGGREGATE |LOCAL| |
| 25 | nested tuple source |
| 26 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 27 | } |
| 28 | -- EXTERNAL_GROUP_BY[$$19] |LOCAL| |
| 29 | exchange |
| 30 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 31 | project ([$$19]) |
| 32 | -- STREAM_PROJECT |PARTITIONED| |
| 33 | exchange |
| 34 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 35 | group by ([$$18 := %0->$$26]) decor ([]) { |
| 36 | aggregate [$$19] <- [function-call: hive:count(FINAL), Args:[%0->$$25]] |
| 37 | -- AGGREGATE |LOCAL| |
| 38 | nested tuple source |
| 39 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 40 | } |
| 41 | -- EXTERNAL_GROUP_BY[$$26] |PARTITIONED| |
| 42 | exchange |
| 43 | -- HASH_PARTITION_EXCHANGE [$$26] |PARTITIONED| |
| 44 | group by ([$$26 := %0->$$10]) decor ([]) { |
| 45 | aggregate [$$25] <- [function-call: hive:count(PARTIAL1), Args:[%0->$$1]] |
| 46 | -- AGGREGATE |LOCAL| |
| 47 | nested tuple source |
| 48 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 49 | } |
| 50 | -- EXTERNAL_GROUP_BY[$$10] |LOCAL| |
| 51 | exchange |
| 52 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 53 | project ([$$10, $$1]) |
| 54 | -- STREAM_PROJECT |PARTITIONED| |
| 55 | exchange |
| 56 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 57 | left outer join (function-call: algebricks:eq, Args:[%0->$$2, %0->$$10]) |
| 58 | -- HYBRID_HASH_JOIN [$$10][$$2] |PARTITIONED| |
| 59 | exchange |
| 60 | -- HASH_PARTITION_EXCHANGE [$$10] |PARTITIONED| |
| 61 | data-scan [$$10]<-[$$10, $$11, $$12, $$13, $$14, $$15, $$16, $$17] <- default.customer |
| 62 | -- DATASOURCE_SCAN |PARTITIONED| |
| 63 | exchange |
| 64 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 65 | empty-tuple-source |
| 66 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| 67 | exchange |
| 68 | -- HASH_PARTITION_EXCHANGE [$$2] |PARTITIONED| |
| 69 | project ([$$2, $$1]) |
| 70 | -- STREAM_PROJECT |PARTITIONED| |
| 71 | select (function-call: algebricks:not, Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.UDFLike, Args:[%0->$$9, %special%requests%]]) |
| 72 | -- STREAM_SELECT |PARTITIONED| |
| 73 | exchange |
| 74 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 75 | data-scan [$$1, $$2, $$9]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9] <- default.orders |
| 76 | -- DATASOURCE_SCAN |PARTITIONED| |
| 77 | exchange |
| 78 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 79 | empty-tuple-source |
| 80 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |