search

apache / doris-website

Apache Doris Website
https://doris.apache.org/
78 stars 191 forks source link

采用with 写法，不能用insert，只能将源表select语句拼接在insert后面才能执行。脚本写的非常不优雅 #1071

Open 13057537919 opened 2 weeks ago

13057537919 commented 2 weeks ago

Path:/zh-CN/docs/data-operate/import/insert-into-manual 49b2d0087b857341acf067295d9b7b8 336a1b8ab006509d19b37f841c3bf30

13057537919 commented 2 weeks ago

这么写才能成功，测试出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 );