Using the Impala Shell (impala-shell Command)

You can use the Impala shell tool (impala-shell) to set up databases and tables, insert data, and issue queries. For ad hoc queries and exploration, you can submit SQL statements in an interactive session. To automate your work, you can specify command-line options to process a single statement or a script file. The impala-shell interpreter accepts all the same SQL statements listed in Impala SQL Statements, plus some shell-only commands that you can use for tuning performance and diagnosing problems.

The impala-shell command fits into the familiar Unix toolchain:

For information on installing the Impala shell, see Installing Impala.

For information about establishing a connection to a DataNode running the impalad daemon through the impala-shell command, see Connecting to impalad through impala-shell.

For a list of the impala-shell command-line options, see impala-shell Configuration Options. For reference information about the impala-shell interactive commands, see impala-shell Command Reference.