[GLUTEN-6262][CH]Json input format ignore key case #6263

KevinyhZou · web-flow · commit 2be6c86bef0a · 2024-07-08T15:04:23.000+08:00
What changes were proposed in this pull request? (Please fill in changes proposed in this fix) (Fixes: #6262) this pr is depend on clickhouse pr: ClickHouse/ClickHouse#61750 How was this patch tested? test by ut
diff --git a/backends-clickhouse/src/test/resources/text-data/json-settings/data.txt b/backends-clickhouse/src/test/resources/text-data/json-settings/data.txt
@@ -1,4 +1,5 @@
 {"a":1,"b":2,"c":3}
+{"a":"a5", "B":"b6", "c":7}
 {"a":"4"}
 {"t":{"ta":"cc","tb":100,"tc":1.234}}
 {"t":{"ta":"cc","tb":100,"td":"ignore"}}
diff --git a/cpp-ch/local-engine/Common/CHUtil.cpp b/cpp-ch/local-engine/Common/CHUtil.cpp
@@ -747,6 +747,7 @@ void BackendInitializerUtil::initSettings(std::map<std::string, std::string> & b
     settings.set("input_format_parquet_import_nested", true);
     settings.set("input_format_json_read_numbers_as_strings", true);
     settings.set("input_format_json_read_bools_as_numbers", false);
+    settings.set("input_format_json_ignore_key_case", true);
     settings.set("input_format_csv_trim_whitespaces", false);
     settings.set("input_format_csv_allow_cr_end_of_line", true);
     settings.set("output_format_orc_string_as_string", true);
