[ https://issues.apache.org/jira/browse/CASSANDRA-8233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robin Schumacher updated CASSANDRA-8233: ---------------------------------------- Description: To compete better with other RDBMS-styled loaders, COPY needs to include some additional file handling capabilities: - the ability to skip file errors, write out 'bad' rows to file, skip blank lines, and set a max error count before a load is terminated. - Allow for columns that have quotes, but strip off the quotes before load. - Set the end of record delimiter. - Be able to ignore file header/other starting line(s). - Have date and time format handling abilities (with date/time delimiters) - Handle carriage returns in data - Skip column in file was: To compete better with other RDBMS-styled loaders, COPY needs to include some additional file handling capabilities: - the ability to skip file errors and blank lines, and set a max error count before a load is terminated. - Allow for columns that have quotes, but strip off the quotes before load. - Set the end of record delimiter. - Be able to ignore file header/other starting line. > Additional file handling capabilities for COPY FROM > --------------------------------------------------- > > Key: CASSANDRA-8233 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8233 > Project: Cassandra > Issue Type: Improvement > Components: Tools > Reporter: Robin Schumacher > Assignee: Tyler Hobbs > Priority: Minor > Fix For: 2.1.3 > > > To compete better with other RDBMS-styled loaders, COPY needs to include some > additional file handling capabilities: > - the ability to skip file errors, write out 'bad' rows to file, skip blank > lines, and set a max error count before a load is terminated. > - Allow for columns that have quotes, but strip off the quotes before load. > - Set the end of record delimiter. > - Be able to ignore file header/other starting line(s). > - Have date and time format handling abilities (with date/time delimiters) > - Handle carriage returns in data > - Skip column in file -- This message was sent by Atlassian JIRA (v6.3.4#6332)