MARKOV_TRAIN
使用 Markov 模型从数据集中提取模式
语法
MARKOV_TRAIN(<string>)
MARKOV_TRAIN(<order>)(<string>)
MARKOV_TRAIN(<order>, <frequency_cutoff>, <num_buckets_cutoff>, <frequency_add>, <frequency_desaturate>) (<string>)
参数
返回类型
根据具体实现,它仅用作 MARKOV_GENERATE 的参数。
示例
create table model as
select markov_train(concat('bar', number::string)) as bar from numbers(100);
select markov_generate(bar,'{"order":5,"sliding_window_size":8}', 151, (number+100000)::string) as generate
from numbers(5), model;
+-----------+
| generate |
+-----------+
│ bar95 │
│ bar64 │
│ bar85 │
│ bar56 │
│ bar95 │
+-----------+