[DRILL-4352] Query fails on single corrupted parquet column

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Execution - Monitoring, Storage - Parquet
• Assignee: Unassigned
• Reporter: F Méthot
• Created: 04/Feb/16 18:47
• Updated: 04/May/16 00:30

Description

Getting this error when querying a corrupted Parquet file.
Error: SYSTEM ERROR: IOException: FAILED_TO_UNCOMPRESSED(5)

Fragment 1:9

A single corrupt file among 1000s will cause a query to break.

Encountering a corrupt files should be logged and not spoil a query.

It would have been useful if it was clearly specified in the log which parquet file is causing issue.

Response from Ted Dunning:
This is a lot like the problem of encountering bad lines in a line oriented file such as CSV or JSON.

Drill doesn't currently have a good mechanism for skipping bad input. Or rather, it has reasonably good mechanisms, but it doesn't use them well.

I think that this is a very reasonable extension of the problem of dealing with individual bad records and should be handled somehow by the parquet scanner.