[GitHub] [incubator-doris] fansichao opened a new issue #2421: Insert Into 使用join和where时报错

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services

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