+ -
当前位置:首页 → 问答吧 → postgresql:Cannot parallelize that UPDATE yet

postgresql:Cannot parallelize that UPDATE yet

时间:2011-07-31

来源:互联网

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.
 小菜求大鸟们指点!!

作者: guo19890617   发布时间: 2011-07-31

from 后面多写了
SQL code
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


作者: trainee   发布时间: 2011-07-31