Symptom
- Virtual table (VT) created through CamelJDBCAdapter remote source to Databricks
- Preview data through VT failed with error:
- Error: "DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: *** on ExchangeId: ***). Exhausted after delivery attempt: 1 caught: java.sql.SQLException: [Databricks][JDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: 42601, Query: SELECT TOP***, Error message from Server: org.apache.hive.service.cli.HiveSQLException: Error running query: [PARSE_SYNTAX_ERROR] org.apache.spark.sql.catalyst.parser.ParseException:
[PARSE_SYNTAX_ERROR] Syntax error at or near '100'. SQLSTATE: 42601 (line 1, pos 11)
== SQL ==
SELECT TOP 100 *** AS ***
2024-05-27 10:59:02,990 [ERROR] [***] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(112): Exception while processing request "SDA Response for CamelJdbcAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT"
2024-05-27 10:59:02,990 [ERROR] [***] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(112): com.sap.hana.dp.adapter.sdk.AdapterException: Camel execution failed. Context: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[***]
at org.apache.camel.CamelExecutionException.wrapCamelExecutionException(CamelExecutionException.java:45)
Read more...
Environment
SAP HANA Smart Data Integration
Product
SAP HANA smart data integration 2.0
Keywords
SDI, dp agent, VT, top, limit, cameljdbcadapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.