Quick checking Hue's SQL Editor connections to Databases in Kubernetes

Published on 30 September 2020 in Administration / Version 4.9 - 2 minutes read - Read in jp

Let's see one way to quickly check why Hue can't connect to a SQL Database in the Kubernetes world.

We previously documented how to run Hue in Kubernetes or Docker.

The concept is to use the Database specific command shell on the command line to try to send some queries.

Apache Hive is the Data Warehouse used as example (but this would work the same with psql, mysql, …) or any other Database Hue can connect to.

This will install extra files in the current Hue pod but will enable you to test the interaction from the exact same location as the Hue service (so good for troubleshooting connectivity or authentication issues).


First check your Hive version in the SQL Editor:

SELECT version()

> 2.3.2 r857a9fd8ad725a53bd95c1b2d6612f9b1155f44d

Then list the Hue pods:

kubectl get pods

> NAME                                        READY   STATUS      RESTARTS   AGE
hue-758466dc77-wpcx8                        2/2     Running     0          22h
ingress-nginx-controller-5d6fbbddb6-8kd86   1/1     Running     0          23h
postgres-hue-64c9cc8744-dpk47               1/1     Running     1          47d

Connect to one:

kubectl exec -it hue-758466dc77-wpcx8 hue -- bash

Then get the client files of the same Hive version from:

And install them:

sudo apt-get install wget
wget https://archive.apache.org/dist/hadoop/core/hadoop-2.7.4/hadoop-2.7.4.tar.gz
wget https://archive.apache.org/dist/hive/hive-2.3.2/apache-hive-2.3.2-bin.tar.gz

tar -xvzf hadoop-2.7.4.tar.gz
tar -xvzf apache-hive-2.3.2-bin.tar.gz

export HADOOP_HOME=`pwd`/hadoop-2.7.4
export HIVE_HOME=`pwd`/apache-hive-2.3.2-bin
export JAVA_HOME=/usr/lib/jvm/java-1.11.0-openjdk-amd64


Now you are ready to connect:

beeline -u 'jdbc:hive2://'

> SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/share/hue/apache-hive-2.3.2-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/share/hue/hadoop-2.7.4/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://
Connected to: Apache Hive (version 2.3.2)
Driver: Hive JDBC (version 2.3.2)
Beeline version 2.3.2 by Apache Hive
0: jdbc:hive2://> SHOW TABLES;
|      tab_name      |
| about              |
| amandine_test      |
| city_cases         |
| cricketer          |
| cust1              |
| cust2              |
| customer           |
| customers          |
| student_info       |
| ........           |
| web_logs           |
| yash_contact_test  |
52 rows selected (0.098 seconds)

… and your SQL users can start self service querying again!

Hue Editor

Read more on the Hive wiki about the beeline command line.

Any feedback or question? Feel free to comment here or on the Forum and quick start SQL querying!


Romain from the Hue Team

comments powered by Disqus

More recent stories

10 January 2021
SQL Querying a log stream and outputting Calculations to another stream
Read More
31 December 2020
A Spark SQL Editor via Hue and the Spark SQL Server
Read More
17 November 2020
Easy Querying of live Kafka data in a Big Table like HBase with SQL
Read More