Integrating Apache Hive with Spark, Kafka, and BI
Hive Warehouse Connector for accessing Apache Spark data
Configuring HWC in CDP Data Center
Submit an HWC Scala or Java application
Submit an HWC Python app
HWC supported types
HiveWarehouseSession API operations
Catalog operations
Read and write operations
Close HiveWarehouseSession operations
Use the Hive Warehouse Connector for streaming
Hive Warehouse Connector API Examples
Hive Warehouse Connector Interfaces
Apache Hive-Kafka integration
Create a table for a Kafka stream
Querying Kafka data
Query live data from Kafka
Perform ETL by ingesting data from Kafka into Hive
Writing data to Kafka
Write transformed Hive data to Kafka
Set consumer and producer properties as table properties
Kafka storage handler and table properties
Connecting Hive to BI tools using a JDBC/ODBC driver
Getting the JDBC or ODBC driver
Integrating Hive and a BI tool
Specify the JDBC connection string
JDBC connection string syntax
Using JdbcStorageHandler to query RDBMS