apache / apache/gravitino

[Bug report] Cannot correctly obtain the information of Doris materialized views.

Open
#7,473 2 comments 0 reactions 1 assignee Claimed by @yuqi1129 View on GitHub
bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.