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
-
Click .
-
Click the Drivers tab to verify that the driver is
present.
-
Create either a User or System DSN (data source name) for your BI tool
connection.
-
Click the User DSN or System
DSN tab.
-
Click .
-
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. |
-
Click Test.
The test results are displayed.
-
To configure the advanced options, see Appendix C in the DataStax Hive ODBC
Connector User Guide for Windows: