Re: doris查询报错

[Yongqiang YANG]

Could you try 2.0.5?

On Tue, Mar 5, 2024 at 2:08 PM 18 <1835996...@qq.com.invalid> wrote:

> doris版本：2.0.3&nbsp;
> 建表语句：
> CREATE TABLE IF NOT EXISTS table(
> &nbsp; &nbsp; `batch_number` DATETIME&nbsp; &nbsp;NOT NULL COMMENT '批次号',
> &nbsp; &nbsp; `analysis_dt` DATETIME NOT NULL&nbsp; &nbsp;COMMENT '统计日期' ,
> &nbsp; &nbsp; `steward_id` INT(11) NOT NULL&nbsp; &nbsp;COMMENT '管家ID' ,
> &nbsp; &nbsp; `num` INT&nbsp; &nbsp; COMMENT '数量' ,
> &nbsp; &nbsp; `dw_process_dt` DATETIME&nbsp; &nbsp; COMMENT '数据同步时间'&nbsp;
> )
> UNIQUE KEY(batch_number,analysis_dt,steward_id)
> PARTITION BY RANGE(batch_number)
> (
> &nbsp; &nbsp;FROM ("2023-10-18 07") TO ("2030-12-31 07") INTERVAL 24 HOUR
> )
> DISTRIBUTED BY HASH(batch_number,analysis_dt,steward_id) BUCKETS 5
> PROPERTIES (
> &nbsp; &nbsp; &nbsp; &nbsp; "replication_num" = "3"
> );
>
> 查询语句：
> select&nbsp;
>         steward_id,
>         sum(num)
> from table
> where&nbsp; batch_number in (
>         select max(batch_number)&nbsp;
>         from
> ads_op.ads_op_benifit_wecom_report_all_steward_d_with_history&nbsp;
> )&nbsp;
> and analysis_dt &gt;= '2024-01-01'&nbsp;
> and analysis_dt <= '2024-01-04'&nbsp;
> group by steward_id
>
> 报错信息：
> 1105 - errCode = 2, detailMessage =
> (10.51.26.25)[CANCELLED][INTERNAL_ERROR]failed to initialize storage
> reader. tablet=916117.1043288169.994c082d1ce15070-e8d4e4298a48d8bb,
> res=[NOT_IMPLEMENTED_ERROR]to be implemented
> &nbsp;&nbsp;
> &nbsp;  0#&nbsp;
> doris::RowwiseIterator::next_block_view(std::vector<doris::vectorized::IteratorRowRef,
> std::allocator<doris::vectorized::IteratorRowRef&gt; &gt;*) at
> /root/src/doris-2.0/be/src/olap/iterators.h:137
> &nbsp;  1#&nbsp;
> doris::BetaRowsetReader::next_block_view(std::vector<doris::vectorized::IteratorRowRef,
> std::allo
> &gt; 时间: 1.998s
>
>
>
> 如果把查询语句的子查询换成：where&nbsp; batch_number = '2024-03-05 06:00:00'&nbsp; 就不会报错。
> 请问下这是什么原因？