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

SyntaxException when COPY FROM Counter Table with Null value

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Low

    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            stefania Stefania Alborghetti Assign to me
            ashraful Ashraful Islam
            Stefania Alborghetti
            Tom Hobbs
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment