[Bug report] Cannot correctly obtain the information of Doris materialized views.
- Dominant language
- Java
- Stars
- 3.2k
- Forks
- 935
- Avg merge
- 1d 16h
- Merged PRs (30d)
- 298
Description
### Version
main branch
### Describe what's wrong
Currently, retrieving Doris materialized views will result in an error.
### Error message and/or stacktrace
Caused by: java.sql.SQLException: errCode = 2, detailMessage = not support async materialized view, please use `show create materialized view`
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1247) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.11.0.jar:2.11.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:318) ~[commons-dbcp2-2.11.0.jar:2.11.0]
at org.apache.gravitino.catalog.doris.operation.DorisTableOperations.getTablePartitioning(DorisTableOperations.java:414) ~[?:?]
at org.apache.gravitino.catalog.jdbc.operation.JdbcTableOperations.load(JdbcTableOperations.java:225) ~[?:?]
... 86 more
### How to reproduce
The issue can be reproduced by simply adding a Doris catalog and ensuring there is a materialized view in Doris, then attempting to view this materialized view.
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.