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.

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

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.

One comment

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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