fansichao opened a new issue #2421: Insert Into 使用join和where时报错 URL: https://github.com/apache/incubator-doris/issues/2421 Sql语句如下 ```sql insert into nodeid_15759616930091501870 select col_b8ff236f9c8f5a51e1c7041b11c68378, col_035aa15235d66d9dc704c02de879badb from ( select `a`.col_b8ff236f9c8f5a51e1c7041b11c68378, 1 col_035aa15235d66d9dc704c02de879badb from nodeid_15759456123033821049 as a left JOIN nodeid_15759456123033821049_tmp as b on b.id=a.id -- and b.id=1 where b.id=1 ) a ``` 1. 当 join 和 where 同时存在时 ，insert into select 语句会报错， 单独 select xxxx 语句正常执行。 2. 将 where 语句 转为 and b.id=1 ， insert into 语句也会正常执行 3. 当创建目标表 buckets 为 1/1 时，insert into 语句也会正常执行 ```bash # 目标表默认参数 TABLE: nodeid_15759759282784611571 PREAGGREGATION: ON partitions=1/1 rollup: nodeid_15759759282784611571 buckets=10/10 cardinality=36 avgRowSize=685.2222 numNodes=3 tuple ids: 4 ``` 上述 insert into 语句执行报错为 all partitions have no load data
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
