There are 2 types of tables in Hive, Internal and External. This case study describes creation of those tables, loading data, partitioning, querying and dropping table on weather data.