[
https://issues.apache.org/jira/browse/MADLIB-1276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frank McQuillan updated MADLIB-1276:
------------------------------------
Priority: Minor (was: Major)
> 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
> Priority: Minor
> Fix For: v1.15.1
>
>
> 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)
