Apache Impala – Executing SQL file in non-Interactive Mode

The purpose of this article is to explore non-interactive mode of execution of the local file to retrieve records from Impala through the command line interface.

As discussed in the previous post, non-Interactive mode, it fetches information from Impala and returns the information to the command interpreter. However, we will discuss different approaches to do that.

Method-1:
The below execution executes the local file and remains in non-interactive mode. This will usually be implemented for batch processing.

impala-shell -f sample.sql



Method-2:
In the previous post, we discussed the approach specified below. The only difference is that we are about to call up a SQL file this time.

impala-shell -i quickstart.cloudera:21000 -f sample.sql



Hope you find this article helpful.

To receive updates for new posts, please click on the follow button.