This article will help understand the issue and provide the work-around
Environment
Vertica vertica 23.x and 12.x JDBC driver
Situation
The query runs slower from a client (Locator) using the 2.x JDBC driver nut the same query run faster when run from vsql