Hue 3.11 with its new S3 Browser and SQL Autocomplete is out!

Hue 3.11 with its new S3 Browser and SQL Autocomplete is out!

Hi Big Data Adventurers,

 

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

The focus was on the integration with Amazon Cloud Service and improving the SQL user experience. More than 700 commits on top of 3.10 went in! Go grab the tarball release and give it a spin!


Download

Here is a list of the main improvements. For all the changes, check out the release notes.

 

 

S3 Browser

Hue can be setup to read and write to a configured S3 account, and users can directly query from and save data to S3 without any intermediate moving/copying to HDFS:

  • List, browse
  • Upload, download
  • Create external Hive table
  • Export query result
  • List S3 URI in Sentry
  • Set Oozie coordinator dependencies on S3 paths
  • Read more about it here…

s3-upload

SQL Autocompleter

To make your SQL editing experience better we’ve created a brand new autocompleter. The old one had some limitations and was only aware of parts of the statement being edited. The new autocompleter knows all the ins and outs of the Hive and Impala SQL dialects and will suggest keywords, functions, columns, tables, databases, etc. based on the structure of the statement and the position of the cursor.

  • Brand new SQL grammar for Hive and Impala
  • Support all the major operations like SELECT, CREATE, DROP
  • Autocomplete UDFs and show their documentation
  • Weight keywords and columns by importance
  • Infer the types and propose compatible columns or UDFs
  • Read more about it here…

sql-autocomp

SQL Result Refinements

The SQL Editor now brings a completely re-written result grid that improves the performances allowing big tables to be displayed without the browser to crash, plus some nifty tools for you.

  • Result grid improvements
  • Timeout popup when Impala hangs on fetch result
  • Offer to fix certain rows
  • Search through the results
  • Excel download now has a progress status
  • Fixed resultset legend and header when scrolling throught the results
  • Column and type search
  • Optimized to display hundred columns
  • Export SQL query result to Solr
  • Read more about it here…

result-refine

 

Solr Indexer

In the past, indexing data into Solr has been quite difficult. The task involved writing a Solr schema and a morphlines file then submitting a job to YARN to do the indexing. Often times getting this correct for non trivial imports could take a few days of work. Now with Hue’s new feature you can start your YARN indexing job in minutes. This tutorial offers a step by step guide on how to do it.

Read more about it here…

 

 

Conferences

IMG_4229

It was a pleasure to present at the Hadoop Summit in California:

Team Retreats

IMG_4409

 

Next!

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

Hue 4 design will get more real, with the goal of becoming the equivalent of “Gmail for queries for Big Data”. The current apps are being unified into the new Editor and the whole Hue will become a single app in order to provide a much smoother and faster UX.

 

Onwards!

 

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

 

11 Comments

  1. yujin 11 months ago

    hello, I just want to Know wheather the hue 3.11 support solr 6.2.0 is or not

    • Author
      Hue Team 11 months ago

      Not yet, we made some progress but Solr 5/6 support will come in Hue 4 or Hue 3.12 in Q1/Q2 next year.

  2. cola 11 months ago

    I try to use hue3.11 with sprak2.0.0 ,and finished hue.ini and livy.conf’s config,when want to create spark’s notebook,livy’s logs occur error so:
    16/11/09 20:55:31 INFO ContextLauncher: 16/11/09 20:55:31 WARN RSCConf: Set livy.rsc.rpc.server.address if you need to bind to another address.
    16/11/09 20:55:32 INFO ContextLauncher: 16/11/09 20:55:32 INFO RSCDriver: Received job request af46109d-72cf-446c-a5bc-cda54ee4476a
    16/11/09 20:55:32 INFO ContextLauncher: 16/11/09 20:55:32 INFO RSCDriver: SparkContext not yet up, queueing job request.
    16/11/09 20:55:32 WARN RSCClient: Client RPC channel closed unexpectedly.
    16/11/09 20:55:32 INFO RSCClient: Failing pending job af46109d-72cf-446c-a5bc-cda54ee4476a due to shutdown.
    16/11/09 20:55:32 INFO ContextLauncher: Exception in thread “main” java.lang.NoClassDefFoundError: scala/runtime/AbstractPartialFunction$mcVL$sp
    16/11/09 20:55:32 INFO ContextLauncher: at java.lang.ClassLoader.defineClass1(Native Method)
    16/11/09 20:55:32 INFO ContextLauncher: at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
    16/11/09 20:55:32 INFO ContextLauncher: at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
    16/11/09 20:55:32 INFO ContextLauncher: at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
    16/11/09 20:55:32 INFO ContextLauncher: at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
    16/11/09 20:55:32 INFO ContextLauncher: at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
    16/11/09 20:55:32 INFO ContextLauncher: at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    16/11/09 20:55:32 INFO ContextLauncher: at java.security.AccessController.doPrivileged(Native Method)
    16/11/09 20:55:32 INFO ContextLauncher: at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    16/11/09 20:55:32 INFO ContextLauncher: at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    16/11/09 20:55:32 INFO ContextLauncher: at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    16/11/09 20:55:32 INFO ContextLauncher: at com.cloudera.livy.repl.Session.start(Session.scala:63)
    16/11/09 20:55:32 INFO ContextLauncher: at com.cloudera.livy.repl.ReplDriver.initializeContext(ReplDriver.scala:55)
    16/11/09 20:55:32 INFO ContextLauncher: at com.cloudera.livy.rsc.driver.RSCDriver.run(RSCDriver.java:300)

    so,what’s wrong with it?thanks!

    • Author
      Hue Team 10 months ago

      When the error is pretty specific to Livy, could you ask on livy.io?

  3. dinesh aJ 8 months ago

    which version of hue supports Rhel 7 or python version 2.7 or is there any workaround to fix this python version mismatch

    • Author
      Hue Team 8 months ago

      Hue works with any Python 2.6+, as long as you compile it with the same Python as in your system.

Leave a reply

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

*