On my HDP 2.3.4 cluster, I have configured maximum YARN container size to 102GB and restarted related services. But on the Hive service config page on Ambari, it only allows me to configure hive.tez.container.size up to around 6GB.
Is there any limits on max Hive Tez container size?
I dont think the scale you see is any kind of upper limit to "Tez Container Size", you can always override it with input box(click on pencil icon) and set the value manually. But take care and keep it similar to Actual container size.
Sounds that, Tez container size cannot be increased beyond 6820 from the Scale in Ambari or by editing with the pencil.
Yes, as Sunile mentioned the Tez container Value set in the Ambari can overriden in the hive prompt, but the value needs to be mentioned as INT. (MB cannot be included).
output of hive> set -v;
You can always override this on a per job or query basis using