| SET |
| psql:test.sql:7: INFO: [ 1 ] |
| psql:test.sql:7: INFO: [ 1001 ] |
| psql:test.sql:7: INFO: [ 2001 ] |
| psql:test.sql:7: INFO: [ 3001 ] |
| psql:test.sql:7: INFO: [ 4001 ] |
| psql:test.sql:7: INFO: [ 5001 ] |
| psql:test.sql:7: INFO: [ 6001 ] |
| psql:test.sql:7: INFO: [ 7001 ] |
| psql:test.sql:7: INFO: [ 8001 ] |
| psql:test.sql:7: INFO: [ 9001 ] |
| create_test_table |
| ----------------------------------------------------------------------- |
| Test table populated with 10000 points (madlib_kmeans_test.table123). |
| (1 row) |
| |
| psql:test.sql:10: INFO: ('Parameters:',) |
| psql:test.sql:10: INFO: (' * k = 20 (number of centroids)',) |
| psql:test.sql:10: INFO: (' * input_table = madlib_kmeans_test.table123',) |
| psql:test.sql:10: INFO: (' * goodness = 1 (GOF test on)',) |
| psql:test.sql:10: INFO: (' * run_id = test123',) |
| psql:test.sql:10: INFO: (' * output_schema = madlib_kmeans_test',) |
| psql:test.sql:10: INFO: ('Seeding 20 centroids...',) |
| psql:test.sql:10: INFO: ('Using full data set for analysis (10000 points)',) |
| psql:test.sql:10: INFO: ('Iteration 1...',) |
| psql:test.sql:10: INFO: ('Iteration 2...',) |
| psql:test.sql:10: INFO: ('Exit reason: fraction of reassigned nodes is smaller than the limit: 0.001',) |
| psql:test.sql:10: INFO: ('Writing final output table...',) |
| psql:test.sql:10: INFO: ('Calculating goodness of fit...',) |
| kmeans_run |
| ------------------------------------------------------------------------ |
| |
| Finished k-means clustering on "madlib_kmeans_test"."table123" table. |
| Results: |
| * 20 centroids (goodness of fit = 1.39424212092). |
| Output: |
| * table : "madlib_kmeans_test"."kmeans_out_centroids_test123" |
| * table : "madlib_kmeans_test"."kmeans_out_points_test123" |
| Time elapsed: 0 minutes 3.275068 seconds. |
| |
| (1 row) |
| |