Hive-3-hive Architecture

Hive schema

1. User interface

A) CLI (command line Interface)

Execute under the bin directory of hive./hive

b) Client Clients

Start command for Nohup hive–service Hiveserver & (Nohup ... & is a Linux command that indicates that the command runs in the background)

Then use hive's JDBC Connection

c) WUI Web browser

The start command is Hive–service HWI and the access port defaults to 9999

2. Meta Data storage

A) Bring your own Derby

b) MySQL (for production environments)

3, interpreter, compiler, optimizer

HIVEQL query statements from syntax analysis, data analysis, compilation, optimization, and query plan generation, generating query plans are stored in HDFs and executed with the MapReduce call

4. Data storage

Hadoop-based HDFs

5. Architecture Diagram

Hive-3-hive Architecture