0

We are trying to build dashboard reports using Superset and got it installed. We want to build the reports based on Impala tables. When trying to configure the datasource, I used the below sqlalchemy URI

impala://host:port/dbname

I get the below error when testing the connection. masked the hostname for security reason.

enter image description here

we have already installed impyla

pip install impyla
Collecting impyla
  Downloading impyla-0.14.0.tar.gz (151kB)
    100% |████████████████████████████████| 153kB 4.7MB/s
Requirement already satisfied: six in ./venv/lib/python2.7/site-packages (from impyla)
Collecting bitarray (from impyla)
  Downloading bitarray-0.8.1.tar.gz (46kB)
    100% |████████████████████████████████| 51kB 5.8MB/s
Requirement already satisfied: thrift in ./venv/lib/python2.7/site-packages (from impyla)
Building wheels for collected packages: impyla, bitarray
  Running setup.py bdist_wheel for impyla ... done
  Stored in directory: /root/.cache/pip/wheels/96/fa/d8/40e676f3cead7ec45f20ac43eb373edc471348ac5cb485d6f5
  Running setup.py bdist_wheel for bitarray ... done
  Stored in directory: /root/.cache/pip/wheels/46/63/90/821699390044b2d0c5f2a01f275115e240bd06f0edc6c6a19b
Successfully built impyla bitarray
Installing collected packages: bitarray, impyla
Successfully installed bitarray-0.8.1 impyla-0.14.0

Please let me know if I am missing anything else here to configure the impala to use with Superset

TylerH
  • 20,799
  • 66
  • 75
  • 101
ppeddi
  • 3
  • 9

1 Answers1

0

The easiest way to have everything perfectly working is to use the docker image (https://hub.docker.com/r/amancevice/superset/)

If you want to install everything by yourself, you can check the list of requirements directly from the official dockerfile.(https://hub.docker.com/r/amancevice/superset/~/dockerfile/):

Specially see:

apt-get install -y \
    build-essential \
    curl \
    default-libmysqlclient-dev \
    libffi-dev \
    libldap2-dev \
    libpq-dev \
    libsasl2-dev \
    libssl-dev \
    openjdk-8-jdk \
    python3-dev \
    python3-pip && \
apt-get clean && \
rm -r /var/lib/apt/lists/* && \
pip3 install --no-cache-dir \
    flask-cors==3.0.3 \
    flask-mail==0.9.1 \
    flask-oauth==0.12 \
    flask_oauthlib==0.9.3 \
    gevent==1.2.2 \
    impyla==0.14.0 \
    mysqlclient==1.3.7 \
    psycopg2==2.6.1 \
    pyathenajdbc==1.2.0 \
    pyhive==0.5.0 \
    pyldap==2.4.28 \
    redis==2.10.5 \
    sqlalchemy-redshift==0.5.0 \
    sqlalchemy-clickhouse==0.1.1.post3 \
    Werkzeug==0.12.1 \
    superset==${SUPERSET_VERSION}

Also, in the field Database write my_db.my_table and in SQLAlchemy URI write impala://host:port

Andrs Zam
  • 1
  • 1