It’s sometimes important to display the day 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.
Truncate External Table Partition Data- Apache Hive
For information on how to truncate whole data or partitioned data in internal tables, check the previous blog. According to Hive documentation, the target table
Multiple Built-in Functions to add days to a date in Impala
DATE ADD, ADDDATE, and DAYS ADD are three built-in functions in Apache Impala that do the same thing. However, the primary objective of these functions
DECODE Function in Apache Impala
To compare each search value to the expression one by one, we can use the DECODE function that adds procedural if-then-else logic to the query.
TRUE or FALSE Conditions in Apache Impala
In this article, we’ll look at how to use the built-in functions ISFALSE, ISTRUE, ISNOTFALSE, and ISNOTTRUE to generate true or false conditional statements in
Adding Days To A Date – Apache Impala
The ADDDATE function in Apache Impala is equivalent to the DATEADD function in most RDBMSs. This function is widely used for data analysis and business
Big Data & SQL 