If you want to display all the Partitions of a HIVE table you can do that using SHOW PARTITIONS command. If you want to learn […]
Category: Hive Tutorial
This category contains blogs on Hive Tutorial. Easily understand various topics related to Hive here.
Hive Split a row into multiple rows
You can split a row in Hive table into multiple rows using lateral view explode function. The one thing that needs to be present is […]
Hive Table Partition
Using Hive Partition you can divide a table horizontally into multiple sections. This division happens based on a partition key which is just a column […]
HIVE ALTER TABLE
In Previous chapter we learned about HIVE TABLE CREATION and today lets check out HIVE ALTER TABLE. Here we will list down all the alterations that can be […]
HIVE DATA TYPES
Many of the datatypes you find in Relational Databases can be found in Hive as well. They are called “Primitive Datatypes“. Along with these , […]
Hive Drop Table
When you drop a Hive table all the metadata information related to the table is dropped. If the tables is an internal/managed table then the […]
Hive/Spark – Find External Tables in hive from a List of tables
Let say that there is a scenario in which you need to find the list of External Tables from all the Tables in a Hive […]
Hive – Order By vs Sort By vs Distribute By vs Cluster By
Lets understand the difference with the help of examples. Lets create a table Department having Name and DeptId. ORDER BY :Defn: It guarantees global ordering, […]
Hive Table Creation
In Previous chapter we learned about HIVE DATA TYPES and today lets check out HIVE TABLE CREATION. In HIVE there are two kinds of tables , […]