Hive 1.1 and Impala 2.2 support

Hive 1.1 and Impala 2.2 support

Hive did a big jump by finally graduating to its 1.0 version version. It is even 1.1 now (equivalent to 0.14). Hue’s Hive and Impala Editor have been updated to take advantages of a series of their new features.

hive-editor-map

This release finally unifies the HiveServer2 API. All its API calls (e.g. getting the logs of a query) now belong to the upstream version. This makes Hue 100% compatible with any Hive 1.1+ version going forward and will solve a lot of integration headaches.

 

Another advantage is the support of the new columnar format which makes the fetching of result set data much faster.

 

If you are looking at the SSL configuration, check this previous blog post.

 

One more feature landing in Hue 3.8 that could interest some users is the Thrift HTTP support. We got this feature in for improving the interaction of the HBase App but can re-use it for free for HiveServer2.

 

By configure HiveServer2 in HTTP mode:

<property>
  <name>hive.server2.transport.mode</name>
  <value>http</value>
</property>

 

Hue will automatically pick it up if it points to a good hive-site.xml.

 

Anothe feature is the development of a Notebook UI (currently a beta version) that let’s you type SQL. You can know do quick prototyping and graphing!

sql-notebook

 

Next!

Coming up next are the support of HiveServer2 High Availability (HA) in order to support transparently rolling upgrades or server crashes. The new Notebook App is in heavy development and will share the same UI for the SQL editors.

More user friendliness is also on the way, with a visual display of table statistics and the autocomplete of nested types!

 

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

9 Comments

  1. dale 2 years ago

    Hello,
    In 3.8 is there a way to see how long a query took to execute in Hive? I know there is the JobBrowser but I’m looking for something like the Beeline shell where it displays information like so:

    17 rows selected (0.202 seconds)

    • Hue Team 2 years ago

      Yes there is. Check out the “Log” tab after submitting a query. You should see a line like “MapReduce Total cumulative CPU time: 4 seconds 130 msec”.

  2. Kumar 2 years ago

    not able to see the tables under database when user1 login(circle keeps rotating) but user 2 can see. both users are in the same group.

    Logout and login didnt work.

    • Hue Team 2 years ago

      Can the user click on the circled refresh icon? try in incognito mode? Any error in the js console or the Hue logs?

      Most probably this is just a Browser caching issue

      • Kumar 2 years ago

        I am seeing this error when I navigate to web log
        Apache Tomcat/6.0.44 – Error report HTTP Status 404 – /solr/log_analytics_demo/selecttype Status reportmessage /solr/log_analytics_demo/selectdescription The requested resource is not available.Apache Tomcat/6.0.44 (error 404

        • Hue Team 2 years ago

          This means the Hue search examples are not installed. You can install them on the Step #2 of the /about/ page

  3. Kumar 2 years ago

    Now its showing all the tables in the private mode. Thanks!!!

  4. Rishi 2 years ago

    Can you tell me what is the latest versions of HIVE and PIG used in HUE?

    • Hue Team 2 years ago

      Hue doesn’t ship Hive, Pig or any other component but it supports them and different versions of them

Leave a reply

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

*