In this post we will see how Hive Create new table using existing table metadata. There are various ways in which this can be achieved […]
Category: Hive Tutorial
This category contains blogs on Hive Tutorial. Easily understand various topics related to Hive here.
Hive Insert Into vs Insert Overwrite
In Previous chapter we learned about HIVE SHOW PARTITION and today lets check out the difference between Hive Insert Into vs Insert Overwrite. We will also […]
HIVE SHOW PARTITIONS
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 […]
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
In Previous chapter we learned about Hive Insert Into vs Insert Overwrite and today lets check out Hive Drop Table. If we need to remove […]
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, […]