Interactive SQL on Hadoop is now easier: New Impala and Hive Editors

Interactive SQL on Hadoop is now easier: New Impala and Hive Editors

The Impala and Hive applications have a new face! In addition to new features, their interfaces in Hue have been redesigned and re-implemented as single page apps.

Now:

  • Switching between pages is over
  • Results are asynchronously fetched
  • Results are graphed

Moreover, the table metadata are now directly accessible from the navigator tab and a smarter auto-completion.

Here is a demo of a typical query execution:

As usual feel free to comment on the hue-user list or @gethue!

10 Comments

  1. shivom 2 years ago

    Query: create database impalademodb;
    ERROR: AnalysisException: This Impala daemon is not ready to accept user requests. Status: Waiting for catalog update from th
    e StateStore.

    Why this type of error is raising?

    • Hue Team 2 years ago

      This is internal to Impala, it is probably syncing its list of tables metadata. You could restart it, check Impala Catalog service.

  2. juopian 1 year ago

    spark sql is more efficient than Hive, why not support Spark Sql?

    • Hue Team 1 year ago

      Because it is not always true and also more buggy (a lot of features are still missing: https://issues.cloudera.org/browse/HUE-2985). There is also Hive on Spark, Impala that work well. This is however open source and patches are welcome 😉

Leave a reply

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

*