lda.sql

-- fitting
select
  label, word, avg(lambda) as lambda
from (
  select
    train_lda(feature, "-topic 2 -iter 20") 
      as (label, word, lambda)
  from 
    data
) t1
group by label, word;

-- prediction
select
  t.docid,
  lda_predict(
    t.word, t.value, m.label, m.lambda, 
    "-topic 2"
  ) as probabilities
from
  test t
  JOIN lda_model m ON (t.word = m.word)
group by
  t.docid;