先建表再建索引，会报表不存在错误
[root@2881][db1]> CREATE TABLE items ( id INT PRIMARY KEY, doc VARCHAR(100));
Query OK, 0 rows affected (0.098 sec)
[root@2881][db1]> INSERT INTO items(id, doc) VALUES(1, ‘Rose’);
Query OK, 1 row affected (0.005 sec)
[root@2881][db1]> INSERT INTO items(id, doc) VALUES(2, ‘Sunflower’);
Query OK, 1 row affected (0.004 sec)
[root@2881][db1]> INSERT INTO items(id, doc) VALUES(3, ‘Lily’);
Query OK, 1 row affected (0.002 sec)
[root@2881][db1]> CREATE VECTOR INDEX vector_idx
→ ON items (doc)
→ WITH (distance=l2, lib=vsag, type=hnsw, model=ob_embed, dim=1024, sync_mode=immediate);
ERROR 1146 (42S02): Table doesn’t exist
建表的时候同时建索引
[root@2881][db1]> CREATE TABLE items ( id INT PRIMARY KEY, doc VARCHAR(100), VECTOR INDEX vector_idx(doc) WITH (distance=l2, lib=vsag, type=hnsw, model=ob_embed, dim=1024, sync_mode=immediate) );
Query OK, 0 rows affected (0.379 sec)
[root@2881][db1]> INSERT INTO items(id, doc) VALUES(1, ‘Rose’);
ERROR 1 (HY000): Unknown error