That's only for the session, so if you start up the Hive cli set some params and do a query they will be used. Close client and start up a new hive cli session and you're back to defaults. To make it permanent you'll have to change them in the hive-site.xml. Hope that helps, Patrick.
Op wo 3 jun. 2020 om 09:58 schreef CASTELAIN FLORIAN < florian.castel...@viacesi.fr>: > Hello ! > > > > I would like to set the following parameters to different values that the > default one for a specific query only : > > > > hive.tez.container.size > > hive.tez.java.opts > > > > From my understanding, my query should contain these like : > > > > Set PARAM = VALUE ; > > > > > > But I would like to know if setting the parameter this way changes this > property ONLY for this query, or if it is definitive and thus I would > require to set it back to the previous value after the job is done. > > > > Regards > > > > Florian CASTELAIN > > > > PS : Sorry for previous mail, pressed wrong button… >