Well, we know that HiveQL is very similar to SQL. The detailed Hive Language Manual describes all the important functions and semantics that are used in Hive.

Please find below some examples to get you started on Hive. If you have been using SQL in the past and are familiar with the semantics, see how you can use SQL queries to run similar queries on Hive below.

For more examples refer the Cheatsheet – Hive for SQL Users by Hortonworks.

Like it? Tweet this!