探索腾讯云向量数据库：从入门开始

- _表格形式的数据表示：_ 学生表包含学生的学号、姓名、课程表包含课程信息。
- _SQL查询：_ `SELECT * FROM Students WHERE Grade > 90;`

- _键值对形式的数据表示：_ 存储用户配置信息，如`{"username": "user1", "email": "user1@example.com"}`。
- _动态数据：_ 社交媒体中用户的实时更新。

- _向量表示的数据：_ 图像可以被表示为高维向量，其中每个维度表示图像的某个特征。
- _相似性搜索：_ 寻找与给定图像向量相似的其他图像向量。

com.tencent.tcvectordb:vectordatabase-sdk-java:1.0.3

 <dependency>
      <groupId>com.tencent.tcvectordb</groupId>
      <artifactId>vectordatabase-sdk-java</artifactId>
      <version>1.0.3</version>
 </dependency>
<dependency>

<groupId>org.web3j</groupId>

<artifactId>core</artifactId>

<version>5.0.0</version>

</dependency>
<dependency>

<groupId>com.squareup.okhttp3</groupId>

<artifactId>okhttp</artifactId>

<version>4.9.2</version>

</dependency>

package com.example.demo.controller;

import com.tencent.tcvectordb.client.VectorDBClient;

import com.tencent.tcvectordb.exception.VectorDBException;

import com.tencent.tcvectordb.model.Collection;

import com.tencent.tcvectordb.model.Database;

import com.tencent.tcvectordb.model.DocField;

import com.tencent.tcvectordb.model.Document;

import com.tencent.tcvectordb.model.param.collection.;

import com.tencent.tcvectordb.model.param.database.ConnectParam;

import com.tencent.tcvectordb.model.param.dml.;

import com.tencent.tcvectordb.model.param.entity.AffectRes;

import com.tencent.tcvectordb.model.param.enums.ReadConsistencyEnum;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

/**


VectorDB Java SDK usage example

*/

public class VectorDBExample {
private static final String DBNAME = "book";

private static final String COLL_NAME = "book_segments";

private static final String COLL_NAME_ALIAS = "collection_alias";
public static void main(String[] args) throws InterruptedException {

example();

}
public static void example() throws InterruptedException {

// 创建 VectorDB Client

ConnectParam connectParam = initConnectParam();

VectorDBClient client = new VectorDBClient(connectParam, ReadConsistencyEnum.EVENTUAL_CONSISTENCY);
 // 测试前清理环境
 System.out.println("---------------------- clear before test ----------------------");
 anySafe(() -> clear(client));
 createDatabaseAndCollection(client);
 upsertData(client);
 queryData(client);
 updateAndDelete(client);
 deleteAndDrop(client);
 testFilter();

}
/**

init connect parameter
@return {@link ConnectParam}

*/

private static ConnectParam initConnectParam() {

//        System.out.println("\tvdb_url: " + System.getProperty("vdb_url"));

//        System.out.println("\tvdb_key: " + System.getProperty("vdb_key"));

return ConnectParam.newBuilder()

.withUrl("http://lb-xxxxxxxxxx.com")

.withUsername("你自己的用户名")

.withKey("你自己的密码")

.withTimeout(30)

.build();

}

/**

执行 {@link Runnable} 捕获所有异常
@param runnable {@link Runnable}

*/

private static void anySafe(Runnable runnable) {

try {

runnable.run();

} catch (VectorDBException e) {

System.err.println(e);

e.printStackTrace();

}

}

private static void createDatabaseAndCollection(VectorDBClient client) {

// 1. 创建数据库

System.out.println("---------------------- createDatabase ----------------------");

Database db = client.createDatabase(DBNAME);
 // 2. 列出所有数据库
 System.out.println("---------------------- listCollections ----------------------");
 List<String> database = client.listDatabase();
 for (String s : database) {
     System.out.println("\tres: " + s);
 }

 // 3. 创建 collection
 System.out.println("---------------------- createCollection ----------------------");
 CreateCollectionParam collectionParam = initCreateCollectionParam(COLL_NAME);
 db.createCollection(collectionParam);

 // 4. 列出所有 collection
 System.out.println("---------------------- listCollections ----------------------");
 List<Collection> cols = db.listCollections();
 for (Collection col : cols) {
     System.out.println("\tres: " + col.toString());
 }

 // 5. 设置 collection 别名
 System.out.println("---------------------- setAlias ----------------------");
 AffectRes affectRes = db.setAlias(COLL_NAME, COLL_NAME_ALIAS);
 System.out.println("\tres: " + affectRes.toString());

 // 6. describe collection
 System.out.println("---------------------- describeCollection ----------------------");
 Collection descCollRes = db.describeCollection(COLL_NAME);
 System.out.println("\tres: " + descCollRes.toString());

 // 7. delete alias
 System.out.println("---------------------- deleteAlias ----------------------");
 AffectRes affectRes1 = db.deleteAlias(COLL_NAME_ALIAS);
 System.out.println("\tres: " + affectRes1);

 // 8. describe collection
 System.out.println("---------------------- describeCollection ----------------------");
 Collection descCollRes1 = db.describeCollection(COLL_NAME);
 System.out.println("\tres: " + descCollRes1.toString());

}
private static void upsertData(VectorDBClient client) throws InterruptedException {

Database database = client.database(DBNAME);

Collection collection = database.describeCollection(COLL_NAME);

List<Document> documentList = new ArrayList<>(Arrays.asList(

Document.newBuilder()

.withId("0001")

.withVector(Arrays.asList(0.2123, 0.21, 0.213))

.addDocField(new DocField("bookName", "西游记"))

.addDocField(new DocField("author", "吴承恩"))

.addDocField(new DocField("page", 21))

.addDocField(new DocField("segment", "富贵功名，前缘分定，为人切莫欺心。"))

.build(),

Document.newBuilder()

.withId("0002")

.withVector(Arrays.asList(0.2123, 0.22, 0.213))

.addDocField(new DocField("bookName", "西游记"))

.addDocField(new DocField("author", "吴承恩"))

.addDocField(new DocField("page", 22))

.addDocField(new DocField("segment",

"正大光明，忠良善果弥深。些些狂妄天加谴，眼前不遇待时临。"))

.build(),

Document.newBuilder()

.withId("0003")

.withVector(Arrays.asList(0.2123, 0.23, 0.213))

.addDocField(new DocField("bookName", "三国演义"))

.addDocField(new DocField("author", "罗贯中"))

.addDocField(new DocField("page", 23))

.addDocField(new DocField("segment", "细作探知这个消息，飞报吕布。"))

.build(),

Document.newBuilder()

.withId("0004")

.withVector(Arrays.asList(0.2123, 0.24, 0.213))

.addDocField(new DocField("bookName", "三国演义"))

.addDocField(new DocField("author", "罗贯中"))

.addDocField(new DocField("page", 24))

.addDocField(new DocField("segment", "富贵功名，前缘分定，为人切莫欺心。"))

.build(),

Document.newBuilder()

.withId("0005")

.withVector(Arrays.asList(0.2123, 0.25, 0.213))

.addDocField(new DocField("bookName", "三国演义"))

.addDocField(new DocField("author", "罗贯中"))

.addDocField(new DocField("page", 25))

.addDocField(new DocField("segment",

"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。"))

.build()));

System.out.println("---------------------- upsert ----------------------");

InsertParam insertParam = InsertParam.newBuilder().addAllDocument(documentList).withBuildIndex(true).build();

collection.upsert(insertParam);
 // notice：upsert 操作可用会有延迟
 Thread.sleep(1000 * 5);

}
private static void queryData(VectorDBClient client) {

Database database = client.database(DBNAME);

Collection collection = database.describeCollection(COLL_NAME);
 System.out.println(&#34;---------------------- query ----------------------&#34;);
 List&lt;String&gt; documentIds = Arrays.asList(&#34;0001&#34;, &#34;0002&#34;, &#34;0003&#34;, &#34;0004&#34;, &#34;0005&#34;);
 Filter filterParam = new Filter(&#34;bookName=\&#34;三国演义\&#34;&#34;);
 List&lt;String&gt; outputFields = Arrays.asList(&#34;id&#34;, &#34;bookName&#34;);
 QueryParam queryParam = QueryParam.newBuilder()
         .withDocumentIds(documentIds)
         // 使用 filter 过滤数据
         .withFilter(filterParam)
         // limit 限制返回行数，1 到 16384 之间
         .withLimit(2)
         // 偏移
         .withOffset(1)
         // 指定返回的 fields
         .withOutputFields(outputFields)
         // 是否返回 vector 数据
         .withRetrieveVector(false)
         .build();
 List&lt;Document&gt; qdos = collection.query(queryParam);
 for (Document doc : qdos) {
     System.out.println(&#34;\tres: &#34; + doc.toString());
 }

 // searchById
 // 1. searchById 提供按 id 搜索的能力
 // 2. 支持通过 filter 过滤数据
 // 3. 如果仅需要部分 field 的数据，可以指定 output_fields 用于指定返回数据包含哪些 field，不指定默认全部返回
 // 4. limit 用于限制每个单元搜索条件的条数，如 vector 传入三组向量，limit 为 3，则 limit 限制的是每组向量返回 top 3 的相似度向量

 System.out.println(&#34;---------------------- searchById ----------------------&#34;);
 SearchByIdParam searchByIdParam = SearchByIdParam.newBuilder()
         .withDocumentIds(documentIds)
         // 若使用 HNSW 索引，则需要指定参数 ef，ef 越大，召回率越高，但也会影响检索速度
         .withParams(new HNSWSearchParams(100))
         // 指定 Top K 的 K 值
         .withLimit(2)
         // 过滤获取到结果
         .withFilter(filterParam)
         .build();
 List&lt;List&lt;Document&gt;&gt; siDocs = collection.searchById(searchByIdParam);
 int i = 0;
 for (List&lt;Document&gt; docs : siDocs) {
     System.out.println(&#34;\tres: &#34; + i++);
     for (Document doc : docs) {
         System.out.println(&#34;\tres: &#34; + doc.toString());
     }
 }

 // search
 // 1. search 提供按照 vector 搜索的能力
 // 其他选项类似 search 接口

 System.out.println(&#34;---------------------- search ----------------------&#34;);
 SearchByVectorParam searchByVectorParam = SearchByVectorParam.newBuilder()
         .addVector(Arrays.asList(0.2123, 0.23, 0.213))
         // 若使用 HNSW 索引，则需要指定参数ef，ef越大，召回率越高，但也会影响检索速度
         .withParams(new HNSWSearchParams(100))
         // 指定 Top K 的 K 值
         .withLimit(2)
         // 过滤获取到结果
         .withFilter(filterParam)
         .build();
 // 输出相似性检索结果，检索结果为二维数组，每一位为一组返回结果，分别对应 search 时指定的多个向量
 List&lt;List&lt;Document&gt;&gt; svDocs = collection.search(searchByVectorParam);
 i = 0;
 for (List&lt;Document&gt; docs : svDocs) {
     System.out.println(&#34;\tres: &#34; + i);
     i++;
     for (Document doc : docs) {
         System.out.println(&#34;\tres: &#34; + doc.toString());
     }
 }

}
private static void updateAndDelete(VectorDBClient client) throws InterruptedException {

Database database = client.database(DBNAME);

Collection collection = database.describeCollection(COLL_NAME);
 System.out.println(&#34;---------------------- update ----------------------&#34;);
 // update
 // 1. update 提供基于 [主键查询] 和 [Filter 过滤] 的部分字段更新或者非索引字段新增

 // filter 限制仅会更新 id = &#34;0003&#34;
 Filter filterParam = new Filter(&#34;bookName=\&#34;三国演义\&#34;&#34;);
 List&lt;String&gt; documentIds = Arrays.asList(&#34;0001&#34;, &#34;0003&#34;);
 UpdateParam updateParam = UpdateParam
         .newBuilder()
         .addAllDocumentId(documentIds)
         .withFilter(filterParam)
         .build();
 Document updateDoc = Document
         .newBuilder()
         .addDocField(new DocField(&#34;page&#34;, 100))
         // 支持添加新的内容
         .addDocField(new DocField(&#34;extend&#34;, &#34;extendContent&#34;))
         .build();
 collection.update(updateParam, updateDoc);


 System.out.println(&#34;---------------------- delete ----------------------&#34;);
 // delete
 // 1. delete 提供基于[ 主键查询]和[Filter 过滤]的数据删除能力
 // 2. 删除功能会受限于 collection 的索引类型，部分索引类型不支持删除操作

 // filter 限制只会删除 id = &#34;00001&#34; 成功
 filterParam = new Filter(&#34;bookName=\&#34;西游记\&#34;&#34;);
 DeleteParam build = DeleteParam
         .newBuilder()
         .addAllDocumentId(documentIds)
         .withFilter(filterParam)
         .build();
 collection.delete(build);

 // rebuild index
 System.out.println(&#34;---------------------- rebuildIndex ----------------------&#34;);

 RebuildIndexParam rebuildIndexParam = RebuildIndexParam
         .newBuilder()
         .withDropBeforeRebuild(false)
         .withThrottle(1)
         .build();
 collection.rebuildIndex(rebuildIndexParam);

 Thread.sleep(1000 * 5);

 // query
 System.out.println(&#34;----------------------  query ----------------------&#34;);
 documentIds = Arrays.asList(&#34;0001&#34;, &#34;0002&#34;, &#34;0003&#34;, &#34;0004&#34;, &#34;0005&#34;);
 List&lt;String&gt; outputFields = Arrays.asList(&#34;id&#34;, &#34;bookName&#34;, &#34;page&#34;, &#34;extend&#34;);
 QueryParam queryParam = QueryParam.newBuilder()
         .withDocumentIds(documentIds)
         // 使用 filter 过滤数据
         .withOutputFields(outputFields)
         // 是否返回 vector 数据
         .withRetrieveVector(false)
         .build();
 List&lt;Document&gt; qdos = collection.query(queryParam);
 for (Document doc : qdos) {
     System.out.println(&#34;\tres: &#34; + doc.toString());
 }

 // truncate 会清除整个 Collection 的数据，包括索引
 System.out.println(&#34;---------------------- truncate collection ----------------------&#34;);
 AffectRes affectRes = database.truncateCollections(COLL_NAME);
 System.out.println(&#34;\tres: &#34; + affectRes.toString());

 // notice：delete操作可用会有延迟
 Thread.sleep(1000 * 5);

}
private static void deleteAndDrop(VectorDBClient client) {

Database database = client.database(DBNAME);
 // 删除 collection
 System.out.println(&#34;---------------------- truncate collection ----------------------&#34;);
 database.dropCollection(COLL_NAME);

 // 删除 database
 System.out.println(&#34;---------------------- truncate collection ----------------------&#34;);
 client.dropDatabase(DBNAME);

}
private static void clear(VectorDBClient client) {

List<String> databases = client.listDatabase();

for (String database : databases) {

client.dropDatabase(database);

}

}
/**

初始化创建 Collection 参数
通过调用 addField 方法设计索引（不是设计 Collection 的结构）
<ol>

&lt;li&gt;【重要的事】向量对应的文本字段不要建立索引，会浪费较大的内存，并且没有任何作用。&lt;/li&gt;



&lt;li&gt;【必须的索引】：主键id、向量字段 vector 这两个字段目前是固定且必须的，参考下面的例子；&lt;/li&gt;



&lt;li&gt;【其他索引】：检索时需作为条件查询的字段，比如要按书籍的作者进行过滤，这个时候author字段就需要建立索引，



否则无法在查询的时候对 author 字段进行过滤，不需要过滤的字段无需加索引，会浪费内存；&lt;/li&gt;



&lt;li&gt;向量数据库支持动态 Schema，写入数据时可以写入任何字段，无需提前定义，类似MongoDB.&lt;/li&gt;



&lt;li&gt;&lt;例子中创建一个书籍片段的索引，例如书籍片段的信息包括 {id, vector, segment, bookName, author, page},



id 为主键需要全局唯一，segment 为文本片段, vector 字段需要建立向量索引，假如我们在查询的时候要查询指定书籍


@param collName
@return

*/

private static CreateCollectionParam initCreateCollectionParam(String collName) {

return CreateCollectionParam.newBuilder()

.withName(collName)

.withShardNum(2)

.withReplicaNum(0)

.withDescription("test collection0")

.addField(new FilterIndex("id", FieldType.String, IndexType.PRIMARY_KEY))

.addField(new VectorIndex("vector", 3, IndexType.HNSW,

MetricType.COSINE, new HNSWParams(16, 200)))

.addField(new FilterIndex("bookName", FieldType.String, IndexType.FILTER))

.addField(new FilterIndex("author", FieldType.String, IndexType.FILTER))

.build();

}

/**

测试 Filter

*/

public static void testFilter() {

System.out.println("---------------------- testFilter ----------------------");

System.out.println("\tres: " + new Filter("author=&#34;jerry&#34;")

.and("a=1")

.or("r=&#34;or&#34;")

.orNot("rn=2")

.andNot("an=&#34;andNot&#34;")

.getCond());

System.out.println("\tres: " + Filter.in("key", Arrays.asList("v1", "v2", "v3")));

System.out.println("\tres: " + Filter.in("key", Arrays.asList(1, 2, 3)));

}

}

执行日志！



15:30:56.058 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - header: Bearer account=root&api_key=xxx

---------------------- clear before test ----------------------

15:30:56.539 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/list, code=200, msg=OK, result={"code":0,"msg":"operation success","databases":["book"],"info":{"book":{"createTime":"2023-11-23 15:29:46","dbType":"BASE"}}}

15:30:56.594 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/drop, body={"database":"book"}

15:30:56.656 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/drop, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- createDatabase ----------------------

15:30:56.657 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/create, body={"database":"book"}

15:30:56.717 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/create, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- listCollections ----------------------

15:30:56.776 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/list, code=200, msg=OK, result={"code":0,"msg":"operation success","databases":["book"],"info":{"book":{"createTime":"2023-11-23 15:30:56","dbType":"BASE"}}}

res: book

---------------------- createCollection ----------------------

15:30:56.890 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/create, body={"database":"book","collection":"book_segments","replicaNum":0,"shardNum":2,"description":"test collection0","indexes":[{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","metricType":"COSINE","params":{"efConstruction":200,"M":16},"dimension":3},{"fieldName":"bookName","fieldType":"string","indexType":"filter"},{"fieldName":"author","fieldType":"string","indexType":"filter"}],"documentCount":0}

15:31:00.478 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/create, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- listCollections ----------------------

15:31:00.478 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/list, body={"database":"book"}

15:31:00.537 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/list, code=200, msg=OK, result={"code":0,"msg":"operation success","collections":[{"database":"book","collection":"book_segments","documentCount":0,"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":0,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}},{"fieldName":"bookName","fieldType":"string","indexType":"filter"}],"indexStatus":{"status":"ready","startTime":""}}]}

res: {"database":"book","collection":"book_segments","replicaNum":0,"shardNum":2,"description":"test collection0","indexes":[{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","metricType":"COSINE","params":{"efConstruction":200,"M":16},"dimension":3,"indexedCount":0},{"fieldName":"bookName","fieldType":"string","indexType":"filter"}],"createTime":"2023-11-23 15:30:56","documentCount":0,"indexStatus":{"status":"ready"}}

---------------------- setAlias ----------------------

15:31:00.625 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/alias/set, body={"database":"book","collection":"book_segments","alias":"collection_alias"}

15:31:00.684 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/alias/set, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

res: AffectRes{affectedCount=1, code=0, msg='operation success'}

---------------------- describeCollection ----------------------

15:31:00.687 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, body={"database":"book","collection":"book_segments"}

15:31:00.746 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, code=200, msg=OK, result={"code":0,"msg":"operation success","collection":{"database":"book","collection":"book_segments","documentCount":0,"alias":["collection_alias"],"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":0,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}},{"fieldName":"bookName","fieldType":"string","indexType":"filter"}],"indexStatus":{"status":"ready","startTime":""}}}

res: {"database":"book","collection":"book_segments","replicaNum":0,"shardNum":2,"description":"test collection0","indexes":[{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","metricType":"COSINE","params":{"efConstruction":200,"M":16},"dimension":3,"indexedCount":0},{"fieldName":"bookName","fieldType":"string","indexType":"filter"}],"createTime":"2023-11-23 15:30:56","documentCount":0,"indexStatus":{"status":"ready"},"alias":["collection_alias"]}

---------------------- deleteAlias ----------------------

15:31:00.759 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/alias/delete, body={"database":"book","alias":"collection_alias"}

15:31:00.820 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/alias/delete, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

res: AffectRes{affectedCount=1, code=0, msg='operation success'}

---------------------- describeCollection ----------------------

15:31:00.822 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, body={"database":"book","collection":"book_segments"}

15:31:00.881 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, code=200, msg=OK, result={"code":0,"msg":"operation success","collection":{"database":"book","collection":"book_segments","documentCount":0,"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":0,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}},{"fieldName":"bookName","fieldType":"string","indexType":"filter"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"}],"indexStatus":{"status":"ready","startTime":""}}}

res: {"database":"book","collection":"book_segments","replicaNum":0,"shardNum":2,"description":"test collection0","indexes":[{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","metricType":"COSINE","params":{"efConstruction":200,"M":16},"dimension":3,"indexedCount":0},{"fieldName":"bookName","fieldType":"string","indexType":"filter"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"}],"createTime":"2023-11-23 15:30:56","documentCount":0,"indexStatus":{"status":"ready"}}

15:31:00.894 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, body={"database":"book","collection":"book_segments"}

15:31:00.956 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, code=200, msg=OK, result={"code":0,"msg":"operation success","collection":{"database":"book","collection":"book_segments","documentCount":0,"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"bookName","fieldType":"string","indexType":"filter"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":0,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}}],"indexStatus":{"status":"ready","startTime":""}}}

---------------------- upsert ----------------------

15:31:00.977 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/upsert, body={"database":"book","collection":"book_segments","buildIndex":true,"documents":[{"id":"0001","vector":[0.2123,0.21,0.213],"bookName":"西游记","author":"吴承恩","page":21,"segment":"富贵功名，前缘分定，为人切莫欺心。"},{"id":"0002","vector":[0.2123,0.22,0.213],"bookName":"西游记","author":"吴承恩","page":22,"segment":"正大光明，忠良善果弥深。些些狂妄天加谴，眼前不遇待时临。"},{"id":"0003","vector":[0.2123,0.23,0.213],"bookName":"三国演义","author":"罗贯中","page":23,"segment":"细作探知这个消息，飞报吕布。"},{"id":"0004","vector":[0.2123,0.24,0.213],"bookName":"三国演义","author":"罗贯中","page":24,"segment":"富贵功名，前缘分定，为人切莫欺心。"},{"id":"0005","vector":[0.2123,0.25,0.213],"bookName":"三国演义","author":"罗贯中","page":25,"segment":"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。"}]}

15:31:01.049 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/upsert, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":5}

15:31:06.051 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, body={"database":"book","collection":"book_segments"}

15:31:06.111 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, code=200, msg=OK, result={"code":0,"msg":"operation success","collection":{"database":"book","collection":"book_segments","documentCount":5,"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"bookName","fieldType":"string","indexType":"filter"},{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":5,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"author","fieldType":"string","indexType":"filter"}],"indexStatus":{"status":"ready","startTime":""}}}

---------------------- query ----------------------

15:31:06.130 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/query, body={"database":"book","collection":"book_segments","readConsistency":"eventualConsistency","query":{"filter":"bookName="三国演义"","documentIds":["0001","0002","0003","0004","0005"],"retrieveVector":false,"limit":2,"offset":1,"outputFields":["id","bookName"]}}

15:31:06.189 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/query, code=200, msg=OK, result={"code":0,"msg":"operation success","count":2,"documents":[{"id":"0003","bookName":"三国演义"},{"id":"0004","bookName":"三国演义"}]}

res: {"id":"0003","bookName":"三国演义"}

res: {"id":"0004","bookName":"三国演义"}

---------------------- searchById ----------------------

15:31:06.202 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/search, body={"database":"book","collection":"book_segments","search":{"params":{"ef":100},"filter":"bookName="三国演义"","retrieveVector":false,"limit":2,"documentIds":["0001","0002","0003","0004","0005"]},"readConsistency":"eventualConsistency"}

15:31:06.264 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/search, code=200, msg=OK, result={"code":0,"msg":"operation success","documents":[[{"id":"0003","score":0.999062,"bookName":"三国演义","author":"罗贯中","segment":"细作探知这个消息，飞报吕布。","page":23},{"id":"0004","score":0.997955,"bookName":"三国演义","page":24,"author":"罗贯中","segment":"富贵功名，前缘分定，为人切莫欺心。"}],[{"id":"0003","score":0.999773,"author":"罗贯中","segment":"细作探知这个消息，飞报吕布。","page":23,"bookName":"三国演义"},{"id":"0004","score":0.99912,"author":"罗贯中","bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","page":24}],[{"id":"0003","score":1.0,"bookName":"三国演义","segment":"细作探知这个消息，飞报吕布。","author":"罗贯中","page":23},{"id":"0004","score":0.999787,"page":24,"bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","author":"罗贯中"}],[{"id":"0004","score":1.0,"segment":"富贵功名，前缘分定，为人切莫欺心。","author":"罗贯中","page":24,"bookName":"三国演义"},{"id":"0005","score":0.9998,"bookName":"三国演义","page":25,"segment":"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。","author":"罗贯中"}],[{"id":"0005","score":1.0,"author":"罗贯中","bookName":"三国演义","segment":"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。","page":25},{"id":"0004","score":0.9998,"segment":"富贵功名，前缘分定，为人切莫欺心。","bookName":"三国演义","page":24,"author":"罗贯中"}]]}

res: 0

res: {"id":"0003","score":0.999062,"bookName":"三国演义","author":"罗贯中","segment":"细作探知这个消息，飞报吕布。","page":23}

res: {"id":"0004","score":0.997955,"bookName":"三国演义","page":24,"author":"罗贯中","segment":"富贵功名，前缘分定，为人切莫欺心。"}

res: 1

res: {"id":"0003","score":0.999773,"author":"罗贯中","segment":"细作探知这个消息，飞报吕布。","page":23,"bookName":"三国演义"}

res: {"id":"0004","score":0.99912,"author":"罗贯中","bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","page":24}

res: 2

res: {"id":"0003","score":1.0,"bookName":"三国演义","segment":"细作探知这个消息，飞报吕布。","author":"罗贯中","page":23}

res: {"id":"0004","score":0.999787,"page":24,"bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","author":"罗贯中"}

res: 3

res: {"id":"0004","score":1.0,"segment":"富贵功名，前缘分定，为人切莫欺心。","author":"罗贯中","page":24,"bookName":"三国演义"}

res: {"id":"0005","score":0.9998,"bookName":"三国演义","page":25,"segment":"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。","author":"罗贯中"}

res: 4

res: {"id":"0005","score":1.0,"author":"罗贯中","bookName":"三国演义","segment":"布大惊，与陈宫商议。宫曰：“闻刘玄德新领徐州，可往投之。","page":25}

res: {"id":"0004","score":0.9998,"segment":"富贵功名，前缘分定，为人切莫欺心。","bookName":"三国演义","page":24,"author":"罗贯中"}

---------------------- search ----------------------

15:31:06.277 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/search, body={"database":"book","collection":"book_segments","search":{"params":{"ef":100},"filter":"bookName="三国演义"","retrieveVector":false,"limit":2,"vectors":[[0.2123,0.23,0.213]]},"readConsistency":"eventualConsistency"}

15:31:06.336 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/search, code=200, msg=OK, result={"code":0,"msg":"operation success","documents":[[{"id":"0003","score":1.0,"author":"罗贯中","page":23,"bookName":"三国演义","segment":"细作探知这个消息，飞报吕布。"},{"id":"0004","score":0.999787,"author":"罗贯中","bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","page":24}]]}

res: 0

res: {"id":"0003","score":1.0,"author":"罗贯中","page":23,"bookName":"三国演义","segment":"细作探知这个消息，飞报吕布。"}

res: {"id":"0004","score":0.999787,"author":"罗贯中","bookName":"三国演义","segment":"富贵功名，前缘分定，为人切莫欺心。","page":24}

15:31:06.337 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, body={"database":"book","collection":"book_segments"}

15:31:06.396 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/describe, code=200, msg=OK, result={"code":0,"msg":"operation success","collection":{"database":"book","collection":"book_segments","documentCount":5,"replicaNum":0,"shardNum":2,"createTime":"2023-11-23 15:30:56","description":"test collection0","indexes":[{"fieldName":"vector","fieldType":"vector","indexType":"HNSW","indexedCount":5,"dimension":3,"metricType":"COSINE","params":{"M":16,"efConstruction":200}},{"fieldName":"id","fieldType":"string","indexType":"primaryKey"},{"fieldName":"author","fieldType":"string","indexType":"filter"},{"fieldName":"bookName","fieldType":"string","indexType":"filter"}],"indexStatus":{"status":"ready","startTime":""}}}

---------------------- update ----------------------

15:31:06.411 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/update, body={"database":"book","collection":"book_segments","query":{"filter":"bookName="三国演义"","documentIds":["0001","0003"]},"update":{"page":100,"extend":"extendContent"}}

15:31:06.471 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/update, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- delete ----------------------

15:31:06.478 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/delete, body={"database":"book","collection":"book_segments","query":{"filter":"bookName="西游记"","documentIds":["0001","0003"]}}

15:31:06.549 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/delete, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- rebuildIndex ----------------------

15:31:06.554 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/index/rebuild, body={"database":"book","collection":"book_segments","dropBeforeRebuild":false,"throttle":1}

15:31:06.627 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/index/rebuild, code=200, msg=OK, result={"code":0,"msg":"operation success"}

----------------------  query ----------------------

15:31:11.637 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/query, body={"database":"book","collection":"book_segments","readConsistency":"eventualConsistency","query":{"documentIds":["0001","0002","0003","0004","0005"],"retrieveVector":false,"limit":10,"offset":0,"outputFields":["id","bookName","page","extend"]}}

15:31:11.695 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/document/query, code=200, msg=OK, result={"code":0,"msg":"operation success","count":4,"documents":[{"id":"0002","bookName":"西游记","page":22},{"id":"0003","extend":"extendContent","bookName":"三国演义","page":100},{"id":"0004","page":24,"bookName":"三国演义"},{"id":"0005","page":25,"bookName":"三国演义"}]}

res: {"id":"0002","bookName":"西游记","page":22}

res: {"id":"0003","extend":"extendContent","bookName":"三国演义","page":100}

res: {"id":"0004","page":24,"bookName":"三国演义"}

res: {"id":"0005","page":25,"bookName":"三国演义"}

---------------------- truncate collection ----------------------

15:31:11.697 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/truncate, body={"database":"book","collection":"book_segments"}

15:31:11.788 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/truncate, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

res: AffectRes{affectedCount=1, code=0, msg='operation success'}

---------------------- truncate collection ----------------------

15:31:16.803 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/drop, body={"database":"book","collection":"book_segments"}

15:31:16.874 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/collection/drop, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- truncate collection ----------------------

15:31:16.874 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/drop, body={"database":"book"}

15:31:16.935 [main] DEBUG com.tencent.tcvectordb.service.HttpStub - Query http://lb-baqexj1q-r8cmvkl9h0wsp52u.clb.ap-guangzhou.tencentclb.com/database/drop, code=200, msg=OK, result={"code":0,"msg":"operation success","affectedCount":1}

---------------------- testFilter ----------------------

res: author="jerry" and a=1 or r="or" or not rn=2 and not an="andNot"

res: key in ("v1","v2","v3")

res: key in (1,2,3)