[
https://issues.apache.org/jira/browse/CASSANDRA-12476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashraful Islam updated CASSANDRA-12476:
---------------------------------------
Status: Patch Available (was: Open)
> 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: 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)
