Issue

When trying to infer a new schema from a JSON log file, I got this error message:

 

schema validation failed: failed to infer Glue columns for "xxx": schema error at "xxx": column name collision "xxx": [xxx]

Resolution

To resolve this issue you can use the rename transformation in the schema fields that are generating this conflict.

Cause

This issue occurs when there are multiple fields with the same name resulting in a column collision in the proposed (from the schema inferring) database table.