i
Search icon

Hadoop Tutorial

Self Learning   /   Study Material   /   Hive Query Language
Previous
Next

Hive Query Language

Hive uses a query language, called Hive Query Language (HiveQL or HQL), which is very similar to SQL. Apache Hive is highly scalable as it can serve both the purposes, extensive data set processing (Batch processing) and real-time processing (Interactive processing). Hive gets internally gets converted into MapReduce programs. 

It supports all data types of SQL. We can even use predefined functions or write tailored user-defined functions (UDF) also to accomplish your specific needs.

  • Hive’s SQL language is known as HiveQL. It is a combination of SQL-92, Oracle's SQL language, and MySQL.

  • HiveQL provides some improved features from the previous version of SQL standards, like analytics function from SQL 2003.

  • Some Hive’s’ extension like multi-table inserts, TRANSFORM, MAP and REDUCE.

© All rights Reserved | SelfLearning.io