SR 3.0.4 (To be deprecated) 外部表 sqlserver2012 查询异常
be.log .异常信息
W0915 13:56:25.949805 9520 pipeline_driver.cpp:279] pull_chunk returns not ok status Internal error: open JDBCScanner failed, error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘501’.[com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServe
rException.java:265), com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatemen
t$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537), com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417), com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488), com.microsoft.sqlserver.jdbc.SQLServerStatement.executeComm
and(SQLServerStatement.java:262), com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:456), com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQ
uery(ProxyPreparedStatement.java:52), com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java), com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:68)]
/build/starrocks/be/src/exec/jdbc_scanner.cpp:51 _init_jdbc_scanner()
/build/starrocks/be/src/connector/jdbc_connector.cpp:150 _scanner->open(state)
/build/starrocks/be/src/connector/jdbc_connector.cpp:84 _create_scanner(state)
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:509 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:224 _get_scan_status()
W0915 13:56:25.949898 9520 pipeline_driver_executor.cpp:152] [Driver] Process error, query_id=9b336e8f-538c-11ee-b301-5cba2c293c74, instance_id=9b336e8f-538c-11ee-b301-5cba2c293c75, status=Internal error: open JDBCScanner failed, error: com.microsoft.sqlserver.jdbc.SQLServerException: Inc
orrect syntax near ‘501’.[com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265), com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePrepar
edStatement(SQLServerPreparedStatement.java:615), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537), com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417), com.microsoft.sqlserver.jdbc.SQLServerConnection.ex
ecuteCommand(SQLServerConnection.java:3488), com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262), com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237), com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.e
xecuteQuery(SQLServerPreparedStatement.java:456), com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52), com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java), com.starrocks.jdbcbridge.JDBCScanner.open(JDBCS
canner.java:68)]
/build/starrocks/be/src/exec/jdbc_scanner.cpp:51 _init_jdbc_scanner()
/build/starrocks/be/src/connector/jdbc_connector.cpp:150 _scanner->open(state)
/build/starrocks/be/src/connector/jdbc_connector.cpp:84 _create_scanner(state)
/build/starrocks/be/src/exec/pipeline/scan/connector_scan_operator.cpp:509 _data_source->open(state)
/build/starrocks/be/src/exec/pipeline/scan/scan_operator.cpp:224 _get_scan_status()