Tuesday Big Data Series

SQL and HiveQL query examples

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.

Screen Shot 2016-05-02 at 4.01.24 PM.png

Screen Shot 2016-05-02 at 4.09.02 PM.png

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

Like it? Tweet this!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s