MicroStrategy ONE

Connect to Hive 2.x on Windows

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 using ODBC Administrator (64 bit). You can do this with the MicroStrategy Hive ODBC Driver, or Hortonworks ODBC Driver for Hive.

  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. Click HTTP Options and add cliservice to the HTTP Path.

  6. Click OK.

Once the ODBC DSN is created, you can make a connection through MicroStrategy's DBQuery tool to connect and run queries.