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
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Database Level Constraints in Hive
The following is a list of Apache Hive database level boundaries. However, many of these may have workarounds. 1) Specify where the database should be
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
Search Databases and Tables in Apache Hive
In all SQL supported systems, the LIKE operator is used in the WHERE clause of a query statement to search for a specified pattern in
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.
Big Data & SQL 