SAP Knowledge Base Article - Preview

3278495 - Select query causes syntax error using CamelJdbcAdapter- SAP HANA Smart Data Integration

Symptom

  • Connection to Azure DataBricks through HANA SDI Camel Adapter works fine.
  • Able to get the table list an from the table metadata.
  • Running the SQL Statement in a isql session (HANA ODBC Databricks connection) gets result.
  • Running a simple select query HANA SDI Camel Adapter causes following error:
    SELECT "DatabricksTest"."date", "DatabricksTest"."client_id", "DatabricksTest"."engagement_score", "DatabricksTest"."date_part" FROM "clean"."databricks_test_table_ci_cd_csv" "DatabricksTest" [PARSE_SYNTAX_ERROR] org.apache.spark.sql.catalyst.parser.ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near '"xxxx"'
  • Similar error might happen to other database connection: "java.sql.SQLSyntaxErrorException"


Read more...

Environment

  • CamelJdbcAdapter Version: 2.5.2 with SDKVersion: 10 (2.5.2)
  • Azure DatabricksJDBC42-2.6.29.1051 

Product

SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0

Keywords

CamelAdapter, HANAsdi, databricks, parsing,starrocks , 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.