impyla | Python DB API 20 client for Impala and Hive (HiveServer2 protocol)

 by   cloudera Python Version: 0.19.0 License: Apache-2.0

kandi X-RAY | impyla Summary

kandi X-RAY | impyla Summary

impyla is a Python library typically used in Big Data applications. impyla has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has high support. You can install using 'pip install impyla' or download it from GitHub, PyPI.

Python client for HiveServer2 implementations (e.g., Impala, Hive) for distributed query engines. For higher-level Impala functionality, including a Pandas-like interface over distributed data sets, see the Ibis project.

            kandi-support Support

              impyla has a highly active ecosystem.
              It has 702 star(s) with 230 fork(s). There are 54 watchers for this library.
              There were 1 major release(s) in the last 6 months.
              There are 158 open issues and 158 have been closed. On average issues are closed in 284 days. There are 6 open pull requests and 0 closed requests.
              It has a negative sentiment in the developer community.
              The latest version of impyla is 0.19.0

            kandi-Quality Quality

              impyla has 0 bugs and 0 code smells.

            kandi-Security Security

              impyla has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              impyla code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              impyla is licensed under the Apache-2.0 License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              impyla releases are not available. You will need to build from source code and install.
              Deployable package is available in PyPI.
              Build file is available. You can build the component from source.
              Installation instructions, examples and code snippets are available.
              impyla saves you 56525 person hours of effort in developing the same functionality from scratch.
              It has 63010 lines of code, 6187 functions and 74 files.
              It has high code complexity. Code complexity directly impacts maintainability of the code.

            Top functions reviewed by kandi - BETA

            kandi has reviewed impyla and discovered the below as its top functions. This is intended to give you an instant insight into impyla implemented functionality, and help decide if they suit your requirements.
            • Return a dict of the cmdclass to use .
            • Connect to Impala .
            • Build a summary table .
            • Get http transport .
            • Return a list of git pieces from the git repository .
            • Initialize the connection .
            • Create the versioneer config file .
            • Merge a PR number .
            • Return a connection to the Impala server .
            • Execute a Thrift request .
            Get all kandi verified functions for this library.

            impyla Key Features

            No Key Features are available at this moment for impyla.

            impyla Examples and Code Snippets

            No Code Snippets are available at this moment for impyla.

            Community Discussions


            Error while running query on Impala with Superset
            Asked 2020-May-14 at 16:56

            I'm trying to connect impala to superset, and when I test the connection prints: "Seems OK!", and when I try to see databases on impala with the SQL Editor in the left side it shows all databases without problems.

            Preview of Databases/Tables

            But when i write a query and click on "Run Query", it gives the error: "Could not start SASL: b'Error in sasl_client_start (-1) SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Ticket expired)'"

            Error running query

            I'm running superset with SSL and in production mode (with Gunicorn) and Impala with SSL in a Kerberized Hadoop Cluster, and my impala database config is:

            Impala Config

            And in the extras I put:



            Answered 2020-May-14 at 16:56

            I was able to fix this error doing this steps:

            1 - Created service user for celery-worker, created a kerberos ticket for him and created a crontab to renew the ticket.

            2 - Runned celery worker from this service user, instead running from root.

            3 - Killed an celery-worker that was running in another machine of my cluster

            4 - Restarted Impala and Superset

            I think this error ocurred because in some queries instead of use the celery worker in my superset machine, it was using the celery worker that was in another machine without a valid kerberos ticket. I could fix this error because when I was reading celery-worker log , it showed that a connection with the celery worker in other machine failed in a query running.



            Ibis create impala table with pandas dataframe and get [Error 61] Connection refused
            Asked 2020-May-04 at 00:49

            After doing impyla sql statement, I convert the results into pandas dataframe format. But now I want to auto create a temporary table on impala using Apache Ibis to create table and load a dataframe into it. The following codes are divided into 3 phase:

            1. phase 1 creates a null table with user-defined schema
            2. phase 2 creates a table which schema and data are came from another table
            3. phase 3 is the main part I want to do (suppose the dataframe is given)

            and error code shows below. Does anyone know what happened it is? Cuz the configurations are the same, I don't know why it will get connection exception when doing phase 3.

            Thank you a lot !



            Answered 2020-May-04 at 00:49

            Solved. Our environment is CDH6.3.2 and I check the Namenode web ui port dfs.namenode.http-address on CM is 9870 instead of 50070. Change hdfs client connection conf. on the code above and it will work well


            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install impyla

            Install the latest release with pip:.


            You need to first sign and return an ICLA and CCLA before we can accept and redistribute your contribution. Once these are submitted you are free to start contributing to impyla. Submit these to
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • PyPI

            pip install impyla

          • CLONE
          • HTTPS


          • CLI

            gh repo clone cloudera/impyla

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link