abcCL opened a new issue, #63526: URL: https://github.com/apache/doris/issues/63526
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 4.0.4 ### What's Wrong? sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1105, 'errCode = 2, detailMessage = ()[INTERNAL_ERROR]MaterializationSinkOperatorX failed to find rpc_struct, backend_id=13389') [SQL: WITH logical_rows AS (SELECT `statistic_period` AS `statistic_period`,`region` AS `region`,`score_system` AS `score_system`,`indicator_name` AS `indicator_name`,`indicator_value` AS `indicator_value`,0 AS `__query_deleted` FROM `foil_external_doris_catalog_1457647042849792`.`test_foil`.`bj_finance_statistic_data`) SELECT `statistic_period`,`region`,`score_system`,`indicator_name`,`indicator_value` FROM logical_rows WHERE `__query_deleted` = 0 ORDER BY `indicator_name` ASC LIMIT %s OFFSET %s] [parameters: (10, 0)] ### What You Expected? 正常查询 不报错 ### How to Reproduce? 构建了一个 hive catalog WITH logical_rows AS (SELECT `statistic_period` AS `statistic_period`, `region` AS `region`, `score_system` AS `score_system`, `indicator_name` AS `indicator_name`, `indicator_value` AS `indicator_value`, 0 AS `__query_deleted` FROM `foil_external_doris_catalog_1457647042849792`.`test_foil`.`bj_finance_statistic_data`) SELECT `statistic_period`, `region`, `score_system`, `indicator_name`, `indicator_value` FROM logical_rows WHERE `__query_deleted` = 0 ORDER BY `indicator_name` ASC; 去掉 order by 后可以查询成功 ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
