a time difference between JDBC and ODBC.
While supplying our solution to a company using Vertica DB,
The following problems have occurred and we contact you.
== Base information ==
DB Server Version: Vertica Analytic Database v8.1.1-8
Vertica ODBC Client Version: 22.214.171.124, 126.96.36.199
Our solution uses ODBC to connect to Vertica DB.
By the way, when using 188.8.131.52 ODBC, the following error occurs about 3 out of 10 queries.
Error: # 20, [Vertica][VerticaDSII] (20) An error occurred during query execution: message do not agree with length in message type "T"
Error: # 10, [Vertica][VerticaDSII] (10) An error occurred during query preparation:
The above error may also appear upon initial connection,
It may also appear in the normal Select statement.
So, we change the ODBC version to 9.0.1, 8.0.1, etc..
And, when using 184.108.40.206, The above errors appear less.
but in the official Vertica compatibility table It is recommended to use version 8.1 or lower when connecting to 8.1 Server.
So, I would like to check if the 8.1.1 server can use 9.2.1 ODBC.
Or, Please tell me exactly what ODBC is right for the Vertica Analytic Database v8.1.1-8.
And, for a general query, (SELECT A INNER JOIN B ON A.a=B.b ... )
When executing the same SQL statement with Aqua Data Studio using JDBC, it takes 2 seconds,
Please tell us if there is a reason why it takes 80 seconds to use 8.1.1 ODBC or 9.2.1 ODBC or etc. .
The number of data in the table is 400 million for A and 30 million for B.
On our solution source, when I try to log before calling ODBC function SQLExecute (stmt) and log after call, the time difference is more than 80 seconds.
Please let me know why there is a time difference between JDBC and ODBC.