starrocks error: cannot obtain cte statistics for LogicalCTEConsumeOperator on Version 3.3.0 and 3.3.2

[chathawee]

Steps to reproduce the behavior (Required)

On the version 3.2.7, we can run the complex CTE query but after upgrading to version 3.3.0 and 3.3.2. The same query was failed with the error "starrocks error: cannot obtain cte statistics for LogicalCTEConsumeOperator{cteId=‘2’, limit=-1, predicate=null}"

Expected behavior (Required)

The issue happen on Version 3.3.0 and 3.3.2

Real behavior (Required)

Can't run complex CTE query

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()
• Issue happen on 3.3.0 and 3.3.2

This is on version 3.2.7

After upgrading to version 3.3.0 and 3.3.2

Solution for now
We rollback to version 3.2.7 and this query can run on it.

[jenwitteng]

https://github.com/StarRocks/starrocks/blob/main/fe/fe-core/src/main/java/com/starrocks/sql/optimizer/CTEUtils.java#L118
Can it just add

try {
            statisticsCalculator.estimatorStats();
        } catch (Exception e) {
            LOG.warn("Failed to calculate statistics for expression: {}", expr, e);
            return;
        }

same as this one
https://github.com/StarRocks/starrocks/blob/main/fe/fe-core/src/main/java/com/starrocks/sql/optimizer/Utils.java#L800-L805

[chathawee]

https://github.com/StarRocks/starrocks/blob/main/fe/fe-core/src/main/java/com/starrocks/sql/optimizer/CTEUtils.java#L118 Can it just add

try {
            statisticsCalculator.estimatorStats();
        } catch (Exception e) {
            LOG.warn("Failed to calculate statistics for expression: {}", expr, e);
            return;
        }

same as this one https://github.com/StarRocks/starrocks/blob/main/fe/fe-core/src/main/java/com/starrocks/sql/optimizer/Utils.java#L800-L805

This is work for us. We can query the complex CTE query
Why the version 3.2.7 didn't happen this issue?

[Seaven]

I need replay this question, could you provide the result file accord the docs: https://docs.starrocks.io/docs/3.2/faq/Dump_query/