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

SyntaxException when COPY FROM Counter Table with Null value

    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

            People

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

              Dates

                Created:
                Updated:
                Resolved: