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 information about the Impala Daemon along with the Impala shell will be displayed.The VERSION() returns the information such as the precise version number and build date for the impalad daemon…
Connected User in Impala DAEMON
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 USER(). Both functions show the same username when you execute in ClouderaVM, but there is a distinction between them.Let’s see what USER() function displays:User() function returns the username of the…
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 uncertainty and this could lead to the table being dropped from the wrong database. It is indeed advisable to verify the connected database before performing any DDL operation.CURRENT_DATABASE() is the…
Big Data and SQL 