Skip to content

Amazon Athena SQL Parser Support in GSP

Explore the Amazon Athena SQL Parser product page

This page documents the SQL syntax support for Amazon Athena in the General SQL Parser.

Syntax Coverage Corpus

GSP tests Athena syntax against 32 documented constructs grouped into 11 categories, each cross-referenced to the documentation that defines it (29 distinct source pages).

Parse coverage

Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Athena documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.

Constructs fully parsed Individual statements parsed
All constructs 32 of 32 (100%) 72 of 72 (100%)
SELECT (queries) 3 of 3 (100%) 8 of 8 (100%)
DML (INSERT / UPDATE / DELETE / MERGE) 2 of 2 (100%) 6 of 6 (100%)
Stored procedures — —

Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.

Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview

All 32 constructs

Construct Category Parses Specified in
ALTER TABLE DROP PARTITION ALTER all 2 AWS docs
ALTER TABLE REPLACE COLUMNS ALTER all 1 AWS docs
ALTER TABLE ADD COLUMNS ALTER all 3 AWS docs
ALTER TABLE ADD PARTITION ALTER all 4 AWS docs
ALTER TABLE RENAME PARTITION ALTER all 1 AWS docs
ALTER TABLE SET LOCATION ALTER all 1 AWS docs
ALTER TABLE SET TBLPROPERTIES ALTER all 1 AWS docs
ALTER DATABASE SET DBPROPERTIES1 ALTER3 all 2 AWS docs
CREATE DATABASE CREATE all 2 AWS docs
CREATE TABLE CREATE all 1 AWS docs
CREATE TABLE AS CREATE all 1 AWS docs
CREATE VIEW CREATE all 3 AWS docs
DESCRIBE TABLE DESCRIBE all 2 AWS docs
DROP DATABASE DROP all 2 AWS docs
DROP TABLE DROP all 2 AWS docs
DROP VIEW DROP all 2 AWS docs
EXPLAIN EXPLAIN [ ( option [, ...]) ] statement all 4 AWS docs
INSERT INTO ...SELECT INSERT all 4 AWS docs
INSERT INTO...VALUES INSERT all 2 AWS docs
MSCK REPAIR TABLE MSCK all 1 AWS docs
SELECT SELECT all 3 AWS docs
SELECT Constant SELECT all 1 AWS docs
SELECT WHERE SELECT all 4 AWS docs
SHOW COLUMNS SHOW all 6 AWS docs
SHOW CREATE DATABASES SHOW all 2 AWS docs
SHOW CREATE TABLE SHOW all 2 AWS docs
SHOW CREATE VIEW SHOW all 1 AWS docs
SHOW PARTITIONS SHOW all 2 AWS docs
SHOW TABLES SHOW all 3 AWS docs
SHOW TBLPROPERTIES SHOW all 2 AWS docs
SHOW VIEWS SHOW all 2 AWS docs
UNLOAD UNLOAD all 3 AWS docs

Key Features Supported

  • Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
  • Presto-based SQL functions and data types
  • Serverless query operations
  • Window functions and analytical queries
  • Data catalog and Glue integrations
  • Partitioning and columnar formats