1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
Execution example:
```shell
select \
--table Memos \
--columns[similarity].stage filtered \
--columns[similarity].flags COLUMN_SCALAR \
--columns[similarity].types Float32 \
--columns[similarity].value 'distance_inner_product(content_embedding, language_model_vectorize("mistral-7b-v0.1.Q4_K_M", "high performance FTS"))' \
--output_columns content,similarity \
--sort_keys -similarity
# [
# [
# 0,
# 1337566253.89858,
# 0.000355720520019531
# ],
# [
# [
# [
# 3
# ],
# [
# [
# "content",
# "ShortText"
# ],
# [
# "similarity",
# "Text"
# ]
# ],
# [
# "Groonga is fast and embeddable full text search engine.",
# "0.6581704020500183"
# ],
# [
# "PGroonga is a PostgreSQL extension that uses Groonga.",
# "0.6540993452072144"
# ],
# [
# "PostgreSQL is a RDBMS.",
# "0.6449499130249023"
# ]
# ]
# ]
# ]
```
|
