---
title: Manually configure Hue in HDP
author: admin
type: post
date: 2019-03-02T06:29:46+00:00
url: /configure-ambari-hdp-with-hue/
sf_thumbnail_type:
- none
sf_thumbnail_link_type:
- link_to_post
sf_detail_type:
- none
sf_page_title:
- 1
sf_page_title_style:
- standard
sf_no_breadcrumbs:
- 1
sf_page_title_bg:
- none
sf_page_title_text_style:
- light
sf_background_image_size:
- cover
sf_author_info:
- 1
sf_social_sharing:
- 1
sf_related_articles:
- 1
sf_sidebar_config:
- left-sidebar
sf_left_sidebar:
- Sidebar-2
sf_right_sidebar:
- Sidebar-1
sf_caption_position:
- caption-right
sf_remove_promo_bar:
- 1
ampforwp-amp-on-off:
- default
categories:
- Administration
- Querying
- Browsing
- Version 4
---
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][1] the latest Hue and its dependencies:
{{< highlight bash >}}
yum install -y git
git clone https://github.com/cloudera/hue.git
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
{{< /highlight >}}
Build:
{{< highlight bash >}}
cd hue
sudo make apps
{{< /highlight >}}
**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]
2. On Ambari UI check `YARN --> Config --> Advanced --> Advanced` yarn-site yarn.resourcemanager.webapp.address and add it in hue.ini
[
][3]
3. On MySql server host usually host-1 create the Hue database:
{{< highlight bash >}}
ssh root@hue-1.example.com
mysql
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';
exit;
{{< /highlight >}}
4. On hue host update the hue.ini with following values
{{< highlight bash >}}
ssh root@hue-2.example.com
vim ~/hue/desktop/conf/pseudo-distributed.ini
{{< /highlight >}}
hue.ini{{< highlight bash >}} [beeswax] max_number_of_sessions=2 {{< /highlight >}} {{< highlight bash >}} [hadoop] webhdfs_url=http://hue-1.example.com:50070/webhdfs/v1 resourcemanager_api_url=http://hue-1.example.com:8088 {{< /highlight >}}
And run:{{< highlight bash >}} cd hue build/env/bin/hue syncdb build/env/bin/hue migrate build/env/bin/hue runcpserver {{< /highlight >}} 5. Go to the [hue-2.example.com:8888][4] to explore more and the [configuration page][5] for adding more components! [
][6]
[
][7]
As always please feel free to comment and send feedback on the [hue-user][8] list or [@gethue][9]!
[1]: http://cloudera.github.io/hue/latest/admin-manual/manual.html
[2]: https://cdn.gethue.com/uploads/2019/02/Screen-Shot-2019-02-27-at-3.05.28-PM.png
[3]: https://cdn.gethue.com/uploads/2019/02/Screen-Shot-2019-02-27-at-3.10.39-PM.png
[4]: http://hue-2.example.com:8888
[5]: https://gethue.com/how-to-configure-hue-in-your-hadoop-cluster/
[6]: https://cdn.gethue.com/uploads/2019/02/HiveEditor.png
[7]: https://cdn.gethue.com/uploads/2019/02/fileBrowser.png
[8]: http://groups.google.com/a/cloudera.org/group/hue-user
[9]: https://twitter.com/gethue