In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands. SHOW is a command that displays information about
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.
Rename Column Name – Apache Hive
Though it is uncommon, we do sometimes change the column names when the situation calls for it. Apache Hive allows us to change the column
SQL Server String Functions-6
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
SQL Server String Functions-5
A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an
Multi Group_Concat in a single query with Distinct – MySQL
The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
Date INTERVAL in Apache Hive
In Apache Hive, the interval keyword is used to get a date that is either previous to or after the provided date. For a better
Big Data & SQL 