Quento zhang
03/06/2026, 2:05 AMCREATE EXTERNAL CATALOG oracle_catalog
PROPERTIES (
"type" = "jdbc",
"user" = "oracle",
"password" = "oraclepass",
"jdbc_uri" = "jdbc:oracle:thin:@//192.168.8.115:1521/XE",
"driver_url" = "file:///data/drivers/ojdbc8-21.3.0.0.jar",
"driver_class" = "oracle.jdbc.driver.OracleDriver",
"case_sensitive" = "true"
);
SELECT student_name FROM oracle_catalog.ORACLE.works_at LIMIT 1;
Error Message:
SQL 错误 [1064] [42000]: open JDBCScanner failed, error: java.sql.SQLSyntaxErrorException: ORA-00904: "STUDENT_NAME": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:937)
at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)
at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3855)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1098)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:96)
Caused by: Error : 904, Position : 22, Sql = SELECT * FROM (SELECT student_name FROM "ORACLE"."works_at") WHERE ROWNUM <= 1, OriginalSql = SELECT * FROM (SELECT student_name FROM "ORACLE"."works_at") WHERE ROWNUM <= 1, Error Msg = ORA-00904: "STUDENT_NAME": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
... 17 more
: BE:10004
#C02FACZSNJV