SAP Knowledge Base Article - Preview

2896909 - Hadoop Connection errors - Data Services

Symptom

  • Create a Hadoop ODBC datastore successfully, but importing tables fail with the following error.
    Error "Cannot open external table. SQL submitted to ODBC data source <> resulted in error. <[Cloudera][Hardy](80) Syntax or semantic analysis error thrown is server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near "SHOW" "INDEX" "ON" in DDL statement> The SQL submitted is <SHOW INDEX ON (table)> (BODI-1112347)
  • If the tables are imported, jobs may fail when reading from the Hadoop source table. Error message is in foreign language
    Error "SQL submitted to ODBC data source resulted in error <chinese characters> The SQL submitted is <SELECT column from table>
  • Hadoop connection works successfully from the Linux Server machine.


Read more...

Environment

  • SAP Data Services 14.2
  • Hadoop

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-DES , User Interface/Designer , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.