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

SyntaxException when COPY FROM Counter Table with Null value

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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 Assign to me
              Reporter:
              ashraful Ashraful Islam
              Authors:
              Stefania Alborghetti
              Reviewers:
              Tom Hobbs

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment