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 2021/03/04 00:38:26 UTC
[GitHub] [madlib] fmcquillan99 edited a comment on pull request #554: DL: Check if the owner of the object table is a superuser
fmcquillan99 edited a comment on pull request #554:
URL: https://github.com/apache/madlib/pull/554#issuecomment-790190171
Also if I prepend with schema to the table in the load utility
```
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:
users@infra.apache.org