Configuring ODBC access to Hive data sources

To configure the federated server to access Hive data sources, you must provide the federated server with information about the data sources and objects that you want to access. The ODBC wrapper is optimized to access Hive data sources. The ODBC wrapper detects the ODBC driver and automatically configures the performance options.

Before you begin

The Hive ODBC driver must be configured on your federated server.

For prerequisites that apply to all ODBC data sources, see .

Restrictions

  • nnstat method 1 is not supported for Hive. There is no error when using method 1, but no data will be returned.
  • Transparent DDL is not supported for Hive.
  • IUD is not supported for Hive.
  • Hive does not support all federation functions. For a full list of Hive restrictions, see the Hive documentation
  • Need to set "EnableDescribeParam=1" in Hive dsn in odbc.ini

Additional restrictions apply to all ODBC data sources. See .

Procedure

  1. Register the ODBC wrapper.
  2. Register the server definitions for an ODBC data source.
  3. Create a user mapping for an ODBC data source.
  4. Test the connection to the ODBC data source server.
  5. Register nicknames for ODBC data source tables and views.