Cloudera Community
cc_james_liu
user rank
New Contributor

Re: Hive ODBC Exception - ERROR [HY000] [Hortonwor...

by New Contributor in Support Questions
‎06-29-2017 07:14 PM
1 Kudo
‎06-29-2017 07:14 PM
1 Kudo
BTW, I increased the "Binary column length" in the ODBC connection's advanced options, and now I am getting another error "[Hortonworks][Hardy] (71) Failed to establish connection with unknown error." It seems, for some reason, the server dropped the connection, but only for files >30 MB? ... View more

Hive ODBC Exception - ERROR [HY000] [Hortonworks][...

by New Contributor in Support Questions
‎06-22-2017 08:42 PM
‎06-22-2017 08:42 PM
Hi folks, I was working on using C# to pull binary content from Hive over ODBC, but ran into an exception when the BLOB size is over 30MB. The query was straightforward and retrieves one record with BLOB content. Any thoughts? Thank you. DbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) // Exception happened here when the BLOB content is over 30MB { if (dr != null) { report.id = dr.GetInt32(0); report.date = Convert.ToDateTime(dr.GetString(1)); report.content = Convert.FromBase64String(handleBase64Length(dr.GetString(2))); } } -$exception{"ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=18795eba-6e6f-4a66-930a-1da6a5ed4521]'."}System.Data.Odbc.OdbcException ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎07-21-2017 02:50 AM
Community Statistics
Member Since ‎06-22-2017 08:29 PM
Last Visited ‎07-21-2017 02:50 AM
Posts 2
Kudos received 1