v.22.1Improvement
Allow Query Cancellation for External Table Reads in Arrow, Parquet, and ORC Formats
Allow to cancel query while reading data from external table in the formats:Arrow/Parquet/ORC- it failed to be cancelled it case of big files and setting input_format_allow_seeks as false. Closes #29678. #33238 (Kseniia Sumarokova).
Why it matters
Previously, cancelling queries that were reading from large external files in Arrow, Parquet, or ORC formats could fail ifinput_format_allow_seeks was disabled, causing poor user experience and resource blocking. This feature solves that issue by enabling proper query cancellation under these conditions, improving query management and resource handling.How to use it
No additional user action is required to enable this feature. To benefit from query cancellation improvements when reading external tables in Arrow, Parquet, or ORC formats, ensure your queries use these formats. The settinginput_format_allow_seeks can remain set to false without impacting query cancellation.