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|