Orhan Kislal created MADLIB-1276:
------------------------------------
Summary: Marginal Regression summary tables are lost after the end
of session.
Key: MADLIB-1276
URL: https://issues.apache.org/jira/browse/MADLIB-1276
Project: Apache MADlib
Issue Type: Bug
Components: Module: Logistic Regression
Reporter: Orhan Kislal
margins_logregr function creates 2 output tables. The model table is created in
the correct schema but the summary table is left in the pg_temp schema, which
means that at the end of the session, the summary table will be lost. Passing
an output name with a schema does not work either and it throws the following
error.
{code:java}
ERROR: spiexceptions.FeatureNotSupported: cannot move objects into or out of
temporary schemas
{code}
This is caused by the way tables are created in margins_logregr. The function
creates the model and the summary in a temp schema. The model table is used to
create the output table. The summary, on the other hand, does not need much
processing and simply gets renamed. However, the generic rename_table function
does not change the schema unless there is a schema in the new name.
Copying the contents, instead of renaming the summary table, seems like an easy
solution. Since this is just a summary table, the contents should be limited in
size and this change should not decrease the performance.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
