Hive is an open-source data warehouse tool built on top of Hadoop. It allows users…
Category: hive
Bigdata – Hive
Hive : Hive optimizer – Detailed walk through
Hive is a popular open-source data warehouse system that allows users to store, manage, and analyze large datasets using SQL-like…
Hive : Difference between the Tez execution engine and the Spark execution engine in Hive
Hive is a data warehousing tool built on top of Hadoop, which allows us to write SQL-like queries on large…
Hive : Different types of Hive execution engines
Hive is an open-source data warehouse tool built on top of Hadoop. It allows users to write SQL-like queries, called…
Hive : Difference between the MapReduce execution engine and the Tez execution engine in Hive
MapReduce and Tez are two popular execution engines used in Apache Hive for processing large-scale datasets. While both engines are…
Learn how to connect Hive with Apache Spark.
HiveContext is a Spark SQL module that allows you to work with Hive data in Spark. It provides a way…
What are the Optimization Techniques that you can apply on Apache Hive ?
1. Partitioning : Partitioning works by dividing the data into smaller segments, These are created using logical grouping based on…
Explain how can you implement dynamic partitioning in Hive (automatically creating partition based on column value)
Dynamic partition in hive Dynamic partitioning is a tactical method for loading data from a…
How to insert from Non Partitioned table to Partitioned table in Hive?
You can insert data from Non Partitioned table to Partitioned table , in short , if you want to have…
How to drop multiple partition in Hive by giving condition.
Hive Partitions is a good and easy way to organizes Hive tables into partitions by dividing tables into different parts…
How to delete a partition data as well from Hive external table on DROP command?
As you know external tables are tables where Hive does not manage the data of the External table. So when…