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