Support Questions

Find answers, ask questions, and share your expertise

Hive ODBC Driver for HDP 2.3 (v2.0.5) connectivity for CentOS 7

avatar
Rising Star

The documentation says it should have CentOS 5.0 or 6.0.

I also reffered https://community.hortonworks.com/questions/2210/libsasl-version-fro-hive-obdc-rhel-7.html.

I have 3 node cluster of HDP 2.3. o CentOS 7 when I try installing I get the following output:

[root@node1 enggusr]# yum --nogpgcheck localinstall hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm


Loaded plugins: fastestmirror, priorities
Examining hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm: hive-odbc-native-2.0.5.1005-1.x86_64
Marking hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package hive-odbc-native.x86_64 0:2.0.5.1005-1 will be installed
--> Processing Dependency: cyrus-sasl-gssapi(x86-64) >= 2.1.22 for package: hive-odbc-native-2.0.5.1005-1.x86_64
HDP-2.3                                                  | 2.9 kB     00:00
HDP-UTILS-1.1.0.20                                       | 2.9 kB     00:00
Updates-ambari-2.2.0.0                                   | 2.9 kB     00:00
base                                                     | 3.6 kB     00:00
extras                                                   | 3.4 kB     00:00
mysql-connectors-community                               | 2.5 kB     00:00
mysql-tools-community                                    | 2.5 kB     00:00
mysql56-community                                        | 2.5 kB     00:00
updates                                                  | 3.4 kB     00:00
Loading mirror speeds from cached hostfile
 * base: ftp.iitm.ac.in
 * extras: ftp.iitm.ac.in
 * updates: ftp.iitm.ac.in
--> Processing Dependency: cyrus-sasl-plain(x86-64) >= 2.1.22 for package: hive-odbc-native-2.0.5.1005-1.x86_64
--> Processing Dependency: libsasl2.so.2()(64bit) for package: hive-odbc-native-2.0.5.1005-1.x86_64
--> Running transaction check
---> Package cyrus-sasl-gssapi.x86_64 0:2.1.26-20.el7_2 will be installed
---> Package cyrus-sasl-plain.x86_64 0:2.1.26-20.el7_2 will be installed
---> Package hive-odbc-native.x86_64 0:2.0.5.1005-1 will be installed
--> Processing Dependency: libsasl2.so.2()(64bit) for package: hive-odbc-native-2.0.5.1005-1.x86_64
--> Finished Dependency Resolution
Error: Package: hive-odbc-native-2.0.5.1005-1.x86_64 (/hive-odbc-native-2.0.5.1005-1.el6.x86_64)
           Requires: libsasl2.so.2()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
1 ACCEPTED SOLUTION

avatar
Master Mentor
@Kunal Gaikwad

You have to resolve the dependencies.

Issue: You are using centos6 driver in centos7

[centos@nsnode1 ~]$ wget http://public-repo-1.hortonworks.com/HDP/hive-odbc/2.0.5.1005/centos6/hive-odbc-native-2.0.5.1005-1....

--2016-02-24 10:55:41-- http://public-repo-1.hortonworks.com/HDP/hive-odbc/2.0.5.1005/centos6/hive-odbc-native-2.0.5.1005-1....

Resolving public-repo-1.hortonworks.com (public-repo-1.hortonworks.com)... 54.230.141.82, 54.230.141.109, 54.230.141.150, ...

Connecting to public-repo-1.hortonworks.com (public-repo-1.hortonworks.com)|54.230.141.82|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 17057810 (16M) [application/x-rpm]

Saving to: ‘hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm’

100%[===========================================================================================================================================================>] 17,057,810 1.62MB/s in 11s

2016-02-24 10:55:52 (1.44 MB/s) - ‘hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm’ saved [17057810/17057810]

[centos@nsnode1 ~]$ rpm -i hive-odbc-native-2.0.5.1005-1.el6.x86_64.rpm

error: Failed dependencies:

cyrus-sasl-gssapi(x86-64) >= 2.1.22 is needed by hive-odbc-native-2.0.5.1005-1.x86_64

cyrus-sasl-plain(x86-64) >= 2.1.22 is needed by hive-odbc-native-2.0.5.1005-1.x86_64

libsasl2.so.2()(64bit) is needed by hive-odbc-native-2.0.5.1005-1.x86_64

[centos@nsnode1 ~]$

View solution in original post

10 REPLIES 10

avatar
Contributor

Do we have an ETA yet on the availability of the CentOS/RHEL7 ODBC driver?