madlib-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [madlib] fmcquillan99 commented on pull request #519: DL: Add a helper function to load custom top n accuracy functions
Date Mon, 19 Oct 2020 22:57:19 GMT

fmcquillan99 commented on pull request #519:
URL: https://github.com/apache/madlib/pull/519#issuecomment-712486086


   Retesting items from above
   
   (0)
   ```
   SELECT madlib.load_top_k_accuracy_function(
       'test_custom_function_table',
       10
       );
   
   ```
   produces
   ```
   SELECT id, name, description FROM test_custom_function_table1 ORDER BY id;
    id |       name       |       description        
   ----+------------------+--------------------------
     1 | top_10_accuracy  | returns top_10_accuracy
   ```
   OK
   
   
   (2)
   ```
   SELECT madlib.load_top_k_accuracy_function('custom_function_table',                   
                                                                                         
                  3);
   INFO:  Keras Custom Function: Added function 'top_3_accuracy' to 'custom_function_table'
table
   CONTEXT:  PL/Python function "load_top_k_accuracy_function"
    load_top_k_accuracy_function 
   ------------------------------
    
   (1 row)
   
   Time: 1644.004 ms
   ```
   OK
   
   (5)
   commit below for user docs
   
   (6)
   ```
   DROP TABLE IF EXISTS custom_function_table;
   SELECT madlib.load_top_k_accuracy_function('custom_function_table',
                                              3);
   SELECT madlib.load_top_k_accuracy_function('custom_function_table',
                                              10);
   SELECT id, name, description FROM custom_function_table ORDER BY id;
   ```
   produces
   ```
    id |      name       |       description       
   ----+-----------------+-------------------------
     1 | top_3_accuracy  | returns top_3_accuracy
     2 | top_10_accuracy | returns top_10_accuracy
     ```
    OK


----------------------------------------------------------------
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



Mime
View raw message