You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Robin Schumacher (JIRA)" <ji...@apache.org> on 2015/01/20 18:32:35 UTC

[jira] [Updated] (CASSANDRA-8233) Additional file handling capabilities for COPY FROM

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