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