[ 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)