Hue 3.10 with its new SQL Editor is out!

Hue 3.10 with its new SQL Editor is out!

Hi Big Data Aficionados,


The Hue Team is glad to thanks all the contributors and release Hue 3.10! hue-logo (copy)

The focus of this release was to prepared the core of a new SQL user experience and the performances. More than 2000 commits on top of 3.9 went in! Go grab the tarball release and give it a spin!


You can find below a detailed description of what happened. For all the changes, check out the release notes or the documentation.

An upcoming series of video tutorials with more details is also on the way!

SQL Editor


Read more about it here…

SQL Browser




  • Folder and directories
  • Share document for collaboration
  • Export and import documents

Read more about it here…






Security & Scalability




  • External Workflow Graph: This feature enables us to see the graph for workflows submitted form File-browser as well as the ones submitted from CLI.
  • Dryrun Oozie job: The dryrun option tests running a workflow/coordinator/bundle job with given properties and does not create the job.
  • Timezone improvements: All the times on the dashboard are now defaulted to browser timezone and submitting a coordinator/bundle no longer need UTC times.
  • Emailing automatically on failure: Each kill node now embeds an optional email action. Edit a kill node to insert a custom message if case it gets called.

Read more about it here…



Right click on a file or directory to access their disk space consumed, quotas and number of directories and files.


Spark Table



It was a pleasure to present at the Spark Summit, Solr SF and Big Data Scala:

Team Retreats

2015-11-20 11.50.09



Next iteration (Hue 3.11, estimated for end of Q3) will focus on SQL improvements, job monitoring and Cloud integration.

Hue 4 design is also continuing, with the goal of becoming the equivalent of “Excel for Big Data”. A fresh new look, a unification of all the apps, wizards for ingesting data… will let you use the full platform (SQL, Search, Spark, Ingest) in a single UI for fast Big Data querying and prototyping!




As usual thank you to all the project contributors and for sending feedback and participating on the hue-user list or @gethue!



  1. Zhang Ruiqiang 3 years ago

    The download link doesn’t work in China Mainland. Is there a mirror or alternative site for use ?

    • Hue Team 3 years ago
      • Zhang Ruiqiang 3 years ago

        Thanks! I’v downloaded it from this url successfully.

      • Zhang Ruiqiang 3 years ago

        when I install it, there is a “No Such File Or Directory: ‘’)” error. Refer to the mail of mailing list, I’m afraid there are some bad old files in this tarball. Could you please upload a new one?

  2. xinwu246810 3 years ago

    I can not access this URL in China Mainland. Is there a alternative URL or site for use ?

    • Hue Team 3 years ago

      No, sorry! We have that group, this blog and the github issues.

  3. xinwu246810 3 years ago

    I installed Hue 3.9 and Livy(get from github). When started Hue and Livy, they worked well.
    But, there was a problem when I installed Hue 3.10 and started Hue 3.10 (The Livy is the same).
    I am getting the following error:

    16/05/19 17:04:35 INFO LivyServer: Using spark-submit version 1.4.1
    16/05/19 17:04:36 WARN RequestLogHandler: !RequestLog
    16/05/19 17:04:36 INFO WebServer: Starting server on http://master:8998
    16/05/19 17:05:47 INFO InteractiveSession: Creating LivyClient for sessionId: 0
    16/05/19 17:05:48 WARN RSCConf: Your hostname, master, resolves to a loopback address, but we couldn’t find any external IP address!
    16/05/19 17:05:48 WARN RSCConf: Set livy.local.rpc.server.address if you need to bind to another address.
    16/05/19 17:05:48 INFO SessionManager: Registering new session 0
    16/05/19 17:05:51 INFO ContextLauncher: Invalid initial heap size: -Xms1Gb
    16/05/19 17:05:51 INFO ContextLauncher: Error: Could not create the Java Virtual Machine.
    16/05/19 17:05:51 INFO ContextLauncher: Error: A fatal exception has occurred. Program will exit.
    16/05/19 17:05:51 WARN ContextLauncher: Child process exited with code 1.
    16/05/19 17:05:51 ERROR RSCClient: Failed to connect to context. Child process exited with code 1.
    at com.cloudera.livy.rsc.ContextLauncher$ChildProcess$
    at com.cloudera.livy.rsc.ContextLauncher$ChildProcess$
    16/05/19 17:05:51 INFO RSCClient: Failing pending job f02bd38a-cf53-490c-9105-90a543733f6c due to shutdown.
    16/05/19 17:05:51 WARN DefaultPromise: An exception was thrown by com.cloudera.livy.rsc.Utils$2.operationComplete()
    at com.cloudera.livy.rsc.RSCClient.stop(
    at com.cloudera.livy.rsc.RSCClient.connectionError(
    at com.cloudera.livy.rsc.RSCClient.access$200(
    at com.cloudera.livy.rsc.RSCClient$1.onFailure(
    at com.cloudera.livy.rsc.Utils$2.operationComplete(
    at io.netty.util.concurrent.DefaultPromise.notifyListener0(
    at io.netty.util.concurrent.DefaultPromise$
    at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(
    at io.netty.util.concurrent.SingleThreadEventExecutor$

  4. Mark 3 years ago

    After doing a git-pull of 3.10 tonight, MySQL RDBMS results are still not able to be downloaded?
    /notebook/editor?type=mysql … No download button. Is that expected?

  5. duankai 3 years ago

    Dear, Hue cannot support Chinese characters in SQL Editors, hive any solutions with Hue 3.10 version?

    1 biz_order_id bigint ???id
    2 gmt_create string ?????????
    3 gmt_modified string ?????????

    • Hue Team 3 years ago
      • duankai 3 years ago

        Thanks for you reply! I have created a table named “o2o_trade_bizorder_di” within “sdg” database, and append column comments used of Chinese character. SQL scripts as follow

        create table if not exists sdg.o2o_trade_bizorder_di
        biz_order_id bigint comment “主订单id”,
        gmt_create string comment “取主订单的创建时间”,
        gmt_modified string comment “取主订单的修改时间”,
        is_create string comment “是否当日下单”,
        is_pay string comment “是否当日付款”,
        is_succ string comment “是否当日确认收货”,

        partitioned by (dt string)

        Once table created, use command “desc sdg.o2o_trade_bizorder_di” to list the table infomation, but the Chinese character display as ???

        col_name data_type comment
        biz_order_id bigint ???id
        gmt_create string ?????????
        gmt_modified string ?????????
        is_create string ??????
        is_pay string ??????
        is_succ string ????????

        • Hue Team 3 years ago

          I just tried on Hue 3.10 and its works for me. Which Hive version are you using? It is probably a Hive setting issue.

          • duankai 3 years ago

            Thanks! solved

  6. Navi 3 years ago

    How to upgrade currently running hue 3.7.1 with 3.10 on amazon EMR service?

    • Hue Team 3 years ago

      I believe they are working on providing 3.10 but it is not there yet. Feel free to ask on the EMR forum directly!

  7. Debra 3 years ago

    I keep getting these errors when running make install with Hue 3.10.0. I don’t get these errors with Hue 3.8. Is there a particular dependency to fix this:

    c/_cffi_backend.c:5195: error: âcif_description_tâ has no member named âcifâ
    c/_cffi_backend.c:5196: error: âinvoke_callbackâ undeclared (first use in this function)
    c/_cffi_backend.c:5196: error: âFFI_OKâ undeclared (first use in this function)
    In file included from c/cffi1_module.c:3,
    from c/_cffi_backend.c:6417:
    c/realize_c_type.c: In function ârealize_c_type_or_funcâ:
    c/realize_c_type.c:577: error: âFFI_DEFAULT_ABIâ undeclared (first use in this function)
    c/_cffi_backend.c: In function âinit_cffi_backendâ:
    c/_cffi_backend.c:6509: error: âFFI_DEFAULT_ABIâ undeclared (first use in this function)
    error: command ‘gcc’ failed with exit status 1
    make[2]: *** [/usr/local/hadoop_apps/hue-3.10.0/desktop/core/build/cffi-1.5.2/egg.stamp] Error 1
    make[2]: Leaving directory `/usr/local/hadoop_apps/hue-3.10.0/desktop/core’
    make[1]: *** [.recursive-install-bdist/core] Error 2
    make[1]: Leaving directory `/usr/local/hadoop_apps/hue-3.10.0/desktop’
    make: *** [install-desktop] Error 2

    • Hue Team 3 years ago

      Hi! Which system are you building on? Did you update all the dependencies?

      • xu jin 3 years ago

        I have met the same problem with Debra.My os is centos6.6.When i use this os system to install hue-3.9,it’s OK.How can I fix this problem, Hue Team?

        • xu jin 3 years ago

          haha, I don’t update all the dependencies ! After this,it works!

          • Debra 3 years ago

            Hi Xu Jin,
            Are all the dependencies a part of your OS repos. Our issue is that these libraries are not a part of the Redhat 6 repositories. Redhat and Centos are a lot similar. Do you know where I can get these repos from?


      • Debra 3 years ago

        We are on Redhat 6.5 and the below dependencies are not a part of the repo packages:



        I am able to install HUE 3.8 without these dependencies but I would love to explore HUE 3.10.0 and its many new features.

  8. Pierre 3 years ago

    I tried to migrate a dummy installation from Hue-3.9 to Hue-3.10, I install Hue-3.9 with an sqlite database and then install Hue-3.10 and copy the database from Hue-3.9 and run ./build/env/bin/hue migrate. But when I try to connect to the new Hue-3.10 I got the following error:
    OperationalError: no such table: axes_accessattempt

    Did I miss something ? I want to validate this migration on a simple installation before going further on my production environment.

    • Hue Team 3 years ago

      Did you run ‘syncdb’ then ‘migrate’? Are you sure that you are pointing to the correct hue.ini / good DB?

      • Pierre 3 years ago

        It was indeed the syncdb command that I miss, but I have to admit that I was unable to find a proper “Upgrade” section in the release documentation.

        Thanks for the help.

  9. Adam 3 years ago

    Is there an ETA for when Hue 4 will be released?

    • Author
      Hue Team 3 years ago

      ETA for Hue 4 is roughly for 2nd quarter of 2017, we will know more at the end of the year, depending on the progress on the next SQL improvement steps.

  10. Ozgur Yavuz 2 years ago

    Dear Sir,

    when we try to install hue 3.10 in Rhel, we got the below error:

    This program built for x86_64-unknown-linux-gnu
    Reading makefiles…
    Reading makefile `Makefile’…
    Reading makefile `/u01/setup/hue-3.10.0/Makefile.sdk’ (search path) (no ~ expansion)…
    Reading makefile `/u01/setup/hue-3.10.0/Makefile.vars’ (search path) (no ~ expansion)…
    make[2]: Entering directory `/u01/setup/hue-3.10.0/desktop/libs/hadoop’
    Makefile:52: *** multiple target patterns. Stop.
    make[2]: Leaving directory `/u01/setup/hue-3.10.0/desktop/libs/hadoop’
    Reaping losing child 0x00f3bf30 PID 5458
    make[1]: *** [.recursive-env-install/libs/hadoop] Error 2
    Removing child 0x00f3bf30 PID 5458 from chain.
    make[1]: Leaving directory `/u01/setup/hue-3.10.0/desktop’
    Reaping losing child 0x01800090 PID 4684
    make: *** [desktop] Error 2
    Removing child 0x01800090 PID 4684 from chain.
    [gbenat01]/u01/setup/hue-3.10.0#vi /u01/setup/hue-3.10.0/Makefile.sdk

    Can you help us on this?

    Best regards,

  11. Ozgur Yavuz 2 years ago

    Dear Sir,

    Which version of Centos and Rhel is supported by HUE 3.10.

    Best regards,

  12. Dileep 2 years ago


    I have got this error when I connect hue with hive. please suggest
    Could not connect to localhost:10000 (code THRIFT TRANSPORT): TTransportException(‘Could not connect to localhost:10000’,)

  13. Krish 1 year ago

    Hi Team,

    We have installed Livyserver in MapR env, Livy is up and running. but i’m unable to see the Spark in Hue Query Editor.

    I have fallowed the steps from below link

    Could you please help me out.

    Thanks in advance.

Leave a reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.