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.

Problem Insert into Hive Hortonworks Hive ODBC Driver

Highlighted

Problem Insert into Hive Hortonworks Hive ODBC Driver

I am using Hortonworks Hive ODBC Driver for Windows in C#.net code. Getting below error while inserting the data in Hive Table (used single Column Table)

“ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'”

Am able to select data and create table in HIVE with above ODBC driver.

Code:-

cmd.CommandText = "INSERT INTO TABLE SqlConTest VALUES('Mahendra')";

int noofrows=cmd.ExecuteNonQuery();

2 REPLIES 2
Highlighted

Re: Problem Insert into Hive Hortonworks Hive ODBC Driver

Guru
@Mahendra Dahiya

Can you ensure that you do have a table with the name "SqlConTest" ? And, is that the full exception ?

Highlighted

Re: Problem Insert into Hive Hortonworks Hive ODBC Driver

Table already exist in HIVE environment, I had created table with the help of below commands. Yes, that is the full exception I am getting.

cmd.CommandText = "CREATE TABLE SqlConTest(name string)";

cmd.ExecuteReader();

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