13057537919 commented on issue #1071:
URL: https://github.com/apache/doris-website/issues/1071#issuecomment-2322845795

   这么写才能成功,测试出with写法不支持与insert联用 
   INSERT into dexpdb.ods_asystem_mysql_goods_baseinfo   select * from 
titandb_32.titandb.goods_baseinfo where id BETWEEN (select breakpoint from  
dexpdb.dexp_access_breakpoint where source_table_name = 
'titandb_32.titandb.goods_baseinfo' and sink_table_name 
='dexpdb.ods_asystem_mysql_goods_baseinfo' order by ts desc limit 1) and 
(select max(id) as currentpoint from titandb_32.titandb.goods_baseinfo );
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to