The Data Studio

Hive For SQL Developers

Hive SQL is almost, but not exactly, unlike SQL.

The Hive documentation is the ultimate reference and you should add it to your Favourites if you are going to be working with Hive.

Hive will, of course, change over time. New releases come along very fast and you do really need to keep up to date. I have to retest all the examples below every time that a new version comes out. I use the Hortonworks Sandbox to do this. Other distributions should be similar, but don't trust me or anyone else without testing it yourself. What I have tested so far in Hortonworks Data Platform (HDP), Release 2.5, has not been encouraging.

Here are some things that may catch you out:

Protest Warning My conclusions about Hive are subject to a Protest Warning.