| write [%0->$$1, %0->$$34, %0->$$29, %0->$$32] |
| -- SINK_WRITE |UNPARTITIONED| |
| limit 10 |
| -- STREAM_LIMIT |UNPARTITIONED| |
| limit 10 |
| -- STREAM_LIMIT |UNPARTITIONED| |
| exchange |
| -- SORT_MERGE_EXCHANGE [$$34(DESC) ] |PARTITIONED| |
| limit 10 |
| -- STREAM_LIMIT |LOCAL| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |LOCAL| |
| order (DESC, %0->$$34) |
| -- STABLE_SORT [$$34(DESC)] |LOCAL| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| project ([$$1, $$34, $$29, $$32]) |
| -- STREAM_PROJECT |PARTITIONED| |
| assign [$$34] <- [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]]] |
| -- ASSIGN |PARTITIONED| |
| project ([$$29, $$32, $$1, $$6, $$7]) |
| -- STREAM_PROJECT |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| join (function-call: algebricks:eq, Args:[%0->$$1, %0->$$25]) |
| -- HYBRID_HASH_JOIN [$$1][$$25] |PARTITIONED| |
| exchange |
| -- HASH_PARTITION_EXCHANGE [$$1] |PARTITIONED| |
| project ([$$1, $$6, $$7]) |
| -- STREAM_PROJECT |PARTITIONED| |
| select (function-call: algebricks:lt, Args:[%0->$$4, 3]) |
| -- STREAM_SELECT |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| data-scan [$$1, $$4, $$6, $$7]<-[$$1, $$2, $$3, $$4, $$5, $$6, $$7, $$8, $$9, $$10, $$11, $$12, $$13, $$14, $$15, $$16] <- default.lineitem |
| -- DATASOURCE_SCAN |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| empty-tuple-source |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| exchange |
| -- HASH_PARTITION_EXCHANGE [$$25] |PARTITIONED| |
| project ([$$25, $$29, $$32]) |
| -- STREAM_PROJECT |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| join (function-call: algebricks:eq, Args:[%0->$$26, %0->$$17]) |
| -- HYBRID_HASH_JOIN [$$26][$$17] |PARTITIONED| |
| exchange |
| -- HASH_PARTITION_EXCHANGE [$$26] |PARTITIONED| |
| data-scan [$$26, $$25, $$29, $$32]<-[$$25, $$26, $$27, $$28, $$29, $$30, $$31, $$32, $$33] <- default.orders |
| -- DATASOURCE_SCAN |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| empty-tuple-source |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
| exchange |
| -- HASH_PARTITION_EXCHANGE [$$17] |PARTITIONED| |
| project ([$$17]) |
| -- STREAM_PROJECT |PARTITIONED| |
| select (function-call: algebricks:eq, Args:[%0->$$23, BUILDING]) |
| -- STREAM_SELECT |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| data-scan [$$17, $$23]<-[$$17, $$18, $$19, $$20, $$21, $$22, $$23, $$24] <- default.customer |
| -- DATASOURCE_SCAN |PARTITIONED| |
| exchange |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| empty-tuple-source |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| |
