How to increase download limit over 1 million

I tried to export over 1 million records of hive as CSV but I am getting “Downloads are limited to one million records”

So I try to alter this options,but it seems to be ineffective

Can you help me ?
Thanks

Hi,

It is currently not configurable. We usually recommend people use ODBC/JDBC to retrieve large results - the other choice is to use our CREATE TABLE AS functionality (https://www.dremio.com/tutorials/high-performance-parallel-exports/).

Thank you for your response!