update dpguest.tmp_guorenchao_report
set prepay_payment_amt = fi.my_prepay_amt,
actual_payment_st_cash_amt = fi.my_actual_payment_st_cash_amt
from dpguest.tmp_guorenchao_first fi ,dpguest.tmp_guorenchao_report re
where re.deal_id = fi.deal_id and re.monthid = fi.monthid这样报错
ERROR: Cannot parallelize that UPDATE yet
DETAIL: Passage of data from one segment to another is not yet supported during UPDATE operations.
HINT: The WHERE condition must specify equality between corresponding DISTRIBUTED BY columns of the target table and all joined tables.
小菜求大鸟们指点!!
set prepay_payment_amt = fi.my_prepay_amt,
actual_payment_st_cash_amt = fi.my_actual_payment_st_cash_amt
from dpguest.tmp_guorenchao_first fi ,dpguest.tmp_guorenchao_report re
where re.deal_id = fi.deal_id and re.monthid = fi.monthid这样报错
ERROR: Cannot parallelize that UPDATE yet
DETAIL: Passage of data from one segment to another is not yet supported during UPDATE operations.
HINT: The WHERE condition must specify equality between corresponding DISTRIBUTED BY columns of the target table and all joined tables.
小菜求大鸟们指点!!
update dpguest.tmp_guorenchao_report
set prepay_payment_amt = fi.my_prepay_amt,
actual_payment_st_cash_amt = fi.my_actual_payment_st_cash_amt
from dpguest.tmp_guorenchao_first fi
where re.deal_id = fi.deal_id and re.monthid = fi.monthid