Hive

Hive and scenarios:

      Analytical processing involves huge datasets summarizing and extracting insights.

·          Hive concepts

·          Schema on Read VS Schema on Write

·          Hive architecture

·          Install and configure hive on cluster

·          Meta Store – Purpose & Type of Configurations

·          Different type of tables in Hive

·          Buckets

·          Partitions

·          Joins in hive

·          Hive Query Language

·          Hive Data Types

·          Data Loading into Hive Tables

·          Hive Query Execution

·          Hive library functions

·          Hive UDF

·          Hive Limitations




Hive - Important  Tasks/responsibilities  Partitioning Tables for Faster Queries :

Optimize queries with Hive partitions
Work with partitioned tables
- Creating partitions
- Loading data into partitions
- Querying data from partitions
Implement static and dynamic

partitioning on Hive tables

1.  How to read JDBC tables?
2.  Read and write to Hive.
3.  Hive string handling, date functions and joins
4.  Working with parquet

5.  Launguage Integrated Queries

usually metadata will be   derby database