Hive

Home / Hive

Hive

Apache Best Hive training institute in chennai helps to analysis of large datasets stored in Hadoop’s  compatible file systems. In Hive the tables are similar to the tables in a relational database. Here the data can be used via easy query language and hive supports to overwrite or attached data. Whereas Boolean, Decimal, Tinyint, Smallint, Bigint, Char, Binary, Double, Int, Sting, Float amd Timestamp are common primitive data formats which is supported by Hive.

1.INTRODUCTION-HIVE VS RDBMS

2.DETAILED INSTALLATION (CONFIGURATION, METASTORE, INTEGRATING WITH HUE) STARTING METASTORE AND HIVESERVER2

3.DATA TYPES (PRIMITIVE, COLLECTION)

4.CREATE TABLES (MANAGED VS EXTERNAL) AND DML OPERATIONS (LOAD, INSERT, EXPORT)

5.MANAGED VS EXTERNAL TABLES

6.QL QUERIES (SELECT, WHERE, GROUP BY, HAVING, SORT BY, ORDER BY)

7.HIVE ACCESS THROUGH HIVE CLIENT

8.BEELINE AND HUE, FILE FORMATS (RC, ORC, PARQUENT, SEQUENCE)

9.PARTITIONING

10.PARTITION WITH EXTERNAL TABLE
11.DROPPING PARTITIONS AND CORRESPONDING CONFIGURATION PARAMETERS

11.BUCKETING, PARTITIONING VS BUCKETING

12.VIEWS, DIFFERENT TYPES OF JOINS (INNER, OUTER)

13.MAP SIDE JOIN, BUCKETING JOIN

14.SERDE (CSVSERDE, JSONSERDE)

15.PARALLEL EXECUTION

16.SAMPLING DATA

17.SPECULATIVE EXECUTION