String functions are used to execute an input string operation and return the output string. There are many built-in string functions available on almost all
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.
Get first and the last row in the window – Apache Impala
The expression values from the first and last rows of the window are returned using the FIRST VALUE and LAST VALUE functions. The same value
Add or Subtract Hours 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
Online Courses – Learn Anything From Anywhere
Now, you can improve your personal and professional skills Online or offline. The bulk of these courses will help you achieve your life objectives. Contact
Truncate Data From A Partition- Apache Hive
TRUNCATE is a term that SQL developers are familiar with because it is a commonly used command. However, it is used at the table level
Add or Subtract Weeks 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
Big Data & SQL 