methods/svd-mf/src/pg_gp/sql/test.sql_in

---------------------------------------------------------------
-- SVD sprase unit test: main
---------------------------------------------------------------

-- Pick a test to run: Random or Sequential Sparse; and creat a test table
-- SELECT madlib_svdsparse_test.Generate_Random(10000, 10000, 100);
SELECT madlib_svdsparse_test.Generate_Sparse(10000, 10000, 100);

-- Run SVD decomposition on 3 main features
SELECT MADLIB_SCHEMA.svdmf_run('madlib_svdsparse_test.test'::text, 'col_num'::text, 'row_num'::text, 'val'::text, 3);

-- Display portion of the results
SELECT * FROM MADLIB_SCHEMA.matrix_u ORDER BY col_num, row_num LIMIT 10;