Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Why does I get "ERROR: HY000] [Hortonworks][Hardy] (35) Error from server: error code: '1' "when I query in hive using my c# app but when I use Hive view its doing fine.

avatar
Contributor

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.


tez-screen-shot.png
1 REPLY 1

avatar
New Contributor

I am also having similar issue did you find the resolution for this ?

 

regards.