There are some functions that hardly come into use. Often this kind of function would have some other replacement that we use. SPACE is one
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.
TRANSLATE & REPLACE functions in Cloudera’s Impala & Apache Hive
This article introduces the new TRANSLATE and REPLACE string functions available from version 2.9.0 of Cloudera Impala. Both of these functions look identical, shifting letters
String Functions in Impala – STRLEFT, STRRIGHT & SUBSTR
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
Chaining Common Table Expressions in Impala
This article will help you to learn how to implement chaining common table expressions in Cloudera’s Impala. -~ Chaining CTEs WITH Temp1 AS (
Get the unique values from multiple CTEs – Impala
Often, some requests for reports seem simple and straightforward. But it is challenging to find a better solution to be applied. Cloudera’s Impala provides several
Starting Hive & Hive metastore from command line
The following commands will help in starting the services of Hive and Hive metastore in case they didn’t start automatically without logging into Cloudera manager.
Big Data & SQL 