In a key-value pair, there are two related data elements: the key is the name of a constant that determines the data set, and the
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.
Adding and Substracting Days to a Date – Apache Hive & Impala
We addressed in the previous post that “Date” is the most significant column that helps to explain patterns, trends and even business. From diagnostic analysis
Formatting number in Apache Hive
Because of the many built-in functions provided by Apache Hive, the job made it easy for analysts, developers and programmers in most instances. Instead of
Find the position of a substring in a string – Apache Hive
INSTR function in Apache Hive helps in finding the position of a substring in a string. It returns only the first first occurrence of the
Reserved Keywords as Columns in Apache Hive
Since the use of reserved keywords for user-defined objects such as tables, columns, etc. is not good practice, However, if there is a situation where
Process and analyze JSON documents – Apache Hive
A JSON file is a file in the JavaScript Object Notation (JSON) format that stores simple data structures and objects, which is a standard format
Big Data & SQL 