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


   Also if I prepend with schema
   ```
   cur.execute("DROP TABLE IF EXISTS madlib.custom_function_table")
   cur.execute("SELECT 
madlib.load_custom_function('madlib.custom_function_table',  
%s,'squared_error', 'squared error')", [p2.Binary(pb_squared_error)])
   cur.execute("SELECT 
madlib.load_custom_function('madlib.custom_function_table',  %s,'rmse', 'root 
mean square error')", [p2.Binary(pb_rmse)])
   conn.commit()
   ```
   I get this error
   ```
   ---------------------------------------------------------------------------
   InternalError_                            Traceback (most recent call last)
   <ipython-input-5-c77ecf220203> in <module>()
        21 # call load function
        22 cur.execute("DROP TABLE IF EXISTS madlib.custom_function_table")
   ---> 23 cur.execute("SELECT 
madlib.load_custom_function('madlib.custom_function_table',  
%s,'squared_error', 'squared error')", [p2.Binary(pb_squared_error)])
        24 cur.execute("SELECT 
madlib.load_custom_function('madlib.custom_function_table',  %s,'rmse', 'root 
mean square error')", [p2.Binary(pb_rmse)])
        25 conn.commit()
   
   InternalError_: plpy.Error: Incorrect table name 
(madlib."madlib.custom_function_table") provided! Table name should be of the 
form: <schema name>.<table name> (plpython.c:5038)
   CONTEXT:  Traceback (most recent call last):
     PL/Python function "load_custom_function", line 21, in <module>
       madlib_keras_custom_function.load_custom_function(**globals())
     PL/Python function "load_custom_function", line 42, in wrapper
     PL/Python function "load_custom_function", line 121, in 
load_custom_function
   PL/Python function "load_custom_function"
   ```
   so I am not sure how to use this utility or what the rules are.


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


Reply via email to