question Re: Problem connecting to Hive ODBC driver in Archives of Support Questions (Read Only)

Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 02:05:17 GMT

I'm trying to use the HW Hive ODBC driver; I've installed the package, set up a stanza in my odbc.ini, and put

.hortonworks.hiveodbc.ini in my $HOME. When I try connecting, I get the message:

ERROR: 0: HY000 : [DataDirect][ODBC lib] Unicode converter buffer overflow

I've tried adding "DriverUnicodeType=1" (and 2) to odbc.ini, to no avail. What can I try next.

Re: Problem connecting to Hive ODBC driver

nsabharwal — Tue, 15 Mar 2016 02:16:58 GMT

@Mark Lavin

See this http://www-01.ibm.com/support/docview.wss?uid=swg21580747

It may be a configuration setting at your end that needs to be changed in order to prevent the unicode converter buffer overflow

Re: Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 02:21:39 GMT

Thanks! for your reply. Sounds reasonable, but which configuration and what setting?

Re: Problem connecting to Hive ODBC driver

nsabharwal — Tue, 15 Mar 2016 02:25:49 GMT

@Mark Lavin odbc.ini

The DataDirect ODBC driver manager looks for a property that you can add to the Data Source Name (DSN) entry for the 3rd party driver in the .odbc.ini file to indicate if the driver is using 2 or 4 bytes for unicode.
Add the following property after the "driver=" line for the failing DSN in the .odbc.ini file:
DriverUnicodeType=1 
then test the failing scenario. If the error still occurs, then change the line to:
DriverUnicodeType=2

Re: Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 02:41:23 GMT

Yup, tried that, no luck.

Re: Problem connecting to Hive ODBC driver

divakarreddy_a — Tue, 15 Mar 2016 02:50:35 GMT

@Mark Lavin

Did you place all below three files in user's home directory?

-rwxr-xr-x 1 123 data 1298 Nov 24 22:02 .hortonworks.hiveodbc.ini

-rwxr-xr-x 1 123 data711 Nov 13 21:54 .odbc.ini

-rwxr-xr-x 1 123 data 336 Nov 13 21:55 .odbcinst.ini

Re: Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 02:58:43 GMT

Good questions. I placed .hortonworks.hiveodbc.ini in $HOME; for .odbc.ini, I actually have an odbc.ini in another directory but I set $ODCBINI to point to it; for .odbcinst.ini, I read that it was optional, so I omitted it.

Re: Problem connecting to Hive ODBC driver

divakarreddy_a — Tue, 15 Mar 2016 09:09:43 GMT

Did you install

[root@abc ~]# rpm -qa | grep hive-odbc-native

hive-odbc-native-2.0.0.1000-1.x86_64

[root@abc ~]#

Re: Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 20:16:15 GMT

No, the rpm package was named

hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm

Re: Problem connecting to Hive ODBC driver

malavin — Tue, 15 Mar 2016 23:28:56 GMT

Update: I had been using DataDirect as the ODBC Driver Manager. When I switched to unixODBC, the problem appears to have been resolved.