Closed jiaxin11 closed 11 months ago
CREATE TABLE faceDetect.faceCache ( embedding Array(Float32) ) ENGINE = MergeTree
embedding
Array embedding = conn.createArrayOf("Float32", new Object[]{-1.4534375667572021});
PreparedStatement preparedStatement = conn.prepareStatement("INSERT INTO faceDetect.faceCache VALUES (?)"); preparedStatement.setArray(1, embedding); preparedStatement.execute();
Insert database value becomes [-1.4534376]
Here's my sql statement, but it doesn't work and the data is missing precision
CREATE TABLE faceDetect.faceCache (
embeddingArray(Float32) ) ENGINE = MergeTreeArray embedding = conn.createArrayOf("Float32", new Object[]{-1.4534375667572021});
PreparedStatement preparedStatement = conn.prepareStatement("INSERT INTO faceDetect.faceCache VALUES (?)"); preparedStatement.setArray(1, embedding); preparedStatement.execute();
Insert database value becomes [-1.4534376]
Here's my sql statement, but it doesn't work and the data is missing precision