Overview of basic Hive Queries


Let us get an overview of Basic Hive Queries.

  • Let us make sure _retail database is created.
  • Make sure orders and order_items tables are added in the database.
  • SQL Clauses
    • SELECT - Project fields or derived fields
    • FROM - Specify Tables
    • JOIN - Join multiple data sets. It can also be OUTER
    • WHERE - To filter data
    • GROUP BY [HAVING] - For group operations such as aggregation
    • ORDER BY - To sort the data

Practice hive on state of the art Big Data cluster - https://labs.itversity.com
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses