[jira] [Closed] (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 closed MADLIB-1241.
-----------------------------------

> 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
>            Assignee: Rahul Iyer
>            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)