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
|
table_create Memos TABLE_NO_KEY
column_create Memos content COLUMN_SCALAR Text
load --table Memos
[
{"content": "リンゴ"},
{"content": "りんご"}
]
table_create Normalizations TABLE_PAT_KEY ShortText
column_create Normalizations normalized COLUMN_SCALAR ShortText
load --table Normalizations
[
{"_key": "ご", "normalized": "[ご]"}
]
table_create Terms TABLE_PAT_KEY ShortText \
--default_tokenizer TokenBigram \
--normalizers 'NormalizerNFKC130("unify_kana", true), \
NormalizerTable("normalized", "Normalizations.normalized")'
column_create Terms memos_content COLUMN_INDEX|WITH_POSITION Memos content
select Terms --output_columns _key --limit -1
select Memos --match_columns content --query 'りん['
|
