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.

Exception while executing insert statement in hive

Exception while executing insert statement in hive

New Contributor

ERROR [HY000] [Microsoft][HiveODBC] (35) Error from Hive: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'

insert into table EmployeeInfo values ( 000,'FirstName', 'LastName', 2, 1)

1 REPLY 1

Re: Exception while executing insert statement in hive

I think we'd need a lot more information to be able to help here. Can you look in the hiveserver2 log to check what the full error is? Please post the full error. The odbc driver error won't reveal much.

Is a YARN application launched or does it fail immediately? Check the Resource Manager UI to see if an application is launched.

Furthermore: is hive up and running? Are you able to execute other queries over the ODBC connection? Are you able to execute queries directly in beeline?