[
https://issues.apache.org/jira/browse/CASSANDRA-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13815936#comment-13815936
]
Lyuben Todorov commented on CASSANDRA-6310:
-------------------------------------------
The issue was resolved in cassandra 1.2.10. Take a look at
[5852|https://issues.apache.org/jira/browse/CASSANDRA-5852]. Also json2sstable
and sstable2json are debug tools for devs, not data import/export tools. If you
are trying to migrate data take a look at [bulk
loading|http://www.datastax.com/docs/1.1/references/bulkloader].
> 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)
