[jira] [Updated] (MADLIB-1241) Drop columns

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

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

Frank McQuillan updated MADLIB-1241:
------------------------------------
    Description: 
Drop Columns

Drops columns of a table.

{code}
dropcols(
    source_table,
    out_table,
    cols_to_drop
    )

source_table
TEXT. Name of the table containing the source data.

out_table
TEXT. Name of the generated table containing the output. If a table with the same name already exists, an error will be returned. 

cols_to_drop
TEXT, default NULL. Comma-separated string of column names from the source table to drop.  Not all columns of the source table can be dropped.


Output

The output table produced by the dropcols function contains the following columns:

<...>
Columns from source table, depending on which ones are kept.
{code}

Notes

(1)
The function
http://pivotalsoftware.github.io/PDLTools/group__ArrayUtilities.html
is similar.  To do the equivalent of the PDL Tools one in MADlib, you would do:

{code}
dropcols(
    table_name,
    output_table,
    drop_columns
    )
{code}

(2)
Please maintain the column order of the source table, minus the dropped column(s) of course.


  was:
Drop Columns

Drops columns of a table.

{code}
dropcols(
    source_table,
    out_table,
    cols_to_drop
    )

source_table
TEXT. Name of the table containing the source data.

out_table
TEXT. Name of the generated table containing the output. If a table with the same name already exists, an error will be returned. 

cols_to_drop
TEXT, default NULL. Comma-separated string of column names from the source table to drop.  Not all columns of the source table can be dropped.


Output

The output table produced by the dropcols function contains the following columns:

<...>
Columns from source table, depending on which ones are kept.


Notes

(1)
The function
http://pivotalsoftware.github.io/PDLTools/group__ArrayUtilities.html
is similar.  To do the equivalent of the PDL Tools one in MADlib, you would do:

{code}
dropcols(
    table_name,
    output_table,
    drop_columns
    )
{code}

(2)
Please maintain the column order of the source table, minus the dropped column(s) of course.



> Drop columns
> ------------
>
>                 Key: MADLIB-1241
>                 URL: https://issues.apache.org/jira/browse/MADLIB-1241
>             Project: Apache MADlib
>          Issue Type: New Feature
>          Components: Module: Utilities
>            Reporter: Frank McQuillan
>            Priority: Major
>             Fix For: v1.15
>
>
> Drop Columns
> Drops columns of a table.
> {code}
> dropcols(
>     source_table,
>     out_table,
>     cols_to_drop
>     )
> source_table
> TEXT. Name of the table containing the source data.
> out_table
> TEXT. Name of the generated table containing the output. If a table with the same name already exists, an error will be returned. 
> cols_to_drop
> TEXT, default NULL. Comma-separated string of column names from the source table to drop.  Not all columns of the source table can be dropped.
> Output
> The output table produced by the dropcols function contains the following columns:
> <...>
> Columns from source table, depending on which ones are kept.
> {code}
> Notes
> (1)
> The function
> http://pivotalsoftware.github.io/PDLTools/group__ArrayUtilities.html
> is similar.  To do the equivalent of the PDL Tools one in MADlib, you would do:
> {code}
> dropcols(
>     table_name,
>     output_table,
>     drop_columns
>     )
> {code}
> (2)
> Please maintain the column order of the source table, minus the dropped column(s) of course.



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