Skip to main content

Impala Shell

Project description

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

impala_shell-4.1.0a2.tar.gz (484.7 kB view details)

Uploaded Source

File details

Details for the file impala_shell-4.1.0a2.tar.gz.

File metadata

  • Download URL: impala_shell-4.1.0a2.tar.gz
  • Upload date:
  • Size: 484.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 pkginfo/1.7.1 requests/2.26.0 setuptools/44.1.1 requests-toolbelt/0.9.1 tqdm/4.62.1 CPython/2.7.17

File hashes

Hashes for impala_shell-4.1.0a2.tar.gz
Algorithm Hash digest
SHA256 6e39ee0556769097851d6c791547b1f76f3e708aba7b5c8082cea584f8ac13c1
MD5 f6af5764f29aba85ce93c27ef9ebe9fc
BLAKE2b-256 c9aceafd6c6e7283922a1446781ed9455ee16a7f18f9bf063e90de8e97ab5631

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page