There are two functions to get details about the user who is connected to Impala Daemon. The first is USER() and the second is EFFECTIVE
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.
Connected Database in Apache Hive & Impala
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
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
Hive SerDe – RegEx – Example4
“Build step by step. Push yourself, but not too hard. Learn, keep it fun.” It is definitely harder to read and comprehend 100 characters in
Hive SerDe – RegEx – Example3
Regular expressions are difficult to understand, but not in contrast to the data they contain. You will begin to love it once you understand the
Big Data & SQL 