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
|
table_create Entries TABLE_PAT_KEY ShortText
column_create Entries content COLUMN_SCALAR Text
table_create Terms TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram
column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content
load --table Entries
[
{"_key": "The first post!",
"content": "Welcome! This is my first post!"},
{"_key": "Groonga",
"content": "I started to use groonga. It's very fast!"},
{"_key": "Mroonga",
"content": "I also started to use mroonga. It's also very fast! Really fast!"},
{"_key": "Good-bye Senna",
"content": "I migrated all Senna system!"},
{"_key": "Good-bye Tritonn",
"content": "I also migrated all Tritonn system!"}
]
select Entries \
--output_columns '_key,content,_score' \
--match_columns content --query '-fast' \
--query_flags ALLOW_LEADING_NOT \
--sort_keys _key
|
