MicroStrategy ONE

Connect to Hive 2.x on Linux

These instructions outline how to connect to the "Interactive Hive" interface (LLAP).

  1. Once an HDP 2.5 or HDP 2.6 Hadoop cluster has been set up, enable Interactive Query mode (LLAP).
  2. Set up a DSN by editing the odbc.ini file under the MicroStrategy installation folder. Use the MicroStrategy Hive ODBC Driver that comes out-of-the-box to create this DSN.

  3. Fill in the required parameters. The Service Discovery mode can be set to either No Service Discovery or Zookeeper.

    If you have additional Zookeeper parameters, then enable Zookeeper at the discovery mode. If not, then the default setting No Service Discovery should work.

  4. Select HTTP as the mode of transport under Thrift Transport.

  5. Add the parameter value cliservice to the HTTP Path. For example, this could be an ODBC.ini entry for a MicroStrategy Hive ODBC Driver:

    Driver= /opt/MicroStrategy/MicroStrategy-Linux/install/lib/libhiveodbc_sb64.so

    Description=MicroStrategy Hive ODBC Driver

    AuthMech=3

    DefaultStringColumnLength=2147483647

    FastSQLPrepare=0

    GetTablesWithQuery=1

    HiveServerType=2

    HTTPPath=cliservice

    Host=<hostname>

    Port=10501

    Schema=default

    ServiceDiscoveryMode=0

    ZKNamespace=

    ThriftTransport=2

    UseNativeQuery=1

    KrbHostFQDN=[Hive Server 2 Host FQDN]

    KrbServiceName=[Hive Server 2 Kerberos service name]

    KrbRealm=[Hive Server 2 Kerberos realm]

    SSL=0

    TwoWaySSL=0

    ClientCert=

    ClientPrivateKey=

    ClientPrivateKeyPassword=