Creating a Hive data source

You can create Hive data sources to work with Apache Hadoop, which is the open source software framework, used to reliably managing large volumes of structured and unstructured data.

Before you begin

Make sure you have defined the Hive driver library JAR files so that QMF can connect to Hive data sources.

About this task

Hive data source is a data warehouse infrastructure that provides data summarization and ad hoc querying. Hive data sources are accessed using special drivers for JDBC. The current JDBC interface for Hive only supports running queries and fetching results.

To create a Hive data source:

Procedure

  1. In the Repositories view, on the Data Sources tab, click Create a Data Source. The Create New Data Source wizard opens.
  2. In the wizard, select Hive and click Next.
  3. Type the data source name in the Data Source Name field.
  4. Specify the necessary parameters in the Connection Parameters area. You must set the Host name, Port number, and Database name.
  5. Click Set User Information button to specify the necessary user parameters.
  6. Click Advanced button to select the advanced parameters supported by the installed Hive driver.
  7. In the Comment field, you can enter the description of the created data source.
  8. Click Finish to create the Hive data source and close the Create Hive Data Source wizard.