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