[ARROW-9656] [Rust][DataFusion] Slightly confusing error message when unsupported type is provided to CREATE EXTERNAL TABLE

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: Rust, Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/25715
• Assignee: Andrew Lamb
• Reporter: Andrew Lamb
• Created: 05/Aug/20 14:40
• Updated: 11/Jan/23 08:08
• Resolved: 06/Aug/20 14:40

Description

When I make a typo in the CREATE EXTERNAL TABLE command, I get an error message that doesn't doesn't tell me the valid values of STORED AS:

As a user, I would like the software to guide me to the correct resolution and tell me what the supported formats are.

For example:

CREATE EXTERNAL TABLE repro
STORED AS ARROW
LOCATION 'repro.arrow';

results in:

> CREATE EXTERNAL TABLE repro
STORED AS ARROW
LOCATION 'repro.arrow';

ParserError(ParserError("Expected fileformat, found: ARROW"))

Ideally the error should say that the valid choices are PARQUET, CSV, or DSJSON

Issue Links

• links to: GitHub Pull Request #7905