Throughout the year, “Big Data & SQL” published a number of articles about Apache Impala. It covers the majority of its features and functions. It’s
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.
ROLES and USERS Metadata In Apache Impala
In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands that help in retrieving metadata of the roles
SHOW CREATE Statement in Apache Impala
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
Apache Impala – Sub Queries
A subquery is a query that is included within another query statement. Subqueries, often known as sub-SELECTs or nested SELECTs, are a type of query.
DATE_FORMAT Function – MySQL
The DATE_FORMAT function assists in formatting the specified/provided date. Depending on the report criteria and geolocation, we may be required to return the date in
Find number of days in the month – MySQL
The following query will provide the month’s number of days for the specified date. This will come in handy if we need to figure out
Big Data & SQL 