2846552 - Error: "SQL submitted to ODBC data source <ODBCSourceName> resulted in error" Data Services

• DBS-070404: |Session <jobname> SQL submitted to ODBC data source <ODBCHSourcename> resulted in error <[>. The SQL submitted is <select count(*) from
  <table name>>.
• clouderaodbcdriverforapachehive_connection_0.log
• ERROR 1571469120 ClassicQueryExecutor::Execute: [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:27 cannot recognize input near '<EOF>' '<EOF>' '<EOF>'
• ERROR 1571469120 StatementState::DoExecDirect: [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:27 cannot recognize input near '<EOF>' '<EOF>' '<EOF>'
• TRACE 1571469120 HardyQueryExecutor::~HardyQueryExecutor: +++++ enter +++++
• TRACE 1571469120 HardyDataEngine::~HardyDataEngine: +++++ enter +++++
• Linux command line using isql -v <odbc hive connection> successfully tested
• Able to view the Hive tables contents from the Data Services Designer, but only fails when the job is executed. 

• SAP Information Platform Services 4.x
• SAP Data Services 4.x
• Hive

cloud, cloudera, sql, test, odbc, syntax, permissions, users, data source, , KBA , EIM-DS-EXE , Job Execution , Problem