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 that you are currently connected to. Typically used to confirm that you are connected to the expected level of Impala to use a particular feature, or to connect to several nodes and confirm they are all running the same level of impalad.
Return type: STRING (with one or more embedded newlines)
It's all about SQL Server, MySQL, Oracle SQL*Plus, PostgreSQL, NoSQL, Hbase, Apache Pig, Apache Hive, Sqoop, HDFS, MapReduce and MongoDB
Big Data and SQL 
2 comments