[
https://issues.apache.org/jira/browse/MADLIB-1241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16541963#comment-16541963
]
ASF GitHub Bot commented on MADLIB-1241:
----------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/madlib/pull/282
> 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)
