SAP Knowledge Base Article - Preview

2846552 - Session testHiveSingleRecord SQL submitted to ODBC data source <HiveDrvr> resulted in error

Symptom

  • DBS-070404: |Session testHiveSingleRecord SQL submitted to ODBC data source <HiveDrvr> 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. 

Read more...

Environment

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

Product

SAP Data Services 4.2

Keywords

cloud, cloudera, sql, test, odbc, syntax, permissions, users, data source, , KBA , 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.