I'm using DBeaver 3.4.5, Vertica 7.1.2 and the 7.1.2 jdbc driver.
I have a simple SELECT COUNT(*) query that takes much longer in DBeaver than in vsql. When I look at Query Manager and watch it run I notice:
1. The time spent is waiting on "Load Columns" on the Metadata connection.
2. The Duration seems to lie. It claims 2ms, however I watched it run for almost 3 minutes while the original query finished in only 20 seconds.
Are there any ways of digging further into this or disabling the metadata queries?
Thanks!