Configuring the Hive ODBC driver (deprecated) 

Set up the DataStax Hive ODBC driver for access by your BI tool.

Hadoop is deprecated for use with DataStax Enterprise. DSE Hadoop and BYOH (Bring Your Own Hadoop) are deprecated. Hive is also deprecated and will be removed when Hadoop is removed.

Set up the DataStax ODBC driver for access by your BI tool.

Procedure

  1. Click Start Program Files > DataStax Hive ODBC Connector > ODBC Driver Manager.
  2. Click the Drivers tab to verify that the driver is present.


  3. Create either a User or System DSN (data source name) for your BI tool connection.
    1. Click the User DSN or System DSN tab.
    2. Click Add > DataStax Hive ODBC Connector > Finish.
    3. In DataStax Hive ODBC Connector Setup, enter the following:
      Data Source Name The name for your DSN.
      Description Optional.
      Host IP or hostname of your Hive server.
      Port Listening port for the Hive service.
      Database By default, all tables reside within the default database. To check for the appropriate database, use the show databases Hive command.
    4. Click Test.

      The test results are displayed.

  4. To configure the advanced options, see Appendix C in the DataStax Hive ODBC Connector User Guide for Windows:

    Start > Program Files > DataStax Hive ODBC Connector > User's Guide