Manually configure Hue in HDP

02 March 2019 in Administration / Querying / Browsing / Version 4 - 2 minutes read

Hello Big Data users,

if you have an Ambari managed HDP cluster, here is a guide of how test the latest Hue. Note that the guide focuses on the SQL Editor and HDFS Browser only and assumes a non-secure cluster setup.

Step 1:

On any host other than Ambari server, run following commands to compile the latest Hue and its dependencies:

yum install -y git

git clone

sudo yum install -y ant asciidoc cyrus-sasl-devel cyrus-sasl-gssapi cyrus-sasl-plain gcc gcc-c++ krb5-devel libffi-devel libxml2-devel libxslt-devel make mysql mysql-devel openldap-devel python-devel sqlite-devel gmp-devel libtidy maven


cd hue

sudo make apps

Step 2:

Update Ambari Configurations

  1. Go to HDFS --> Configs --> Advanced Scroll down to expand “Custom core-site”, then click on “Add Property…” to add “hadoop.proxyuser.hue.hosts:*” and “hadoop.proxyuser.hue.groups:*” then “Save” as following.

  2. On Ambari UI check YARN --> Config --> Advanced --> Advanced yarn-site yarn.resourcemanager.webapp.address and add it in hue.ini

  1. On MySql server host usually host-1 create the Hue database:
ssh [email protected]


create user 'hueuser'@'localhost' identified by 'huepassword';

create database huedb default character set utf8 default collate utf8_general_ci;

grant all on huedb.* to 'hueuser'@'%' identified by 'huepassword';

  1. On hue host update the hue.ini with following values
ssh [email protected]

vim ~/hue/desktop/conf/pseudo-distributed.ini



And run:
cd hue build/env/bin/hue syncdb

build/env/bin/hue migrate

build/env/bin/hue runcpserver
  1. Go to the to explore more and the configuration page for adding more components!

As always please feel free to comment and send feedback on the hue-user list or @gethue!

comments powered by Disqus

More recent stories

13 November 2019
Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
Read More
31 October 2019
Missing some color? How to improve or add your own SQL syntax Highlighter
Read More
24 October 2019
How to create a HBase table on Kerberized Hadoop clusters
Read More