Tag: Big Data
Hive : Hive Table Properties : How are Hive Table Properties used?
One of the key features of Hive is the ability to define table properties, which can be used to control…
Hive : Implementation of UDF in Hive using Python. A Comprehensive Guide
A User-Defined Function (UDF) in Hive is a function that is defined by the user and can be used in…
Hive : Hive metastore and its importance.
The Hive Metastore is an important component of the Apache Hive data warehouse software. It acts as a central repository…
Hive : Hive Optimizers: A Comprehensive Guide
Hive is a data warehousing tool that provides a SQL-like interface for querying large datasets stored in Hadoop Distributed File…
Hive : Comparison between the ORC and Parquet file formats in Hive
ORC (Optimized Row Columnar) and Parquet are two popular file formats for storing and processing large datasets in Hadoop-based systems…
Hive : Different types of storage formats supported by Hive.[16 Formats supported by Hive]
Apache Hive is an open-source data warehousing tool that was developed to provide an SQL-like interface to query and analyze…
PySpark : Setting PySpark parameters – A complete Walkthru [3 Ways]
In PySpark, you can set various parameters to configure your Spark application. These parameters can be set in different ways…
PySpark : Using CASE WHEN for Spark SQL to conditionally execute expressions : Dataframe and SQL way explained
The WHEN clause is used in Spark SQL to conditionally execute expressions. It’s similar to a CASE statement in SQL…
Spark : Calculation of executor memory in Spark – A complete info.
The executor memory is the amount of memory allocated to each executor in a Spark cluster. It determines the amount…
Hive : How to load JSON and nested JSON in Hive and how to view it [Sample code with Data]
In this article, I’ll walk you through how to read JSON data from a Hive table using an example with…