Apache Impala is an open source massively parallel processing (MPP) SQL query engine for data stored in a computer cluster running Apache Hadoop. It’s easy for all SQL developers to work in impala. If you are acquainted with MySQL or SQL Server or Oracle SQL*Plus or some kind of RDBMS, operating in Impala is not a big deal. In this post, we’ll see how to link to the impalad daemon.
Whoever uses Cloudera QuickStart would be able to connect to Impala by entering the following command in the HDFS terminal.
impala-shell;
If you want to connect to localhost where impala daemon is running then use –
impala-shell -i localhost
If you want to connect to specific node where daemon is running-
impala-shell -i quickstart.cloudera
If you want to connect to specific node and port where daemon is running-
impala-shell -i quickstart.cloudera:21000
Hope you find this article helpful.
Big Data and SQL 
One comment