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.
Hive
Home / Hive
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
© 2018. All Rights Reserved Designed & Developed by Chennai Creative Solutions