WHAT IS BIG DATA?
TYPES OF DATA
LIMITATION OF RDBMS
FEATURES OF HADOOP
HDFS
MAP-REDUCE
BLOCK- REPLICATION
HADOOP ARCHITECTURE
LINUX COMMANDS
HIVE INTRODUCTION
SQL BASICS FOR HIVE
HIVE COMMANDS USING HIVE COMMAND LINE
LOADING FILES IN TO HIVE
INTERNAL AND EXTERNAL TABLES IN HIVE
DIFFERENCE FILE FORMATS (AVRO, ORC, SEQUENTIAL FILES)
CREATING AVRO FILE TABLES
RC FILE
CREATING ORC FILE TABLES
SEQUENTIAL FILE TABLES
PARQUIT FILEFORMAT
INTRODUCTION TO SQOOP
SQOOP IMPORT
SQOOP IMPORT (TARGET-DIR)
SQOOP IMPORT SUBSET OF TABLE
SQOOP IMPORT INCREMENTAL IMPORT
SQOOP IMPORT ALL
SQOOP JOB
SQOOP EVAL
SQOOP EXPORT
HIVE PARTITIONING
ADDING STATIC PARTITION
VERIFYING PARTITION DIRECTORIES
HIVE BUCKETING
HIVE INDEXING
MEANING OF JOINS.
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
MAP SIDE JOIN – STRUCTURE
MAP SIDE JOIN – SYNTAX