fmcquillan99 edited a comment on issue #433: Kmeans: Add automatic optimal 
cluster estimation
URL: https://github.com/apache/madlib/pull/433#issuecomment-529053283
 
 
   I tried
   ```
   DROP TABLE IF EXISTS k_auto1;
   SELECT * FROM madlib.kmeanspp_auto(
                                                        'km_sample',
                                                        'k_auto1'
                                                        'points', 
                                                        ARRAY[1,2,3],
                                                        
'madlib.squared_dist_norm2',
                                                        'madlib.avg', 
                                                        20, 
                                                        0.001,
                                                                 1.0,
                                                        'elbow'
                                                        );
   ```
   and got
   ```
   madlib=# SELECT * FROM madlib.kmeanspp_auto(
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE       
 CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   
DECLARE      
   DELETE FROM  DISCARD      DO           DROP         END          EXECUTE     
 EXPLAIN      FETCH        GRANT        INSERT       LISTEN       LOAD         
LOCK         
   MOVE         NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE     
 RESET        REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          
SHOW         
   START        TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM      
 VALUES       WITH         
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'km_sample',
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'k_auto1'
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'points', 
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# ARRAY[1,2,3],
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'madlib.squared_dist_norm2',
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'madlib.avg', 
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 20, 
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 0.001,
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 'elbow'
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# 
   ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER     
 COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
DELETE FROM  
   DISCARD      DO           DROP         END          EXECUTE      EXPLAIN     
 FETCH        GRANT        INSERT       LISTEN       LOAD         LOCK         
MOVE         
   NOTIFY       PREPARE      REASSIGN     REINDEX      RELEASE      RESET       
 REVOKE       ROLLBACK     SAVEPOINT    SELECT       SET          SHOW         
START        
   TABLE        TRUNCATE     UNLISTEN     UPDATE       VACUUM       VALUES      
 WITH         ABORT        
   madlib(# );
   ERROR:  function madlib.kmeanspp(unknown, unknown, integer[], unknown, 
unknown, integer, numeric, unknown) does not exist
   LINE 1: SELECT * FROM madlib.kmeanspp(
                         ^
   HINT:  No function matches the given name and argument types. You might need 
to add explicit type casts.
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to