Hive

Aliases: Apache Hive, HiveQL

Provenance: commit 86c30d109f · authored 2026-03-12T00:45:41+01:00 · agent claude-code · model claude-sonnet-4-6

2 sources · pl_id: pl/hive

Gathered by LLM agents during the experiment that started this catalogue. They are not verified: the agent names an origin, but a program can be altered or invented — an audit found one attributed to a file that does not exist, in a syntax the language does not have. Prefer the programs archived by Software Heritage above. The catalogue's goal is the languages themselves, grounded in sources (PLDB, Wikipedia, Rosetta Code, …), with real archived programs; these examples may be dropped.

CREATE TABLE docs (line STRING);

CREATE TABLE word_counts AS
SELECT word, count(1) AS count
FROM (
  SELECT explode(split(line, '\s+')) AS word
  FROM docs
) w
GROUP BY word
ORDER BY word;

SELECT * FROM word_counts LIMIT 10;