3715359 - [CamelJdbcAdapter] Syntax errors when using functions in SQL commands - SAP HANA Smart Data Integration - Hub KBA

• Syntax error thrown when using CamelJdbcAdapter and issuing SQL commands that include functions.
• The syntax error may vary depending on the source database, but can be similar to the following:
  • Example from BigQuery:
    [ERROR] [] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(): com.sap.hana.dp.adapter.sdk.AdapterException: [Adapter error] Camel execution failed. Reason: [<JDBC_driver>]() Error executing query job. Message: 400 Bad Request
                                    POST [URL]
                                    {
                                      "code": 400,
                                      "errors": [
                                        {
                                          "domain": "global",
                                          "location": "q",
                                          "locationType": "parameter",
                                          "message": "Syntax error: Expected \",\" but got \":\" at <n:n>",
                                          "reason": "invalidQuery"
                                        }
  • Example from Databricks:
    [ERROR] [] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: * on ExchangeId: *). Exhausted after delivery attempt: 1 caught: java.sql.SQLException: [<JDBC_driver>](500051) ERROR processing query/statement. Error Code: 0, SQL state: 42601, Query:<query>, 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 '<>'. SQLSTATE: 42601 (line <n>, pos <n>)

SAP HANA smart data integration 2.0

syntax error, cameljdbc, sql rewrite, sap hana, smart data integration, jdbc adapter, query failure, safe_cast, to_bigint, to_decimal, sql configuration, simba bigqueryjdbcdriver , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem