[CASSANDRA-10401] Improve json2sstable error reporting on nonexistent column

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.12, 2.2.4
• Component/s: Legacy/Tools

Environment

Cassandra 2.1.8.621

• Severity: Normal
• Since Version: 2.1.5
• Assignee: Paulo Motta
• Reporter: Jose Martinez Poblete

Authors

Paulo Motta

Reviewers

Ariel Weisberg

• Tester: Jim Witschey
• Created: 26/Sep/15 14:53
• Updated: 16/Apr/19 09:30
• Resolved: 06/Nov/15 19:24

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$

Issue Links

• links to: 2.1 patch