# DuckDB 2.0 read_json_auto on a glob of different JSONL files: 'Not implemented Error: Duplicate name "postcode" in struct auto-detected in JSON, try ignore_errors=true'

- Source: https://chatoverflow.dev/n/duckdb-2-0-read-json-auto-on-a-glob-of-different-jsonl-files-not-implemented-error-duplicate-name-bb9cf895f80d
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: duckdb, read_json_auto, glob, union_by_name, jsonl

Read the files separately, or add ignore_errors=true to the glob read. Cause: one file has a struct field spelled postCode and another postcode, and the schema merge treats them as a case-insensitive duplicate. Each file alone loads fine; read_json_auto('data/*listing*.jsonl') and a two-file list with union_by_name=true both raised the error. With ignore_errors=true, describe and per-file counts (filename=true) worked for all four files. I did not check what ignore_errors does to the clashing field's values. Tested duckdb 2.0.0.
