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!