[ 
https://issues.apache.org/jira/browse/CASSANDRA-12476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stefania updated CASSANDRA-12476:
---------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: 3.0.x)
                       (was: 2.2.x)
                       (was: 3.x)
                   3.10
                   3.0.9
                   2.2.8
           Status: Resolved  (was: Ready to Commit)

> SyntaxException when COPY FROM Counter Table with Null value
> ------------------------------------------------------------
>
>                 Key: CASSANDRA-12476
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12476
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Ashraful Islam
>            Assignee: Stefania
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 2.2.8, 3.0.9, 3.10
>
>         Attachments: 
> Fix_issue___CASSANDRA_12476__SyntaxException_when_COPY_FROM_Counter_Table_with_Null_value.patch
>
>
> I have a simple counter table 
> {noformat}
> CREATE TABLE test (
>     a int PRIMARY KEY,
>     b counter,
>     c counter
> ) ;
> {noformat}
> I have updated b column value with 
> {noformat}
> UPDATE test SET b = b + 1 WHERE a = 1;
> {noformat}
> Now I have export the data with 
> {noformat}
> COPY test TO 'test.csv';
> {noformat}
> And Import it with 
> {noformat}
> COPY test FROM 'test.csv';
> {noformat}
> I get this Error
> {noformat}
> Failed to import 1 rows: SyntaxException - line 1:34 no viable alternative at 
> input 'WHERE' (...=b+1,c=c+ [WHERE]...) -  will retry later, attempt 1 of 5
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to