创建稀疏向量索引，提示出错。

[AntTech_EU3TJJ]

obclient(root@test)[testdb]> DROP TABLE t1_sprarse_vec;
ERROR 1051 (42S02): Unknown table ‘testdb.t1_sprarse_vec’
obclient(root@test)[testdb]> CREATE TABLE t1_sprarse_vec (
→ c1 INT PRIMARY KEY,
→ c2 SPARSEVECTOR,
→ VECTOR INDEX idx_sparse_vec(c2) WITH (distance=inner_product)
→ );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘SPARSEVECTOR,
VECTOR INDEX idx_sparse_vec(c2) WITH (distance=inner_product)
)’ at line 3
obclient(root@test)[testdb]>

版本是4.3.5，参考的例子是 创建向量索引-V4.3.5-文档-分布式数据库使用文档，请求解答。

[旭辉]

详细版本是什么？

show variables like '%version_comment%';

是否标点有问题，试下这个

CREATE TABLE t1_sprarse_vec (
  c1 INT PRIMARY KEY, 
  c2 SPARSEVECTOR
);

[辞霜]

SPARSEVECTOR 类型应该在4.3.5.2或以上版本支持

[AntTech_EU3TJJ]

@旭辉

CREATE TABLE t1_sprarse_vec (
  c1 INT PRIMARY KEY, 
  c2 SPARSEVECTOR
);

OceanBase 4.3.5.0

[AntTech_EU3TJJ]

谢谢