Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-12476

SyntaxException when COPY FROM Counter Table with Null value

    XMLWordPrintableJSON

    Details

    • Severity:
      Low
    • Since Version:

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                stefania Stefania Alborghetti
                Reporter:
                ashraful Ashraful Islam
                Authors:
                Stefania Alborghetti
                Reviewers:
                Tom Hobbs
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: