MRYOG opened a new issue #7596: URL: https://github.com/apache/incubator-doris/issues/7596
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 0.15.0-rc04 ### What's Wrong? SQL : select distinct c.cate_id,a.app_id from dim_stand_app a join dim_category b on a.app_id = b.stand_app_id join dim_cate c on b.cate_id = c.cate_id join dim_app d on c.parent_id = d.id join ids_app_rank e on a.app_id = e.standard_app_id where a.status = 1 and b.status = 1 and b.mark = 1 and c.status = 1 and e.month_id between 202101 and 202106 Execution failed: Error Failed to execute sql: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: errCode = 2, detailMessage = Unknown column 'parent_id' in 'c' if join dim_cate c on b.cate_id = c.cate_id replace left join or right join is ok ### What You Expected? I expect the up SQL to be executed successfully or other function make sql successfully ### How to Reproduce? _No response_ ### 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]
