DBeaver – Hive connection keep disconnecting

Cheat Code
SET Keep-Alive settings to 60 seconds

I love DBeaver! It’s a GUI tool to run queries and connect to various databases.
One of the reasons I really like this tool is because they can auto discover driver required to connect to our databases (Hive, SQL, Drill, yada yada.. you name it!) and download it automagically.

It also have nice UI (subjective) and just making browsing Hive database easier.

However when I set connection to HDInsight, very often whenever I want to run query after idling for awhile (dreaming and wondering why I exists….) it always trying to reconnect… re-establish connection… re-….re-…. damn slow (like 30 secs?).

Using the cheat code allow the DBeaver to remain connected by periodically ping the hive and ensure connection is alive.

Right click on the connection -> Edit Connection -> Connection Settings -> Initialization
Set Keep-alive 60 seconds.

Now I can daydreaming longer….. while still be happy.