Since Impala-shell does not show the database in which we are working or the database to which we are connected, there is a risk of
Category: Apache Impala
Version and Release Build of Impala Daemon
If you want to know in which version of Cloudera / Apache Impala you are working in, type VERSION() in the command line. The complete
REVERSE Function in Apache Hive & Apache Impala
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
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
Big Data & SQL 