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 setting input_format_orc_read_use_writer_time_zone to input_format_orc_reader_timezone and allow the user to set the reader timezone. #67175 (kevinyhzou).
Rename the setting input_format_orc_read_use_writer_time_zone to input_format_orc_reader_timezone and allow users to specify the reader timezone when importing ORC files.

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 the input_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');