你能帮我回答下面的问题吗。我有三个输入表（表1，表2，表3）输出表应具有以下列日期：（合并所有付款日期、收款日期、到期日期）、付款金额（填写给定付款日期的正确金额）、收款金额（填写给定收款日期的正确金额）、到期金额（填写给定到期日期的正确金额），给定日期列的合计（付款金额+收款金额+到期金额）
wbgh16ku1#
Hive支架 FULL JOIN ，因此您可以使用：
FULL JOIN
select coalesce(t1.payment_date, t2.receiver_date, t3.maturity_date) as date, t1.payment_amount, t2.receive_amount, t3.maturity_amountfrom table1 t1 full join table2 t2 on t2.receive_date = t1.payment_date full join table3 t3 on t3.maturity_date in (t2.receive_date, t1.payment_date)
select coalesce(t1.payment_date, t2.receiver_date, t3.maturity_date) as date,
t1.payment_amount,
t2.receive_amount,
t3.maturity_amount
from table1 t1 full join
table2 t2
on t2.receive_date = t1.payment_date full join
table3 t3
on t3.maturity_date in (t2.receive_date, t1.payment_date)
1条答案
按热度按时间wbgh16ku1#
Hive支架
FULL JOIN，因此您可以使用：