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

Improve json2sstable error reporting on nonexistent column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.1.12, 2.2.4
    • Legacy/Tools
    • None
    • Cassandra 2.1.8.621

    • Normal

    Description

      We have the following table...

      CREATE TABLE keyspace_name.table_name (
          col1 text,
          col2 text,
          col3 text,
          col4 text,
          PRIMARY KEY ((col1, col2), col3)
      ) WITH CLUSTERING ORDER BY (col3 ASC)
      

      And the following json in a file created from sstable2json tool

      [
      {"key": "This is col1:This is col2,
       "cells": [["This is col3:","",1443217787319002],
                 ["This is col3:"col4","This is col4",1443217787319002]]}
      ]
      

      Let's say we deleted that record form the DB and wanted to bring it back
      If we try to create an sstable from this data in a json file named test_file.json, we get a NPE

      -bash-4.1$ json2sstable -K elp -c table_name-3264cbe063c211e5bc34e746786b7b29 test_file.json  /var/lib/cassandra/data/keyspace_name/table_name-3264cbe063c211e5bc34e746786b7b29/keyspace_name-table_name-ka-1-Data.db
      Importing 1 keys...
      java.lang.NullPointerException
      	at org.apache.cassandra.tools.SSTableImport.getKeyValidator(SSTableImport.java:442)
      	at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:316)
      	at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:287)
      	at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:514)
      ERROR: null
      -bash-4.1$
      

      Attachments

        Issue Links

          Activity

            People

              pauloricardomg Paulo Motta (Deprecated)
              jpoblete Jose Martinez Poblete
              Paulo Motta (Deprecated)
              Ariel Weisberg
              Jim Witschey Jim Witschey
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: