Using PreparedStatement with Vectors (SNOW-1260139)

[mhryb]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of JDBC driver are you using?
   3.21.0

2. What operating system and processor architecture are you using?
   Windows 10

3. What version of Java are you using?
   17

4. What did you do?

I try to use PreparedStatement with different approaches:

String insertSQL = "INSERT INTO test_vectors SELECT ?::VECTOR(FLOAT,3), ?::VECTOR(FLOAT,3)";
        try {
            Connection connection = DriverManager.getConnection(connectionUrl);
            PreparedStatement stmt = connection.prepareStatement(insertSQL);
            stmt.setArray(1, connection.createArrayOf("NUMBER", List.of(1,2,3).toArray()));
            stmt.setArray(2, connection.createArrayOf("NUMBER", List.of(1,2,3).toArray()));
            int rowsInserted = stmt.executeUpdate();
            if (rowsInserted > 0) {
                System.out.println("A new record was inserted successfully.");
            }
            stmt.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

But I got an error: net.snowflake.client.jdbc.SnowflakeLoggedFeatureNotSupportedException

String insertSQL = "INSERT INTO test_vectors SELECT strtok_to_array(?, ',')::VECTOR(FLOAT,3), strtok_to_array(?, ',')::VECTOR(FLOAT,3)";
        try {
            Connection connection = DriverManager.getConnection(connectionUrl);
            PreparedStatement stmt = connection.prepareStatement(insertSQL);
            stmt.setString(1, "1,2,3");    
            stmt.setString(2, "1,2,3");  
            int rowsInserted = stmt.executeUpdate();
            if (rowsInserted > 0) {
                System.out.println("A new record was inserted successfully.");
            }
            stmt.close();
            connection.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }

With this example I got error: net.snowflake.client.jdbc.SnowflakeSQLException: Array-like value being cast to a float vector has elements that are not real numbers

Also I tried to use stmt.setString(), stmt.setObject(). I changed the sql query:
"INSERT INTO test_vectors SELECT ?::VECTOR(FLOAT,3), ?::VECTOR(FLOAT,3)" but nothing helped.

Is there a way to use vectors with PreparedStatement?

5. What did you expect to see?

   I expect that I can use vectors with PreparedStatement.

[sfc-gh-dszmolka]

hi - thank you for your interest in this feature (using VECTOR datatype with variable binding in JDBC driver).
Currently, this use-case is unfortunately not supported.

It is indeed on the team's plans, without any committed timeline. I'll keep this thread posted if there's any new information on this topic. In the meantime, if you're already a Snowflake customer, please reach out to your Account Team and let them know how much you would need this capability.