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 ?


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 (

Thank you for your response!