SAP Knowledge Base Article - Preview

3716041 - [CamelJdbcAdapter] Syntax errors when connecting to Google BigQuery - SAP HANA Smart Data Integration

Symptom

  • Syntax error thrown when using CamelJdbcAdapter and issuing SQL commands towards Google BigQuery that include numeric conversion functions (e.g.: TO_DECIMAL).
  • The syntax error may vary depending on the specific syntax error, but will be similar to the following:
    [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"
                                        }


Read more...

Environment

SAP HANA smart data integration 2.0

Product

SAP HANA smart data integration 2.0

Keywords

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.