@Joav Bally the Hive server stops because of high Hiveserver 2 Heap Size. Go to Hive Services Click Config and scroll to the bottom In Storage section. Change the HiveServer2 heap Size.(Click the refresh icon that displays on hovering to set the recommended) Save the Current HDP and restart the hive service This will solve the issue. ... View more