| buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | write [%0->$$26] |
| 2 | -- SINK_WRITE |PARTITIONED| |
| 3 | exchange |
| 4 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 5 | group by ([]) decor ([]) { |
| 6 | aggregate [$$26] <- [function-call: hive:sum(FINAL), Args:[%0->$$28]] |
| 7 | -- AGGREGATE |LOCAL| |
| 8 | nested tuple source |
| 9 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 10 | } |
| 11 | -- EXTERNAL_GROUP_BY[] |PARTITIONED| |
| 12 | exchange |
| 13 | -- HASH_PARTITION_EXCHANGE [] |PARTITIONED| |
| 14 | group by ([]) decor ([]) { |
| 15 | aggregate [$$28] <- [function-call: hive:sum(PARTIAL1), Args:[function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPMultiply, Args:[%0->$$15, function-call: hive:org.apache.hadoop.hive.ql.udf.UDFOPMinus, Args:[1, %0->$$16]]]] |
| 16 | -- AGGREGATE |LOCAL| |
| 17 | nested tuple source |
| 18 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 19 | } |
| 20 | -- EXTERNAL_GROUP_BY[] |LOCAL| |
| 21 | exchange |
| 22 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 23 | project ([$$15, $$16]) |
| 24 | -- STREAM_PROJECT |PARTITIONED| |
| 25 | select (function-call: algebricks:or, Args:[function-call: algebricks:or, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:eq, Args:[%0->$$4, Brand#12], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$7, SM CASE||SM BOX||SM PACK||SM PKG]], function-call: algebricks:ge, Args:[%0->$$14, 1]], function-call: algebricks:le, Args:[%0->$$14, 11]], function-call: algebricks:ge, Args:[%0->$$6, 1]], function-call: algebricks:le, Args:[%0->$$6, 5]], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$24, AIR||AIR REG]], function-call: algebricks:eq, Args:[%0->$$23, DELIVER IN PERSON]], function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:eq, Args:[%0->$$4, Brand#23], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$7, MED BAG||MED BOX||MED PKG||MED PACK]], function-call: algebricks:ge, Args:[%0->$$14, 10]], function-call: algebricks:le, Args:[%0->$$14, 20]], function-call: algebricks:ge, Args:[%0->$$6, 1]], function-call: algebricks:le, Args:[%0->$$6, 10]], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$24, AIR||AIR REG]], function-call: algebricks:eq, Args:[%0->$$23, DELIVER IN PERSON]]], function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:and, Args:[function-call: algebricks:eq, Args:[%0->$$4, Brand#34], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$7, LG CASE||LG BOX||LG PACK||LG PKG]], function-call: algebricks:ge, Args:[%0->$$14, 20]], function-call: algebricks:le, Args:[%0->$$14, 30]], function-call: algebricks:ge, Args:[%0->$$6, 1]], function-call: algebricks:le, Args:[%0->$$6, 15]], function-call: hive:org.apache.hadoop.hive.ql.udf.UDFRegExp, Args:[%0->$$24, AIR||AIR REG]], function-call: algebricks:eq, Args:[%0->$$23, DELIVER IN PERSON]]]) |
| 26 | -- STREAM_SELECT |UNPARTITIONED| |
| 27 | exchange |
| 28 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 29 | join (function-call: algebricks:eq, Args:[%0->$$11, %0->$$1]) |
| 30 | -- HYBRID_HASH_JOIN [$$11][$$1] |PARTITIONED| |
| 31 | exchange |
| 32 | -- HASH_PARTITION_EXCHANGE [$$11] |PARTITIONED| |
| 33 | data-scan [$$11, $$14, $$15, $$16, $$23, $$24]<-[$$10, $$11, $$12, $$13, $$14, $$15, $$16, $$17, $$18, $$19, $$20, $$21, $$22, $$23, $$24, $$25] <- default.lineitem |
| 34 | -- DATASOURCE_SCAN |PARTITIONED| |
| 35 | exchange |
| 36 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 37 | empty-tuple-source |
| 38 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| 39 | exchange |
| 40 | -- HASH_PARTITION_EXCHANGE [$$1] |PARTITIONED| |
| 41 | data-scan [$$1, $$4, $$6, $$7]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9] <- default.part |
| 42 | -- DATASOURCE_SCAN |PARTITIONED| |
| 43 | exchange |
| 44 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 45 | empty-tuple-source |
| 46 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |