稀疏矩阵的SVD函数
表示为稀疏格式的矩阵使用此函数。为了高效计算,在奇异值分解操作之前,输入矩阵会被转换为稠密矩阵。...r1, t2.row_id r2, abs(madlib.cosine_similarity(v1, v2)) s
from (select row_id, row_vec v1 from svd_u...where row_id = $1) t1,
(select row_id, row_vec v2 from svd_u) t2
where t1.row_id t2.row_id..., row_vec v1 from matrix_r_10 where row_id = 1) t1,
(select row_id, row_vec v2 from svd_u)...(8)将结果向量插入svd_u矩阵
insert into svd_u
select user_idx, row_vec from matrix_r_10, tbl_idx_user
where