REVERSE(STRING a)The REVERSE function accepts a character expression as its argument, and returns a string of the same length, but the ordinal position of each
Category: Cloudera Impala
SQL Assignment-1
For beginners to intermediate levels, this is a quick test/assignment to check how familiar they are with SQL. Such types of exercises will certainly help
SPACE function in Apache Hive & Apache Impala
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
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 (
Big Data & SQL 