v.20.11Improvement

Enable Enum Value Parsing by Numeric IDs for CSV, TSV, and JSON Input Formats

Enable parsing enum values by their numeric ids for CSV, TSV and JSON input formats. #15685 (vivarum).
Enable parsing of Enum values by their numeric IDs when using CSV, TSV, and JSON input formats.

Why it matters

This feature allows users to input Enum values in numeric form instead of only string names when importing data using CSV, TSV, or JSON formats, simplifying data ingestion and improving compatibility with systems exporting numeric Enum representations.

How to use it

When inserting data via CSV, TSV, or JSON formats, you can now provide Enum values as their corresponding numeric IDs. ClickHouse will correctly parse these numeric values as Enum entries without additional configuration.