3490623 - Cannot push down variables through CamelJDBCAdapter - SAP HANA Smart Data Integration

• Using CamelJDBCAdapter to connect to a remote source.
• Pushing down a query with a variable declared, for example:
  • DO 
    BEGIN
      DECLARE VARIABLE TIMESTAMP;
      SELECT CURRENT_EXTRACT_DATE INTO VARIABLE
            FROM TABLE_1;
      SELECT TOP 100 * FROM TABLE_2 
            WHERE LAST_UPDATE >= VARIABLE;
    END;
    
• Error message thrown in framework.trc:
  • [ERROR] [] DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: <ID> on ExchangeId: <ID>). Exhausted after delivery attempt: 1 caught: net.snowflake.client.jdbc.SnowflakeSQLException: Timestamp 'others' is not recognized
    
• Error message thrown in the SQL console:
  • Error:    Could not execute '<statement>'
    Error: (dberror) [403]: internal error: "<remote_source>": line 11 col 4 (at pos 289): Remote execution error Camel execution failed. for query <statement>
    
• The variable is treated as '?' in the SQL query.

SAP HANA smart data integration

CamelJDBCAdapter, variable, Camel execution failed , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem