Skip to main content
Pre-release

This release is a pre-release and may not be stable for production use.

Impala Interactive Shell

You can use the Impala shell tool (impala-shell) to connect to an Impala service. The shell allows you 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. 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.

To automate your work, you can specify command-line options to process a single statement or a script file. (Other avenues for Impala automation via python are provided by Impyla or ODBC.)

Installing

$ pip install impala-shell

Online documentation

Quickstart

Non-interactive mode

Processing a single query, e.g., show tables:

$ impala-shell -i impalad-host.domain.com -d some_database -q 'show tables'

Processing a text file with a series of queries:

$ impala-shell -i impalad-host.domain.com -d some_database -f /path/to/queries.sql

Launching the interactive shell

To connect to an impalad host at the default service port (21000):

$ impala-shell -i impalad-host.domain.com
Starting Impala Shell without Kerberos authentication
Connected to impalad-host.domain.com:21000
Server version: impalad version 2.11.0-SNAPSHOT RELEASE (build d4596f9ca3ea32a8008cdc809a7ac9a3dea47962)
***********************************************************************************
Welcome to the Impala shell.
(Impala Shell v3.0.0-SNAPSHOT (73e90d2) built on Thu Mar  8 00:59:00 PST 2018)

The '-B' command line flag turns off pretty-printing for query results. Use this
flag to remove formatting from results you want to save for later, or to benchmark
Impala.
***********************************************************************************
[impalad-host.domain.com:21000] >

Launching the interactive shell (secure mode)

To connect to a secure host using kerberos and SSL:

$ impala-shell -k --ssl -i impalad-secure-host.domain.com

Disconnecting

To exit the shell when running interactively, press Ctrl-D at the shell prompt.

Metadata

Release files for impala-shell 4.4.0a2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for impala-shell 4.4.0a2
File Size Uploaded Provenance Actions
impala_shell-4.4.0a2.tar.gz 505.7 kB Without provenance Details for impala_shell-4.4.0a2.tar.gz

Release files / impala_shell-4.4.0a2.tar.gz

Download URL impala_shell-4.4.0a2.tar.gz
Size 505.7 kB
Tags Source
SHA-256 checksum
How to use checksums
18fa0e7d71b657e262bdb377c563b9af5c7408a80f2cf486456263f831b00665
BLAKE2b-256 checksum
How to use checksums
31ab6709d8c85d11a91fd307ab816fd798c618ae0f32d1f75a58d40300a2d341
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.15.0 pkginfo/1.8.3 requests/2.27.1 setuptools/44.0.0 requests-toolbelt/1.0.0 tqdm/4.64.1 CPython/2.7.18

Security for impala-shell 4.4.0a2

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page