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!


Download

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

sql-editor

Read more about it here…

SQL Browser

sql-browser

Home

home2

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

Read more about it here…

 

Spark

notebook-october

Search

search-grid-plot

Security & Scalability

meta-quick

Oozie

hue-workflows

  • 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…

HDFS

fb-summary-icon

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

Tutorials

Spark Table

Conferences

IMG_5690

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!

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!

 

Onwards!

 

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

 

36 Comments

  1. Zhang Ruiqiang 1 year ago

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

    • Hue Team 1 year ago
      • Zhang Ruiqiang 1 year ago

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

      • Zhang Ruiqiang 1 year ago

        when I install it, there is a “No Such File Or Directory: ‘setup.py’)” 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 1 year ago

    I can not access this URL http://groups.google.com/a/cloudera.org/group/hue-user in China Mainland. Is there a alternative URL or site for use ?

    • Hue Team 1 year ago

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

  3. xinwu246810 1 year 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.
    java.io.IOException: Child process exited with code 1.
    at com.cloudera.livy.rsc.ContextLauncher$ChildProcess$1.run(ContextLauncher.java:380)
    at com.cloudera.livy.rsc.ContextLauncher$ChildProcess$2.run(ContextLauncher.java:454)
    at java.lang.Thread.run(Thread.java:745)
    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()
    java.lang.NullPointerException
    at com.cloudera.livy.rsc.RSCClient.stop(RSCClient.java:222)
    at com.cloudera.livy.rsc.RSCClient.connectionError(RSCClient.java:131)
    at com.cloudera.livy.rsc.RSCClient.access$200(RSCClient.java:51)
    at com.cloudera.livy.rsc.RSCClient$1.onFailure(RSCClient.java:83)
    at com.cloudera.livy.rsc.Utils$2.operationComplete(Utils.java:110)
    at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
    at io.netty.util.concurrent.DefaultPromise$2.run(DefaultPromise.java:592)
    at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:380)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
    at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)
    at java.lang.Thread.run(Thread.java:745)

  4. Mark 1 year 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 1 year ago

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

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

    • Hue Team 1 year ago
      • duankai 1 year 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 1 year 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 1 year ago

            Thanks! solved

  6. Navi 1 year ago

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

    • Hue Team 1 year 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 1 year 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 1 year ago

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

      • xu jin 1 year 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 1 year ago

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

          • Debra 1 year 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?

            libsasl2-dev
            libsasl2-modules-gssapi-mit
            libkrb5-dev

      • Debra 1 year ago

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

        libsasl2-modules-gssapi-mit

        libkrb5-dev

        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 1 year ago

    Hi,
    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.
    Thanks

    • Hue Team 1 year ago

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

      • Pierre 1 year 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 11 months ago

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

    • Author
      Hue Team 11 months 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 3 months 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 3 months ago

    Dear Sir,

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

    Best regards,

Leave a reply

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

*