[jira] [Comment Edited] (MADLIB-1001) Sessionization - Phase 2 (output controls)

["Frank McQuillan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/MADLIB-1001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15386455#comment-15386455 ] 

Frank McQuillan edited comment on MADLIB-1001 at 7/20/16 7:03 PM:
------------------------------------------------------------------

Only one suggested change at this point:

In the same way in path
http://madlib.incubator.apache.org/docs/latest/group__grp__path.html
that we do for partition param:
"This can be NULL or '' to indicate the matching is to be applied to the
whole table."

I think we should do the same for the session function, otherwise you cannot (easily)
sesisonize the whole table.


I have been updating the docs so you don't need to worry about doing that.  I included 
the suggestion above in the docs already assuming it would be done. I attached the updated docs to 
this JIRA for your review.


was (Author: fmcquillan):
Only one suggested change at this point:

In the same way in path
http://madlib.incubator.apache.org/docs/latest/group__grp__path.html
that we do for partition param:
"This can be NULL or '' to indicate the matching is to be applied to the
whole table."

I think we should do the same for the session function, in the case u want
to sesisonize the whole table.


I have been updating the docs so you don't need to worry about doing that.  I included 
the suggestion above in the docs already assuming it would be done. I attached the updated docs to 
this JIRA for your review.

> Sessionization - Phase 2 (output controls)
> ------------------------------------------
>
>                 Key: MADLIB-1001
>                 URL: https://issues.apache.org/jira/browse/MADLIB-1001
>             Project: Apache MADlib
>          Issue Type: New Feature
>          Components: Module: Utilities
>            Reporter: Frank McQuillan
>            Assignee: Nandish Jayaram
>            Priority: Minor
>              Labels: gsoc2016, starter
>             Fix For: v1.9.1
>
>
> Story
> As a data scientist, I want to perform session reconstruction on my data set, so that I can prepare for input into other algorithms like path functions, or predictive analytics algorithms.
> This is a follow on to 
> https://issues.apache.org/jira/browse/MADLIB-909
> to add optional output controls.
> Details 
> Proposed interface changes:
> {code}
> sessionize (
>    source_table,
>    output_table,
>    partition_expr,
>    time_stamp,
>    max_time,
>    output_cols -- new
>    create_view   -- new
>    )
> {code}
> where
> output_cols (optional)
>         TEXT.  
>  asterisk (i.e., '*') -- ALL columns in input table + session column (default)
> 'x, y, z, ...' -- list of columns you want + session column.  This list could include the partition expression or other expressions as desired.  This should also support '*, expr1, expr2, etc.' where this means output all columns + the extra expressions listed.  Needs to a valid SELECT expression.
> For example, in the path function http://madlib.incubator.apache.org/docs/latest/group__grp__path.html#examples
> we do a similar thing for the aggregate function parameter.
> create_view (optional)
> 	BOOLEAN default: TRUE. Determines whether to create a view or materialize a table as output. If you only needed session info once, creating a view could be significantly faster than materializing as a table.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)