https://community.cloudera.com/t5/Support-Questions/select-count-inside-hive-giving-error/m-p/79663#M4610 Is it failing immediately or during the execution? Do you see the job running in YARN? If yes, try to increase map/reduce memories. If it fails immediately increase the client heap more - but it is wierd having 4g should be more than enough for a simple count.. Tue, 11 Sep 2018 17:44:10 GMT Tomas79 2018-09-11T17:44:10Z