[
https://issues.apache.org/jira/browse/CASSANDRA-12476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tyler Hobbs updated CASSANDRA-12476:
------------------------------------
Labels: cqlsh (was: )
Description:
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}
was:
I have a simple counter table
CREATE TABLE test (
a int PRIMARY KEY,
b counter,
c counter
) ;
I have updated b column value with
UPDATE test SET b = b + 1 WHERE a = 1;
Now I have export the data with
COPY test TO 'test.csv';
And Import it with
COPY test FROM 'test.csv';
I get this Error
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
> 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
> Priority: Minor
> Labels: cqlsh
>
> 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)
