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
|
table_create Docs TABLE_NO_KEY
column_create Docs title COLUMN_SCALAR ShortText
column_create Docs body COLUMN_SCALAR Text
load --table Docs --columns 'title,body'
[
["Groonga overview","Full text search engine."],
["Groonga indexes","Groonga uses inverted ind."],
["Conclusion","Groonga is good."]
]
table_create Idx TABLE_PAT_KEY ShortText \
--default_tokenizer TokenBigram \
--normalizer NormalizerAuto
column_create Idx title COLUMN_INDEX|WITH_POSITION Docs title
column_create Idx body COLUMN_INDEX|WITH_POSITION Docs body
select \
--table Docs \
--match_columns 'title||body' \
--query 'Groo*' \
--output_columns '_id,_score' \
--match_escalation_threshold -1
select \
--table Docs \
--match_columns 'body||title' \
--query 'Groo*' \
--output_columns '_id,_score' \
--match_escalation_threshold -1
|
