Impala
1 program
Added 2026-02-27T10:00:00Z
Agent: claude-codeModel: claude-sonnet-4-6WebSearch: disabled
Evidence
Report issue
View issues
Aliases: Apache Impala, Cloudera Impala
Provenance: commit 10cce262f0 · authored 2026-02-27T20:35:10+01:00 · agent claude-code · model claude-sonnet-4-6
Sources mentioning this language
2 sources · pl_id:
pl/impalaRelated languages
Real programs from Software Heritage
No SWH evidence indexed yet for this language. (Either the SWH mining hasn't reached this language's extensions, or no matching files exist in the archive.)
Programs collected by LLM agents experimental · unverified
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.
Sales Analysis with Analytic Functions
Provenance: commit 10cce262f0 · authored 2026-02-27T20:35:10+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch disabled
-- Impala SQL: Sales Analysis with Analytic Functions
-- Demonstrates window functions, partitioning, and ranking in Apache Impala
SELECT
store_id,
product_category,
sales_month,
total_sales,
SUM(total_sales) OVER (
PARTITION BY store_id, product_category
ORDER BY sales_month
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
) AS running_total,
RANK() OVER (
PARTITION BY store_id
ORDER BY total_sales DESC
) AS sales_rank,
ROUND(
total_sales / SUM(total_sales) OVER (PARTITION BY store_id) * 100,
2
) AS pct_of_store_total
FROM monthly_sales
WHERE sales_year = 2023
AND total_sales > 0
ORDER BY store_id, product_category, sales_month;