You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
createdatabasetest_vector_indexdf9244fa_d244_11ef_a814_00163e21975a;
use test_vector_indexdf9244fa_d244_11ef_a814_00163e21975a;
set enable_profile = true;
ADMIN SET FRONTEND CONFIG ("enable_experimental_vector"="true");
CREATETABLEt_test_vector_table (
id bigint(20) NOT NULL COMMENT "",
vector ARRAY<FLOAT>NOT NULL COMMENT "",
INDEX index_vector (vector) USING VECTOR (
"index_type"="hnsw",
"dim"="4",
"metric_type"="l2_distance",
"is_vector_normed"="false",
"M"="2",
"efconstruction"="2"
)
) ENGINE=OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
"replication_num"="1",
"enable_persistent_index"="false",
"replicated_storage"="false",
"compression"="LZ4"
);
insert into t_test_vector_table values
(1, [1.0, 2.0, 3.0, 4.0]),
(2, [1.1, 2.1, 3.1, 4.1]),
(3, [1.2, 2.2, 3.2, 4.2]),
(4, [10.0, 10.0, 10.0, 10.0]),
(5, [10.1, 10.1, 10.1, 10.1]),
(6, [10.2, 10.2, 10.2, 10.2]),
(7, [5.0, 5.0, 5.0, 5.0]),
(8, [5.1, 5.1, 5.1, 5.1]),
(9, [0.5, 0.5, 0.5, 0.5]),
(10, [0.6, 0.6, 0.6, 0.6])
;
>select id from t_test_vector_table order by approx_l2_distance([10.0, 10.0, 10.0, 10.0], vector) limit5;
+----+
| id |
+----+
| 4 |
| 5 |
| 6 |
| 8 |
| 7 |
+----+5 rows inset>ADMIN SET FRONTEND CONFIG ("enable_experimental_vector"="false")
Query OK, 0 rows affected
>select id from t_test_vector_table order by approx_l2_distance([10.0, 10.0, 10.0, 10.0], vector) limit5;
(1064, "Internal error: [2025-01-14 15:13:50] /root/tenann/tenann/searcher/faiss_hnsw_ann_searcher.cc:304: Error: Error in virtual void faiss::IndexHNSW::search(faiss::Index::idx_t, const float*, faiss::Index::idx_t, float*, faiss::Index::idx_t*, const faiss::SearchParameters*) const at
Expected behavior (Required)
Real behavior (Required)
An unknown error is returned when enable_experimental_vector is set to false before query.
StarRocks version (Required)
You can get the StarRocks version by executing SQL select current_version()
+-------------------+
| current_version() |
+-------------------+
| main-e446727 |
+-------------------+
The text was updated successfully, but these errors were encountered:
Steps to reproduce the behavior (Required)
Expected behavior (Required)
Real behavior (Required)
An unknown error is returned when enable_experimental_vector is set to false before query.
StarRocks version (Required)
select current_version()
+-------------------+
| current_version() |
+-------------------+
| main-e446727 |
+-------------------+
The text was updated successfully, but these errors were encountered: