3490916 - Error "Syntax error at or near '100'" while previewing data through VT table - SAP HANA Smart Data Integration

• 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)

SAP HANA Smart Data Integration

SDI, dp agent, VT, top, limit, cameljdbcadapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem