Impala Miscellaneous Functions

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…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s