SAP Knowledge Base Article - Preview

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

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.