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 Normalizations TABLE_PAT_KEY ShortText
column_create Normalizations normalized COLUMN_SCALAR ShortText
load --table Normalizations
[
{"_key": "a", "normalized": "AAA"},
{"_key": "b", "normalized": "BBB"},
{"_key": "c", "normalized": "CCC"},
{"_key": "d", "normalized": "DDD"},
{"_key": "e", "normalized": "EEE"}
]
table_create Entries TABLE_NO_KEY
column_create Entries body COLUMN_SCALAR ShortText
table_create Terms TABLE_PAT_KEY ShortText \
--default_tokenizer 'TokenNgram("report_source_location", true)' \
--normalizer 'NormalizerTable("normalized", "Normalizations.normalized", \
"report_source_offset", true)'
column_create Terms document_index COLUMN_INDEX|WITH_POSITION Entries body
load --table Entries
[
{"body": ".a.b.c.d.e."}
]
select Entries \
--match_columns body \
--query 'CCC' \
--output_columns 'highlight_html(body, Terms)'
|
