Jiri Horky created CASSANDRA-6310: ------------------------------------- Summary: MarshalException: cannot parse 'column1' as hex bytes when inserting data exported from 2.0.0 to 1.2.9 using json2sstable Key: CASSANDRA-6310 URL: https://issues.apache.org/jira/browse/CASSANDRA-6310 Project: Cassandra Issue Type: Bug Components: Tools Reporter: Jiri Horky Fix For: 1.2.12
Hi, we are getting the exception below when we try to insert data using json2sstable from 1.2.9 which were created using sstable2json from C2.0.0: Exception in thread "main" org.apache.cassandra.db.marshal.MarshalException: cannot parse 'column1' as hex bytes at org.apache.cassandra.db.marshal.BytesType.fromString(BytesType.java:69) at org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:230) at org.apache.cassandra.config.CFMetaData.addColumnDefinitionSchema(CFMetaData.java:1522) at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1454) at org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:306) at org.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:287) at org.apache.cassandra.db.DefsTable.loadFromTable(DefsTable.java:154) at org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:563) at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:527) Caused by: java.lang.NumberFormatException: An hex string representing bytes must have an even length at org.apache.cassandra.utils.Hex.hexToBytes(Hex.java:52) at org.apache.cassandra.db.marshal.BytesType.fromString(BytesType.java:65) This information may be valuable as well: (got from 1.2.9 node): cqlsh> select * from system.schema_columns; keyspace_name | columnfamily_name | column_name | component_index | index_name | index_options | index_type | validator ---------------+-----------------------+-----------------------------+-----------------+------------+---------------+------------+----------------------------------------------------------------------------------------------------------------------------- frs | snx | column1 | null | null | null | null | org.apache.cassandra.db.marshal.BytesType frs | snx | key | null | null | null | null | org.apache.cassandra.db.marshal.BytesType frs | snx | value | null | null | null | null | org.apache.cassandra.db.marshal.BytesType frs | stats | KEY | null | null | null | null | org.apache.cassandra.db.marshal.BytesType frs | stats | column1 | null | null | null | null | org.apache.cassandra.db.marshal.BytesType frs | stats | value | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | meta | column1 | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | meta | key | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | meta | value | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha | KEY | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha | column1 | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha | value | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha_counters | KEY | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha_counters | column1 | null | null | null | null | org.apache.cassandra.db.marshal.BytesType fr | sha_counters | value | null | null | null | null | org.apache.cassandra.db.marshal.CounterColumnType Any hints would be greatly appriciated. Jiri Horky -- This message was sent by Atlassian JIRA (v6.1#6144)