Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Getting 'ExecuteStatement finished with operation state: ERROR_STATE' using ODBC driver

Highlighted

Getting 'ExecuteStatement finished with operation state: ERROR_STATE' using ODBC driver

New Contributor

Getting this when running a query via PyOdbc using the HortonWorks ODBC drive.

Execution failed on sql 'Select count(*) as rec_cnt from car.lpa_tax_rpt where id_eval <> 1': ('HY000', "[HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'. (35) (SQLExecDirectW)")

Queries run fine if there is no WHERE clause.

Anyone run across this issue? Thx!

Don't have an account?
Coming from Hortonworks? Activate your account here