v.22.4Improvement
Add Case Insensitive Column Matching Settings for ORC, Arrow, and Parquet in ClickHouse
Add settingsinput_format_orc_case_insensitive_column_matching,input_format_arrow_case_insensitive_column_matching, andinput_format_parquet_case_insensitive_column_matchingwhich allows ClickHouse to use case insensitive matching of columns while reading data from ORC, Arrow or Parquet files. #35459 (Antonio Andelic).
Why it matters
This feature addresses the problem of column name mismatches due to case differences when reading data from ORC, Arrow, or Parquet files. It improves data compatibility and ease of use by allowing ClickHouse to match columns without case sensitivity.How to use it
Enable case insensitive column matching by setting the respective settings:input_format_orc_case_insensitive_column_matching, input_format_arrow_case_insensitive_column_matching, and input_format_parquet_case_insensitive_column_matching to true before reading data from ORC, Arrow, or Parquet files.