1414976 - Athena has poor error messages

Status: RESOLVED WONTFIX

(Data Platform and Tools Graveyard :: Presto, defect)

Description

[Anthony Miyaguchi [:amiyaguchi]]

Take the following query:

> SELECT client_id,
>        distinct(client_id)
> FROM main_summary LIMIT 10

This query is invalid. Athena returns the following message which is not useful when debugging larger queries.

> Error running query: An error occurred (InvalidRequestException) when calling the StartQueryExecution operation: Queries of this type are not supported 

Swapping to Presto gives the following error message which is actually useful.

> Error running query: line 2:8: extraneous input 'distinct' expecting {'(', '?', 'ADD', 'ALL', 'ANALYZE', 'ANY', 'ARRAY', 'ASC', 'AT', 'BERNOULLI', 'CALL', 'CASCADE', 'CASE', 'CAST', 'CATALOGS', 'COALESCE', 'COLUMN', 'COLUMNS', 'COMMENT', 'COMMIT', 'COMMITTED', 'CURRENT', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'DATA', 'DATE', 'DAY', 'DESC', 'DISTRIBUTED', 'EXCLUDING', 'EXISTS', 'EXPLAIN', 'EXTRACT', 'FALSE', 'FILTER', 'FIRST', 'FOLLOWING', 'FORMAT', 'FUNCTIONS', 'GRANT', 'GRANTS', 'GRAPHVIZ', 'GROUPING', 'HOUR', 'IF', 'INCLUDING', 'INPUT', 'INTEGER', 'INTERVAL', 'ISOLATION', 'LAST', 'LATERAL', 'LEVEL', 'LIMIT', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOGICAL', 'MAP', 'MINUTE', 'MONTH', 'NFC', 'NFD', 'NFKC', 'NFKD', 'NO', 'NORMALIZE', 'NOT', 'NULL', 'NULLIF', 'NULLS', 'ONLY', 'OPTION', 'ORDINALITY', 'OUTPUT', 'OVER', 'PARTITION', 'PARTITIONS', 'POSITION', 'PRECEDING', 'PRIVILEGES', 'PROPERTIES', 'PUBLIC', 'RANGE', 'READ', 'RENAME', 'REPEATABLE', 'REPLACE', 'RESET', 'RESTRICT', 'REVOKE', 'ROLLBACK', 'ROW', 'ROWS', 'SCHEMA', 'SCHEMAS', 'SECOND', 'SERIALIZABLE', 'SESSION', 'SET', 'SETS', 'SHOW', 'SMALLINT', 'SOME', 'START', 'STATS', 'SUBSTRING', 'SYSTEM', 'TABLES', 'TABLESAMPLE', 'TEXT', 'TIME', 'TIMESTAMP', 'TINYINT', 'TO', 'TRANSACTION', 'TRUE', 'TRY_CAST', 'TYPE', 'UNBOUNDED', 'UNCOMMITTED', 'USE', 'VALIDATE', 'VIEW', 'WORK', 'WRITE', 'YEAR', 'ZONE', '+', '-', '*', STRING, UNICODE_STRING, BINARY_LITERAL, INTEGER_VALUE, DECIMAL_VALUE, IDENTIFIER, DIGIT_IDENTIFIER, QUOTED_IDENTIFIER, BACKQUOTED_IDENTIFIER, DOUBLE_PRECISION}