| buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | write [%0->$$4, %0->$$25, %0->$$28, %0->$$29, %0->$$32] |
| 2 | -- SINK_WRITE |PARTITIONED| |
| 3 | project ([$$4, $$25, $$28, $$29, $$32]) |
| 4 | -- STREAM_PROJECT |PARTITIONED| |
| 5 | exchange |
| 6 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 7 | join (function-call: algebricks:eq, Args:[%0->$$1, %0->$$25]) |
| 8 | -- HYBRID_HASH_JOIN [$$1][$$25] |PARTITIONED| |
| 9 | exchange |
| 10 | -- HASH_PARTITION_EXCHANGE [$$1] |PARTITIONED| |
| 11 | data-scan [$$1, $$4]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9, $$10, $$11, $$12, $$13, $$14, $$15, $$16] <- default.lineitem |
| 12 | -- DATASOURCE_SCAN |PARTITIONED| |
| 13 | exchange |
| 14 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 15 | empty-tuple-source |
| 16 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| 17 | exchange |
| 18 | -- HASH_PARTITION_EXCHANGE [$$25] |PARTITIONED| |
| 19 | project ([$$32, $$25, $$29, $$28]) |
| 20 | -- STREAM_PROJECT |PARTITIONED| |
| 21 | project ([$$25, $$17, $$28, $$29, $$32]) |
| 22 | -- STREAM_PROJECT |PARTITIONED| |
| 23 | exchange |
| 24 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 25 | join (function-call: algebricks:eq, Args:[%0->$$26, %0->$$17]) |
| 26 | -- HYBRID_HASH_JOIN [$$26][$$17] |PARTITIONED| |
| 27 | exchange |
| 28 | -- HASH_PARTITION_EXCHANGE [$$26] |PARTITIONED| |
| 29 | select (function-call: algebricks:and, Args:[function-call: algebricks:lt, Args:[%0->$$28, 30000], function-call: algebricks:lt, Args:[%0->$$28, 30000]]) |
| 30 | -- STREAM_SELECT |PARTITIONED| |
| 31 | exchange |
| 32 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 33 | data-scan [$$32, $$25, $$26, $$29, $$28]<-[$$25, $$26, $$27, $$28, $$29, $$30, $$31, $$32, $$33] <- default.orders |
| 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 [$$17] |PARTITIONED| |
| 41 | project ([$$17]) |
| 42 | -- STREAM_PROJECT |PARTITIONED| |
| 43 | select (function-call: algebricks:and, Args:[function-call: algebricks:lt, Args:[%0->$$17, 5], function-call: algebricks:lt, Args:[%0->$$17, 5]]) |
| 44 | -- STREAM_SELECT |PARTITIONED| |
| 45 | exchange |
| 46 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 47 | data-scan [$$17]<-[$$17, $$18, $$19, $$20, $$21, $$22, $$23, $$24] <- default.customer |
| 48 | -- DATASOURCE_SCAN |PARTITIONED| |
| 49 | exchange |
| 50 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 51 | empty-tuple-source |
| 52 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |