HiveQL

HiveQL is a query language created in 2011.

#1038on PLDB

13Years Old

502Repos

SQL-like query language interface called the Hive query language. While based on SQL, HiveQL does not strictly follow the full SQL-92 standard. Internally, a compiler translates HiveQL statements into a directed acyclic graph of MapReduce, Tez, or Spark jobs, which are submitted to Hadoop for execution.

HiveQL website
There are at least 502 HiveQL repos on GitHub
file extensions for HiveQL include q and hql
The Google BigQuery Public Dataset GitHub snapshot shows 135 users using HiveQL in 143 repos on GitHub
GitHub supports syntax highlighting for HiveQL
There is 1 Jupyter Kernel for HiveQL
Read more about HiveQL on the web: 1.

Example from the web:

4 CREATE TABLE word_counts AS
5 SELECT word, count(1) AS count FROM
6 (SELECT explode(split(line, '\s')) AS word FROM docs) temp
7 GROUP BY word
8 ORDER BY word;

Example from Linguist:

set hive.mapred.mode=nonstrict;
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

-- SORT_QUERY_RESULTS

create table nzhang_t1 like srcpart;
create table nzhang_t2 like srcpart;

FROM srcpart 
INSERT OVERWRITE TABLE nzhang_t1 PARTITION (ds, hr) 
SELECT key, value, ds, hr
WHERE ds = '2008-04-08' AND hr = '11'
INSERT OVERWRITE TABLE nzhang_t2 PARTITION (ds, hr) 
SELECT key, value, ds, hr
WHERE ds = '2008-04-08' and hr = '12'
GROUP BY key, value, ds, hr;

show partitions nzhang_t1;
show partitions nzhang_t2;

select * from nzhang_t1;
select * from nzhang_t2;

Feature	Supported	Token	Example
Comments	✓		-- A comment
Line Comments	✓	--	-- A comment
Semantic Indentation	X

HiveQL - Query language

Language features