ERROR: HY000] [Hortonworks][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask'. ?
Here's my code: using
(OdbcConnection mycon1 = new OdbcConnection(conn.hiveconnection())) { mycon1.Open(); using (cmd = mycon1.CreateCommand()) { cmd.CommandText = "insert into table tblname values(1,'test@gmail.com','1990-11-03','09123456789','NULL', 'FEMALE','','test123456789','2017-03-14 11:37:56.0', '0000-00-00 00-00-00.0',1,0,0,'test','address', '-','lname', '-','fname','03/28/2018 15:54:53','0000-00-00 00-00-00.0')"; cmd.ExecuteNonQuery(); } } mycon1.Close();
The Error will apply in this line: cmd.ExecuteNonQuery();
I've attached the screen shot from tez view. the app runs as hadoop user. i am using Horton Works Drive - ODBC. Is there something wrong in my query?
When I run the query in ambari it works. Can Anyone know this kind of problem? Please somebody help help. Thanks.
