| 1 |
table_create Users TABLE_NO_KEY |
| 2 |
[[0,0.0,0.0],true] |
| 3 |
column_create Users name COLUMN_SCALAR ShortText |
| 4 |
[[0,0.0,0.0],true] |
| 5 |
table_create Terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerAuto |
| 6 |
[[0,0.0,0.0],true] |
| 7 |
column_create Terms index COLUMN_INDEX|WITH_POSITION Users name |
| 8 |
[[0,0.0,0.0],true] |
| 9 |
load --table Users |
| 10 |
[ |
| 11 |
{"name": "Alice"}, |
| 12 |
{"name": "Bob"} |
| 13 |
] |
| 14 |
[[0,0.0,0.0],2] |
| 15 |
select Users --filter 'name @ "Al"' |
| 16 |
[[0,0.0,0.0],[[[1],[["_id","UInt32"],["name","ShortText"]],[1,"Alice"]]]] |