Integrating Apache Hive with Spark and BI
Hive Warehouse Connector for accessing Apache Spark data
HWC execution modes
Spark Direct Reader mode
JDBC execution mode
Automating mode selection
Configuring Spark Direct Reader mode
Configuring JDBC execution mode
Kerberos configurations for HWC
Configuring external file authorization
Reading managed tables through HWC
Writing managed tables through HWC
API operations
HWC supported types mapping
Catalog operations
Read and write operations
Commit transaction in Spark Direct Reader mode
Close HiveWarehouseSession operations
Use HWC for streaming
HWC API Examples
Hive Warehouse Connector Interfaces
HWC configuration planning
Submit a Scala or Java application
Submit a Python app
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 driver
Integrating Hive and a BI tool
Specify the JDBC connection string
JDBC connection string syntax
Using JdbcStorageHandler to query RDBMS
Set up JDBCStorageHandler for Postgres