SAP Knowledge Base Article - Preview

3558648 - Query with a dynamic "where" clause cannot be pushed down while using CamelJDBCAdapter or Generic JDBC - SAP SDI

Symptom

While using CamelJDBCAdapter (or Generic JDBC), a SQL query that contains a dynamic WHERE clause using current_date cannot be pushed down to the target system.

If a constant is used in the WHERE clause, then the query is pushed down correctly. For example:

  • SELECT * FROM <VT_name> WHERE for_date = 'YYYY-MM-DD';

If the current_date function is used, the query does not work correctly. For example:

  • SELECT * FROM <VT_name> WHERE for_date = 'current_date';


Read more...

Environment

  • SAP HANA Smart Data Integration
  • CamelJDBCAdapter (or Generic JDBC in Datasphere)

Product

SAP HANA smart data integration all versions

Keywords

MariaDB, filter, Postgre, PostgreSQL, camel jdbc, Datasphere , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , 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.