You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@madlib.apache.org by "Nikhil (JIRA)" <ji...@apache.org> on 2018/03/12 18:11:00 UTC

[jira] [Updated] (MADLIB-1213) Support expressions for minibatch preprocessor

     [ https://issues.apache.org/jira/browse/MADLIB-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nikhil updated MADLIB-1213:
---------------------------
    Summary: Support expressions for minibatch preprocessor  (was: Support logical expression for minibatch preprocessor)

> Support expressions for minibatch preprocessor
> ----------------------------------------------
>
>                 Key: MADLIB-1213
>                 URL: https://issues.apache.org/jira/browse/MADLIB-1213
>             Project: Apache MADlib
>          Issue Type: Improvement
>          Components: Module: Utilities
>            Reporter: Jingyi Mei
>            Priority: Major
>             Fix For: v1.14
>
>
> The minibatch preprocessor currently does not support all logical expressions for independent and dependent variables.
>  # Independent varname does not support any logical expression.
>  # Dependent varname only supports logical expression for numerical columns. For ex 'length >1' is a valid expression but it does not support creating an alias for this expression.
> This is the only expression that is supported
> {code}
> SELECT madlib.minibatch_preprocessor('minibatch_preprocessing_input', 'minibatch_preprocessing_out',  'y > 10',  ' x1,x2', 4);
>  {code}
> Not supported :
> {code}
> SELECT madlib.minibatch_preprocessor('minibatch_preprocessing_input', 'minibatch_preprocessing_out',  'y > 10 as foo',  'x1,x2', 4);
> {code}
> {code}
> SELECT madlib.minibatch_preprocessor('minibatch_preprocessing_input', 'minibatch_preprocessing_out',  'y=''F''',  'x1,x2', 4);
> {code}
> Open Questions :
> 1. How about expressions that evaluate to array ? We might already support this but haven't tested it yet.
> 2. Do we need to support logical expressions for both independent and dependent varname
> 3. If yes, to what extent ? 
> 4. Should the user be allowed to create an alias for logical expressions? 
> 5. There might be other modules that may partially support logical expressions. Should we find out which modules ?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)