Hive

Inserting Data In Hive Partitioned tables

inserting data to hive partition

In this blog, we will learn how to insert data in partitions in hive table. We will write queries to insert data in static as well as dynamic partitions.

inserting data to hive partition

Bucketing in Hive

bucketing in hive

With Bucketing in Hive, we can group similar kinds of data and write it to one single file. This allows better performance while reading data & when joining two tables.

bucketing in hive

Alter Table Partitions in Hive

altering hive table partition

We have created partitioned tables, inserted data into them. Now, we will learn how to drop some partition or add a new partition to the table in hive.

altering hive table partition

Static vs Dynamic Partitioning in Hive

static vs dynamic

Hive supports Static and Dynamic Partitions. Let us understand what is difference between them and their use cases.

static vs dynamic

Partitioning in Hive

Partitioning in Hive

Using Partitioning, We can increase hive query performance. But if we do not choose partitioning column correctly it can create small file issue.

Partitioning in Hive

Create, Alter, Delete Tables in Hive

manage tables in hive -2

We will learn how to create Hive tables, also altering table columns, adding comments and table properties and deleting Hive tables.

manage tables in hive -2

Creating Database in Hive

Create Database in Hive

We will learn how to create databases in Hive with simple operations like listing database, setting database location in HDFS & deleting database.

Create Database in Hive

Data Types in Hive

Hive data types

Hive supports multiple data types like SQL. On top of that, there are multiple complex data types in hive which makes it easy to process data in Hive.

Hive data types

External Vs Internal(Managed) Tables in Hive

external vs Managed tables in Hive

Hive has two types of tables, external and managed. In this blog, we will learn about them and decide which use case is suitable for each table.

external vs Managed tables in Hive

Pivot rows to columns in Hive

pivot table - Transpose rows to columns in Hive

There are multiple use cases when we need to transpose/pivot table and Hive does not provide us with easy function to do so. Let me show you workaround for how to pivot table in hive.

pivot table - Transpose rows to columns in Hive
Scroll to Top