1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
table_create Paragraphs TABLE_NO_KEY
column_create Paragraphs content COLUMN_SCALAR Text
table_create Words TABLE_PAT_KEY ShortText \
--default_tokenizer TokenDelimit \
--normalizer NormalizerAuto
column_create Words index COLUMN_INDEX Paragraphs content
load --table Paragraphs
[
{"content": "Groonga is a full text search engine"},
{"content": "Mroonga is a MySQL storage engine"},
{"content": "PGroonga is an full text search extension for PostgreSQL"},
{"content": "Rroonga is a Ruby bindings of GroongaL"}
]
select Paragraphs \
--match_columns content \
--query '*Q2"search engine MySQL"' \
--output_columns content,_score
|
