{ "info": { "author": "Impala Dev", "author_email": "dev@impala.apache.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Environment :: Console", "Intended Audience :: Developers", "Intended Audience :: End Users/Desktop", "Intended Audience :: Science/Research", "License :: OSI Approved :: Apache Software License", "Operating System :: MacOS :: MacOS X", "Operating System :: POSIX :: Linux", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 2 :: Only", "Topic :: Database :: Front-Ends" ], "description": "# Impala Interactive Shell\n\nYou can use the Impala shell tool (impala-shell) to connect to an Impala\nservice. The shell allows you to set up databases and tables, insert data,\nand issue queries. For ad hoc queries and exploration, you can submit SQL\nstatements in an interactive session. The impala-shell interpreter accepts\nall the same SQL statements listed in\n[Impala SQL Statements](http://impala.apache.org/docs/build/html/topics/impala_langref_sql.html),\nplus some shell-only commands that you can use for tuning performance and\ndiagnosing problems.\n\nTo automate your work, you can specify command-line options to process a single\nstatement or a script file. (Other avenues for Impala automation via python\nare provided by Impyla or ODBC.)\n\n## Installing\n\n```\n$ pip install impala-shell\n```\n\n## Online documentation\n\n* [Impala Shell Documentation](http://impala.apache.org/docs/build/html/topics/impala_impala_shell.html)\n* [Apache Impala Documentation](http://impala.apache.org/impala-docs.html)\n\n## Quickstart\n\n### Non-interactive mode\n\nProcessing a single query, e.g., ```show tables```:\n\n```\n$ impala-shell -i impalad-host.domain.com -d some_database -q 'show tables'\n```\n\nProcessing a text file with a series of queries:\n\n```\n$ impala-shell -i impalad-host.domain.com -d some_database -f /path/to/queries.sql\n```\n\n### Launching the interactive shell\n\nTo connect to an impalad host at the default service port (21000):\n\n```\n$ impala-shell -i impalad-host.domain.com\nStarting Impala Shell without Kerberos authentication\nConnected to impalad-host.domain.com:21000\nServer version: impalad version 2.11.0-SNAPSHOT RELEASE (build d4596f9ca3ea32a8008cdc809a7ac9a3dea47962)\n***********************************************************************************\nWelcome to the Impala shell.\n(Impala Shell v3.0.0-SNAPSHOT (73e90d2) built on Thu Mar 8 00:59:00 PST 2018)\n\nThe '-B' command line flag turns off pretty-printing for query results. Use this\nflag to remove formatting from results you want to save for later, or to benchmark\nImpala.\n***********************************************************************************\n[impalad-host.domain.com:21000] >\n```\n\n### Launching the interactive shell (secure mode)\n\nTo connect to a secure host using kerberos and SSL:\n\n```\n$ impala-shell -k --ssl -i impalad-secure-host.domain.com\n```\n\n### Disconnecting\n\nTo exit the shell when running interactively, press ```Ctrl-D``` at the shell prompt.", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://impala.apache.org/", "keywords": "", "license": "Apache Software License", "maintainer": "", "maintainer_email": "", "name": "impala-shell", "package_url": "https://pypi.org/project/impala-shell/", "platform": "", "project_url": "https://pypi.org/project/impala-shell/", "project_urls": { "Homepage": "https://impala.apache.org/" }, "release_url": "https://pypi.org/project/impala-shell/3.4.0a1/", "requires_dist": null, "requires_python": ">2.6, <3.0.0", "summary": "Impala Shell", "version": "3.4.0a1" }, "last_serial": 5991819, "releases": { "3.3.0a1": [ { "comment_text": "", "digests": { "md5": "64ee0fb4a3106f3f69ca979460370ac0", "sha256": "0f0798d8b22afa6d39ca009e3e6ad711afa6a38d92127da79af4491ff9c27472" }, "downloads": -1, "filename": "impala_shell-3.3.0a1.tar.gz", "has_sig": false, "md5_digest": "64ee0fb4a3106f3f69ca979460370ac0", "packagetype": "sdist", "python_version": "source", "requires_python": ">2.6, <3.0.0", "size": 372957, "upload_time": "2019-09-21T02:18:30", "url": "https://files.pythonhosted.org/packages/e5/48/d4255383f5b05f9df9d462294e427a457a47afb7a834223faba651caedd5/impala_shell-3.3.0a1.tar.gz" } ], "3.4.0a1": [ { "comment_text": "", "digests": { "md5": "01646f0520f3838da97233e42cd03746", "sha256": "543b5a0cf57066a5df8085fab3670d6f84473a3b73e3564e9e838fc9f9d4bd5e" }, "downloads": -1, "filename": "impala_shell-3.4.0a1.tar.gz", "has_sig": false, "md5_digest": "01646f0520f3838da97233e42cd03746", "packagetype": "sdist", "python_version": "source", "requires_python": ">2.6, <3.0.0", "size": 376078, "upload_time": "2019-10-17T18:54:10", "url": "https://files.pythonhosted.org/packages/c5/27/b3278a545179654e8fd4ab840c63b074bab0d3a8abec994d7d4777c72362/impala_shell-3.4.0a1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "01646f0520f3838da97233e42cd03746", "sha256": "543b5a0cf57066a5df8085fab3670d6f84473a3b73e3564e9e838fc9f9d4bd5e" }, "downloads": -1, "filename": "impala_shell-3.4.0a1.tar.gz", "has_sig": false, "md5_digest": "01646f0520f3838da97233e42cd03746", "packagetype": "sdist", "python_version": "source", "requires_python": ">2.6, <3.0.0", "size": 376078, "upload_time": "2019-10-17T18:54:10", "url": "https://files.pythonhosted.org/packages/c5/27/b3278a545179654e8fd4ab840c63b074bab0d3a8abec994d7d4777c72362/impala_shell-3.4.0a1.tar.gz" } ] }