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)
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?