Hive-Based Analytics Pipeline for Titanic Survival Data
Connect to the Hive metastore using Beeline:
./beeline -u jdbc:hive2://node2:10000 -n root -p
Initialize the analytics environment:
CREATE DATABASE IF NOT EXISTS maritime_analytics;
USE maritime_analytics;
Establish an external staging table pointing to HDFS storage:
CREATE EXTERNAL TABLE external_titanic_stage (
pid INT,
survived_fla ...
Posted on Thu, 17 Sep 2026 15:59:40 +0000 by alapimba
Hive Data Warehouse Integration
Overview of Hive
1.1 Hive functions as a data warehouse within the Hadoop ecosystem. It manages and queries data stored in Hadoop. Essentially, Hive serves as an SQL parsing engine that converts SQL queries into MapReduce jobs.
Hive includes a mapping tool that translates SQL tables and columns into files and directories on HDFS. This mapping ...
Posted on Sun, 10 May 2026 17:23:35 +0000 by adnan1983