In this blog, we’ll look at how to manage a complex datatype ARRAY within another complex datatype MAP. The dataset under discussion in this blog
Category: Apache Impala
Sub-Queries in Apache Hive
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
Input File Format Constraints in Hive
The goal of this article is to discuss the boundaries of utilizing the various file formats and compression codecs available in Apache Hive for different
Complex Data Types – STRUCT within MAP
As we’ve seen in previous blogs, Hive complex data types such as arrays, maps, and structs are a composite of primitive or complex data types.
Terminate Query Execution in Apache Hive & Impala
In some instances, we may need to abort the query execution. The reason might be because an erroneous query was executed, a change of mind,
Using Avro Schema URL in Apache Hive
Please visit my previous article for an introduction and detailed information regarding Apache Avro and its use in Apache Hive. This is a follow-up to
Big Data & SQL 