Closed marsupialtail closed 1 year ago
handle situations where a table is used in two places in a pipelined plan. Not common in normal SQL, but note:
d1 = customer.join(nation, left_on = "c_nationkey", right_on = "n_nationkey") d1 = d1.join(orders, left_on = "c_custkey", right_on = "o_custkey", suffix = "_3") d2 = supplier.join(nation, left_on="s_nationkey", right_on = "n_nationkey") d2 = lineitem.join(d2, left_on = "l_suppkey", right_on = "s_suppkey", suffix = "_3")
d = d1.join(d2, left_on = "o_orderkey", right_on = "l_orderkey",suffix="_4")
deferred to until someone complains
handle situations where a table is used in two places in a pipelined plan. Not common in normal SQL, but note:
d1 = customer.join(nation, left_on = "c_nationkey", right_on = "n_nationkey") d1 = d1.join(orders, left_on = "c_custkey", right_on = "o_custkey", suffix = "_3") d2 = supplier.join(nation, left_on="s_nationkey", right_on = "n_nationkey") d2 = lineitem.join(d2, left_on = "l_suppkey", right_on = "s_suppkey", suffix = "_3")
d = d1.join(d2, left_on = "o_orderkey", right_on = "l_orderkey",suffix="_4")