日志里报错: Function substring get failed

Viewed 13

2024-10-18 15:06:53,471 WARN (Analysis Job Executor-0|499) [FoldConstantRuleOnBE.evalOnBE():267] query 3d349ddf0cd84bc9-9a6da5b6f37acf4a failed to get const expr value from be: [(192.168.200.252)[INTERNAL_ERROR]Function substring get failed, expr is VectorizedFnCall[substring](arguments=String, Int32, Int32,return=String) and return type is String.]

这条sql应该是doris自己调用的:
SELECT
CONCAT( '1991826', '-', '-1', '-', 'company_id' ) AS id,
0 AS catalog_id,
472155 AS db_id,
1991826 AS tbl_id,
- 1 AS idx_id,
'company_id' AS col_id,
NULL AS part_id,
704 AS row_count,
SUM( t1.count ) * COUNT( 1 ) / (
SUM( t1.count ) - SUM(
IF
( t1.count = 1, 1, 0 )) + SUM(
IF
( t1.count = 1, 1, 0 )) * SUM( t1.count ) / 704
) AS ndv,
IFNULL( SUM( IF ( t1.column_key IS NULL, t1.count, 0 )), 0 ) * 1.0 AS null_count,
SUBSTRING( CAST( '4' AS STRING ), 1, 1024 ) AS min,
SUBSTRING( CAST( '1240' AS STRING ), 1, 1024 ) AS max,
SUM( t1.count ) * 16 * 1.0 AS data_size,
NOW()
FROM
(
SELECT
t0.company_id AS column_key,
COUNT( 1 ) AS count
FROM
( SELECT company_id FROM internal.feiwin.mrp_record_execute_class_count ) AS t0
GROUP BY
t0.company_id
) AS t1

1 Answers

2.1.2已知问题,升级2.1.6版本