v.24.8Improvement
Rename setting input_format_orc_read_use_writer_time_zone to input_format_orc_reader_timezone and allow user to set reader timezone
Rename settinginput_format_orc_read_use_writer_time_zonetoinput_format_orc_reader_timezoneand allow the user to set the reader timezone. #67175 (kevinyhzou).
Why it matters
This change improves flexibility in handling ORC file timezones by enabling users to explicitly set the timezone used for reading timestamps, rather than relying on the writer's timezone. It resolves timezone interpretation issues and ensures accurate timestamp data import.How to use it
Set theinput_format_orc_reader_timezone setting to the desired timezone identifier before reading ORC files. For example, you can set it globally or within a query like:SET input_format_orc_reader_timezone = 'Europe/Moscow';
SELECT * FROM file_orc('data.orc');