It’s sometimes important to display the month name for the specified date when creating summary reports, pivot tables, and charts. We commonly save data in
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.
Data Platform Job Roles: A Career Guide
These are a series of posts that can assist beginners who are eager to dive into the “data platform” or professionals who are considering a
COALESCE function in Apache Impala
The NULL values are substituted with the user-defined value during the expression evaluation process using the NVL(), COALESCE(), and ISNULL() functions. The COALESCE function evaluates
Time Seconds Functions in Apache Impala
When it comes to analyzing a date-time value, every detail matters including seconds and milliseconds. We’ll go through all of the time seconds functions of
Add or Subtract Months to a Date – Apache Impala
There are plenty of built-in functions available in Apache Impala that helps in analyzing the data and business logic implementations. It relieves a developer’s worries
Get Months Between Two Dates – Hive & Impala
A date can be analyzed in a variety of ways. Once you get the date data for a particular transaction, you’ll undoubtedly want to see
Big Data & SQL 