02 March 2019

Manually configure Hue in HDP

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 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 Build:…

2 minutes read - Version 4

17 October 2018

Additional SQL improvements: Built-in Impala language reference, Improved column samples, Dark Mode

Hi SQL enthusiasts! We've made quite some improvements to the SQL experience in Hue 4.3, in a previous post we showed some of the new exploration improvements and now we'd like to show some additional new features in the editor. After the introduction of the UDF reference panel we've received requests to also include documentation for SQL syntax. It's quite common to look at the language reference while writing certain statements and it's annoying to have to have multiple windows open.…

2 minutes read - Version 4

17 October 2018

Hue 4.3 and its Analytics and Django improvements are out!

Hi Big Data Explorers,  The Hue Team is glad to thanks all the contributors and release Hue 4.3!   The focus of this release was a big refresh to upgrade Django to 1.11, the latest Python 2.7 compatible version at the time. It contains a log of improvements for the SQL Editor variables and catalog, as well as for the Dashboarding. It also prepares the ground for multi cluster support (HUE-8330) and building data apps more easily.…

2 minutes read - Version 4 / Release

14 September 2018

Configure Hue with Multi-Authentication: LDAP & DjangoBackend and Sync LDAP user/group

Aloha, Hue administrators,

Hue supports multi-authentication since Hue 3.9, we can turn on Hue’s multi-authentication by updating Hue configurations through CM UI or hue.ini.

On any CM-managed cluster, go to hue’s configuration page and search for “safety”:

http://YourCluster.com:7180/cmf/services/10/config#filterfreeText=safety</span>

Then update Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini as following:

[desktop]

[[auth]

backend=desktop.auth.backend.LdapBackend,desktop.auth.backend.AllowFirstUserDjangoBackend

Then configure Hue LDAP related configurations through CM UI: http://YourCluster.com:7180/cmf/services/10/config as following:

Here is a sample of the multi-authentication with ldap for /etc/hue/conf/hue.ini in case that you don’t have CM:

[desktop]

[[auth]

backend=desktop.auth.backend.LdapBackend,desktop.auth.backend.AllowFirstUserDjangoBackend

[[ldap]]

ldap_url=ldap://ldapserver.ad.com:389

search_bind_authentication=true

create_users_on_login=true

base_dn="ou=Test,DC=ad,DC=com"

bind_dn="[email protected]"

bind_password_script={{CMF_CONF_DIR}}/altscript.sh sec-5-bind_password

#bind_password="YourBindPassword"

[[[users]]]

user_filter="objectclass=user"

user_name_attr="sAMAccountName"

[[[groups]]]

group_filter="objectclass=group"

…

2 minutes read - Version 4

14 September 2018

Get a mode to allow easy profiling of requests

If Hue is running slow, how to find out the root cause? Now, in 4.3, Hue comes with a handy tool for profiling HTTP requests and responses thanks to Django Debug Toolbar and Django Debug Panel.   As the screenshots above, the Django Debug panel captures requests and list them on the left column, and it provides a list of panels on the right column that display various debug information about the each of request/response, like version, time, settings, header, SQL, and static files.…

1 minute read - Version 4

11 September 2018

How to Configure Hue to enable S3 file browser for standard or V4 regions

Hello, S3 cloud users, Hue started supporting S3 since Hue 3.9. Let’s go through the detailed steps to enable S3 on Hue for CM-managed cluster: Go to your CM UI: http://$YOURCMHost:7180/cmf/home Click on “Administration”->”External Accounts”, http://$YOURCMHost:7180/cmf/accounts?category=AWS On tab “AWS Credentials” Click on “Add Access Key Credentials” button to land following dialog Filled in your S3 key id and secret key then click “Add” to land follow page:…

2 minutes read - Version 4

17 August 2018

Finer grain privileges in the Sentry App

Aloha Security junkies! In an upcoming release of Hue we've added some Sentry finer grain privileges in the Security app and, as a bonus, we've embedded viewing privileges directly in the Table Browser. Accordingly to what object you are applying privileges to, you will get only the available options now. To summarize what's new, CREATE will work at the SERVER/DB scopes, while REFRESH/ALTER/DROP will work at the SERVER/DB/TABLE scopes.…

1 minute read - Version 4

17 August 2018

Improved dashboards layouts in Hue 4.3

Aloha dashboard rockers! In Hue 4.3 you can find a completely revamped way of building your usual dashboards. Long gone are the strict columns and rows constraints, welcome the drag and drop auto positioning! We also added several other functionalities, the most important ones being: Disappearance of the 'Edit mode' The pencil icon is now a plus In the previous versions of Hue there were two well distinct modes: a display dashboard to display your data and a version where you would have clear options to add new widgets, create columns, remove charts, etc.…

2 minutes read - Version 4

16 August 2018

Live Analytics of Live Apache log files

Quite some time ago (in 2014), a post demoed how to manually ingest some Apache Logs into Apache Solr and visualize via the Dynamic Dashboards. Nowadays, streaming data vs batching data is getting popular. This follow-up is actually levering the Flume / Solr blog post from Cloudera which contains more context about the format and services.  Hue already comes with an Apache Log collection that contain a schema with additional information like the city, country, browser user agent.…

3 minutes read - Version 4

06 July 2018

Improved Oozie Workflow display of large Graphs

Hello Job Scheduler/Oozie users, Previously, the Hue Job browser didn’t display the Oozie workflow Graph in the Graph tab for complex Oozie workflows (when the number of nodes are more than 30 or the workflow depth is more than 24). Since Hue 4.3 and Oozie 5, Oozie provides an API to get an SVG image of the workflows. This new feature helps to display an SVG image of complex workflows in the Dasboard interface.…

1 minute read - Version 4