Hi, we have troubles to connect MicroStrategy(=MSTR) to HIVE on HDP3.1 over Knox, when trying to connect we receive: Unknow failed: Unable to connect. Error type: System call error. Error communicating with connection process. Find target process dead while waiting for reply. We installed ClouderaHiveODBC-2.6.4.1004-1.x86_64.rpm driver. MSTR Inteligent Server is a RHEL-7.4 machine, installation has been realized according to Cloudera-ODBC-Driver-for-Apache-Hive-Install-Guide.pdf: yum --nogpgcheck localinstall [RPMFileName] As we are not sure that yum resolves all dependencies, we install the sasl libraries as well: cyrus-sasl x86_64 2.1.26-23.el7 rhel-7-server-rpms odbc.ini looks like: [hdp.hive.lxprod]
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
Host=hdp.lxprod
PORT=443
Schema=default
ServiceDiscoveryMode=0
HiveServerType=2
AuthMech=3
ThriftTransport=2
HTTPPath=/gateway/DM/hive
SSL=1
AllowSelfSignedServerCert=1
CAIssuedCertNamesMismatch=1
TrustedCerts=/etc/pki/tls-ca-bundle.pem We tested the ODBC-Connection to hdp.lxprod on a Windows machine, with the same driver (ClouderaHiveODBC64.msi, Cloudery ODBC Driver for Apache Hive 2.06.04.1004, Win 64-bit) and it works, so we assume that on HDP-side is everthing ok, and Knox and HIVE is configured well. We suppose that the problem is located on the MSTR server. Any ideas? Thanks in advance Michael.
... View more
