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.
cmd.CommandText = "INSERT INTO TABLE SqlConTest VALUES('Mahendra')";
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)";