[
https://issues.apache.org/jira/browse/MADLIB-1003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15378524#comment-15378524
]
ASF GitHub Bot commented on MADLIB-1003:
----------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-madlib/pull/55
> Partition expression in path function fails on multiple conditions
> ------------------------------------------------------------------
>
> Key: MADLIB-1003
> URL: https://issues.apache.org/jira/browse/MADLIB-1003
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Utilities
> Reporter: Nandish Jayaram
> Fix For: v1.9.1
>
>
> The path function in utilities is supposed to accept expressions for the
> partition_expr parameter, but there are two aspects of the partition
> expression that are not handled currently:
> 1) If there are more than one condition in the partition expression, path()
> fails to run successfully. For instance, consider the input table present in
> the install check file for path, the following function call results in an
> error:
> {code:sql}
> SELECT madlib.path('"Weblog"',
> '"Path_output"',
> 'user_id, age_group > 1, income_group > 1',
> 'event_timestamp ASC',
> 'I:="Click_event"=0 AND purchase_event=0, Click:="Click_event"=1 AND
> purchase_event=0, Conv:=purchase_event=1',
> 'I(click){1}(CONV){1}',
> 'COUNT(*)',
> TRUE);
> ERROR: spiexceptions.DuplicateColumn: column "?column?" specified more than
> once
> CONTEXT: Traceback (most recent call last):
> PL/Python function "path", line 23, in <module>
> return path.path(**globals())
> PL/Python function "path", line 276, in path
> PL/Python function "path"
> {code}
> 2) We cannot rename a particular condition/column name in the partition
> expression using "AS". For example, we get the following error with the
> function call shown below:
> {code:sql}
> SELECT madlib.path('"Weblog"',
> '"Path_output"',
> 'user_id AS uid,
> 'event_timestamp ASC',
> 'I:="Click_event"=0 AND purchase_event=0, Click:="Click_event"=1 AND
> purchase_event=0, Conv:=purchase_event=1',
> 'I(click){1}(CONV){1}',
> 'COUNT(*)',
> TRUE);
> ERROR: spiexceptions.SyntaxError: syntax error at or near "AS"
> QUERY: �
> CONTEXT: Traceback (most recent call last):
> PL/Python function "path", line 23, in <module>
> return path.path(**globals())
> PL/Python function "path", line 114, in path
> PL/Python function "path"
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
