Set maximum containers on a Hive query

I have a hive insert statement which by default will use all available resources in YARN as it is reading a large volume of data.

I am happy for the query to take longer and use less resources so that other users can also have access to compute resources.

I don't want to set up YARN queues as this is an unusual query and so don't want to permanently restrict the cluster.

If I was using Spark can do this quite easily with setting a number of executors. Is there a hive config that allows me to do this at a query level.

I have looked at various other posts such as those below, but nothing seems to allow this.

 https://community.cloudera.com/t5/Support-Questions/How-to-control-number-of-containers-in-a-hive-query/td-p/297734 

https://community.cloudera.com/t5/Support-Questions/Is-there-a-way-to-set-minimum-maximum-number-of-containers/m-p/190660#M152749 

https://community.cloudera.com/t5/Support-Questions/Can-I-limit-the-number-of-containers-allocated-by-Tez/m-p/157020#M119433 

Also seen this: https://community.cloudera.com/t5/Support-Questions/How-are-number-of-mappers-determined-for-a-query-with-hive/m-p/94915 - but not sure if changing split sizes is a good idea. Would this then impact the structure of data stored by my data.

Grateful for any suggestions.