cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashraful Islam (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-12476) SyntaxException when COPY FROM Counter Table with Null value
Date Mon, 22 Aug 2016 05:21:20 GMT

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

Ashraful Islam updated CASSANDRA-12476:
---------------------------------------
    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

> 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.x, 3.0.x, 3.x
>
>         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)

Mime
View raw message