You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@madlib.apache.org by GitBox <gi...@apache.org> on 2019/08/29 17:26:15 UTC

[GitHub] [madlib] fmcquillan99 edited a comment on issue #425: DL: Add training for multiple models

fmcquillan99 edited a comment on issue #425: DL: Add training for multiple models
URL: https://github.com/apache/madlib/pull/425#issuecomment-525978365
 
 
   just tried to run this:
   ```
   SELECT madlib.madlib_keras_fit_multiple_model(
   											'iris_train_packed',    -- source_table
   											'iris_multi_model',     -- model_output_table
       										'model_arch_library99', -- model_arch_table
       										 'mst_table99',         -- model_selection_table
       										 1,  					-- num_iterations
       										 0						-- gpus_per_host
       										);
   ```
   and got:
   ```
   madlib=# SELECT madlib.madlib_keras_fit_multiple_model(
   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      
   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         DELETE FROM  
   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(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(# 'iris_train_packed',    -- source_table
   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(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(# 
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(# 'iris_multi_model',     -- model_output_table
   madlib(#     
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#     'model_arch_library99', -- model_arch_table
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   madlib(#      'mst_table99',         -- model_selection_table
   madlib(#     
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#
   ABORT        ALTER        ANALYZE      BEGIN        CHECKPOINT   CLOSE        CLUSTER      COMMENT      COMMIT       COPY         CREATE       DEALLOCATE   DECLARE      
   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         DELETE FROM  
   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(#      1,   
     
   madlib(#      1,   
     
   madlib(#      1,   
     
   madlib(#      1,   
     
   madlib(#      1,   -- num_iterations
   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(#
   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     VACUUM       VALUES       WITH         UPDATE       
   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(#
   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     VACUUM       VALUES       WITH         UPDATE       
   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(#
   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     VACUUM       VALUES       WITH         UPDATE       
   madlib(#      0 
     
   madlib(#      0 
     
   madlib(#      0 
     
   madlib(#      0 
     
   madlib(#      0 
     
   madlib(#      0 -- gpus_per_host
   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     VACUUM       VALUES       WITH         UPDATE       
   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(#
   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     VACUUM       VALUES       WITH         UPDATE       
   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(#
   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     VACUUM       VALUES       WITH         UPDATE       
   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:  plpy.SPIError: column "dist_key" does not exist
   LINE 2:                          SELECT DISTINCT(dist_key) FROM iris...
                                                    ^
   QUERY:  
                            SELECT DISTINCT(dist_key) FROM iris_train_packed
                            ORDER BY dist_key
                            
   CONTEXT:  Traceback (most recent call last):
     PL/Python function "madlib_keras_fit_multiple_model", line 21, in <module>
       fit_obj = madlib_keras_fit_multiple_model.FitMultipleModel(**globals())
     PL/Python function "madlib_keras_fit_multiple_model", line 42, in wrapper
     PL/Python function "madlib_keras_fit_multiple_model", line 97, in __init__
     PL/Python function "madlib_keras_fit_multiple_model", line 193, in query_dist_keys
   PL/Python function "madlib_keras_fit_multiple_model"
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services