Welcome
Explore Data Integration. Connect different data sources and various stages used in Data Integration process.
Introduction
Learn about data management architecture and the star schema data warehouse design.
Connecting to Data Sources and Data Warehouses
Connect to different types of data sources.
Populating the Data Warehouse
Prepare your data for warehouse. Populate Time Dimension table, Dimension table, Fact table. Add time stamp to records in a Data Warehouse.
Updating the Data Warehouse
Define a Data Warehouse update schedule. Update a fact table. Use Global and Local cache for queries.
Accessing Stages Through Enterprise Designer
Access different stages through Enterprise Designer.
Configurations
Configure Oracle LogMiner, and HDFS connection for HA Cluster.
Optimizing Performance
Improve performance by determining an optimum fetch size. Learn about best practices for connecting to HDFS 3.x and Hive 2.1.1.

Connecting to Hive

You can connect to Hive databases through the driver provided by Spectrum Technology Platform or by adding the Apache JDBC driver. The driver provided by Spectrum Technology Platform (hive-jdbc-1.2.2-batch-18.2.jar) is an extended version of Apache Hive driver and supports batch processing. It is located here:

SpectrumDirectory\server\modules\bigdata\drivers\hive, where SpectrumDirectory is the folder where you have installed the Spectrum Technology Platform server.

For information about manually adding a JDBC driver, see Manually Adding a JDBC Driver.

Note: The class path for the Hive JDBC driver is: com.pb.spectrum.hive.jdbc.batch.HiveBatchDriver