Please see the backward compatibility matrix at Hi, Vertica JDBC and ODBC drivers are backward compatible to server version 7.1.x, so it is recommended to use the latest available client driver. Please let me know why there is a time difference between JDBC and ODBC. 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. The number of data in the table is 400 million for A and 30 million for B. 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. When executing the same SQL statement with Aqua Data Studio using JDBC, it takes 2 seconds, Or, Please tell me exactly what ODBC is right for the Vertica Analytic Database v8.1.1-8.Īnd, for a general query, (SELECT A INNER JOIN B ON A.a=B.b. So, I would like to check if the 8.1.1 server can use 9.2.1 ODBC. So, we change the ODBC version to 9.0.1, 8.0.1, etc.Īnd, when using 9.2.1.2, The above errors appear less.īut in the official Vertica compatibility table It is recommended to use version 8.1 or lower when connecting to 8.1 Server. It may also appear in the normal Select statement. The above error may also appear upon initial connection, Our solution uses ODBC to connect to Vertica DB.īy the way, when using 8.1.1.16 ODBC, the following error occurs about 3 out of 10 queries.Įrror: # 20, (20) An error occurred during query execution: message do not agree with length in message type "T"Įrror: # 10, (10) An error occurred during query preparation: The following problems have occurred and we contact you.ĭB Server Version: Vertica Analytic Database v8.1.1-8 While supplying our solution to a company using Vertica DB,
0 Comments
Leave a Reply. |