Regular expression functions identify precise patterns of characters in the given string and returns the matching text item from the string/data. Syntax: REGEXP_EXTRACT(STRING data, STRING
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.
Apache Pig Tutorial
This page combines all Apache Pig related posts into a single to make it more helpful and beneficial to learners. It is presented in a
CASE Expressions in Apache Impala
The CASE function assesses a set of criteria and returns one of many result expressions. The CASE expression’s WHEN and THEN clauses are similar to
Apache Hive – Avro Sample Schema & Data
While learning any technology, it is important to have some example datasets for practice, and if sample data is unavailable and practice is not done,
Group_Concat With Group Clause in Impala
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
Get Character Length in Apache Impala
Apart from the LENGTH() function, CHAR_LENGTH function can also be used to get the length of a string. Both leading and trailing spaces at the
Big Data & SQL 