The DEFAULT keyword can be used to assign a default value to a column. If the user’s INSERT statement does not have a specific value,
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.
Identify datatype of a column – Apache Impala
Some built-in functions cannot run on some columns because they are built on numerical or character columns. We will not be able to determine the
“Is Distinct From” Operator Apache Impala
Impala is a SQL database engine that uses MPP (Massive Parallel Processing) to process large amounts of data contained in a Hadoop cluster. It’s a
Complex Data Types – ARRAY within MAP
Please click here for “ARRAY in MAP” The data is available in a number of formats, volumes, and types. It may be well-organized, partially-organized, or
XPath UDF’s in Apache Hive
There are other built-in functions that assist in getting essential data from an XML document, in addition to XPath and XPath String. Despite the fact
Complex Data Types – ARRAY within STRUCT
This is one of the articles that required a significant amount of time and effort to complete. Once an idea was formed, I went to
Big Data & SQL 