Metadata-Version: 2.4
Name: impala_shell
Version: 4.6.0a1
Summary: Impala Shell
Home-page: https://impala.apache.org/
Author: Impala Dev
Author-email: dev@impala.apache.org
License: Apache Software License
Classifier: Development Status :: 5 - Production/Stable
Classifier: Environment :: Console
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: End Users/Desktop
Classifier: Intended Audience :: Science/Research
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Operating System :: MacOS :: MacOS X
Classifier: Operating System :: POSIX :: Linux
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Topic :: Database :: Front-Ends
Requires-Python: >2.6
Description-Content-Type: text/markdown
License-File: LICENSE.txt
Requires-Dist: bitarray==2.3.0
Requires-Dist: configparser==4.0.2
Requires-Dist: kerberos==1.3.1
Requires-Dist: prettytable==0.7.2; python_version < "3"
Requires-Dist: prettytable==2.5.0; python_version >= "3"
Requires-Dist: sasl==0.4a1
Requires-Dist: setuptools>=36.8.0
Requires-Dist: six==1.17.0
Requires-Dist: sqlparse==0.3.1
Requires-Dist: thrift==0.22.0
Requires-Dist: thrift_sasl==0.4.3
Requires-Dist: wcwidth==0.2.14; python_version >= "3"
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: license
Dynamic: license-file
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

# 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](http://impala.apache.org/docs/build/html/topics/impala_langref_sql.html),
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

* [Impala Shell Documentation](http://impala.apache.org/docs/build/html/topics/impala_impala_shell.html)
* [Apache Impala Documentation](http://impala.apache.org/impala-docs.html)

## 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.
