You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Shotaro Kamio (JIRA)" <ji...@apache.org> on 2011/02/18 03:45:12 UTC
[jira] Created: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
json2sstable fails to create sstable from json file
---------------------------------------------------
Key: CASSANDRA-2188
URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
Project: Cassandra
Issue Type: Bug
Components: Tools
Affects Versions: 0.7.2
Environment: linux
Reporter: Shotaro Kamio
I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
at [Source: dump.json; line: 2, column: 739439661]
at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
at [Source: dump.json; line: 2, column: 739439661]
When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
["756e697473",
"32",
1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
"deletedAt": -9223372036854775808,
"subColumns": [["5f64656c",
"",
1297926692097000,
false],
You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich updated CASSANDRA-2188:
---------------------------------------
Attachment: CASSANDRA-2188.patch
Fixed problem in SSTable2JSON which was causing this error - no delimiter was set after each of the row paged part.
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
> Fix For: 0.7.3, 0.8
>
> Attachments: CASSANDRA-2188.patch
>
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-2188:
--------------------------------------
Reviewer: urandom
Affects Version/s: (was: 0.7.2)
0.7.3
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12996316#comment-12996316 ]
Pavel Yaskevich commented on CASSANDRA-2188:
--------------------------------------------
This is a problem when sstable2json then, can you please tell me the version of the cassandra from which you were running sstable2json? can you regenerate json file using the lastest version of the cassandra and check if it is corrent using for example http://www.jsonlint.com/? Because I can't reproduce a problem which broken JSON for super column families on my side and need a bit more details on this...
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12997639#comment-12997639 ]
Jonathan Ellis commented on CASSANDRA-2188:
-------------------------------------------
I'm not sure what CASSANDRA-2212 has to do with json. Do you mean we should close this ticket?
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12997969#comment-12997969 ]
Hudson commented on CASSANDRA-2188:
-----------------------------------
Integrated in Cassandra-0.7 #304 (See [https://hudson.apache.org/hudson/job/Cassandra-0.7/304/])
fix sstable2json large-row pagination
patch by Pavel Yaskevich; reviewed by jbellis for CASSANDRA-2188
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
> Fix For: 0.7.3, 0.8
>
> Attachments: CASSANDRA-2188.patch
>
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis reassigned CASSANDRA-2188:
-----------------------------------------
Assignee: Pavel Yaskevich
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2188) sstable2json generates invalid
json for "paged" rows
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-2188:
--------------------------------------
Summary: sstable2json generates invalid json for "paged" rows (was: json2sstable fails to create sstable from json file)
> sstable2json generates invalid json for "paged" rows
> ----------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
> Fix For: 0.7.3, 0.8
>
> Attachments: CASSANDRA-2188.patch
>
> Original Estimate: 2h
> Remaining Estimate: 2h
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Muga Nishizawa (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12997638#comment-12997638 ]
Muga Nishizawa commented on CASSANDRA-2188:
-------------------------------------------
Hi Pavel,
I was able to reproduce the problem above with my sstable file. I explained the detail of how to generate problematic sstable on CASSANDRA-2212. Please check it.
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2188) json2sstable fails to create
sstable from json file
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-2188:
--------------------------------------
Remaining Estimate: 2h
Original Estimate: 2h
> json2sstable fails to create sstable from json file
> ---------------------------------------------------
>
> Key: CASSANDRA-2188
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2188
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 0.7.3
> Environment: linux
> Reporter: Shotaro Kamio
> Assignee: Pavel Yaskevich
> Fix For: 0.7.3, 0.8
>
> Attachments: CASSANDRA-2188.patch
>
> Original Estimate: 2h
> Remaining Estimate: 2h
>
> I have a json file created with sstable2json for a column family of super column type. But json2sstable failed to create sstable from the file. It's because file format is wrong.
> WARN 11:41:55,141 Schema definitions were defined both locally and in cassandra.yaml. Definitions in cassandra.yaml were ignored.
> org.codehaus.jackson.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:929)
> at org.codehaus.jackson.impl.JsonParserBase._reportError(JsonParserBase.java:632)
> at org.codehaus.jackson.impl.JsonParserBase._reportUnexpectedChar(JsonParserBase.java:565)
> at org.codehaus.jackson.impl.Utf8StreamParser.nextToken(Utf8StreamParser.java:128)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.mapObject(UntypedObjectDeserializer.java:93)
> at org.codehaus.jackson.map.deser.UntypedObjectDeserializer.deserialize(UntypedObjectDeserializer.java:65)
> at org.codehaus.jackson.map.deser.MapDeserializer._readAndBind(MapDeserializer.java:197)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:145)
> at org.codehaus.jackson.map.deser.MapDeserializer.deserialize(MapDeserializer.java:23)
> at org.codehaus.jackson.map.ObjectMapper._readValue(ObjectMapper.java:1261)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:517)
> at org.codehaus.jackson.JsonParser.readValueAs(JsonParser.java:897)
> at org.apache.cassandra.tools.SSTableImport.importUnsorted(SSTableImport.java:208)
> at org.apache.cassandra.tools.SSTableImport.importJson(SSTableImport.java:197)
> at org.apache.cassandra.tools.SSTableImport.main(SSTableImport.java:421)
> ERROR: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries
> at [Source: dump.json; line: 2, column: 739439661]
> When I looked at the file, I found that a comma is missing between super columns. The part of data is like this:
> ["756e697473",
> "32",
> 1297926692097000, false]]}"32303036303830373135303030302f313030303030303030302d32303036313030322d303030303030303639382d612f30": {
> "deletedAt": -9223372036854775808,
> "subColumns": [["5f64656c",
> "",
> 1297926692097000,
> false],
> You'll see no comma between } and ".
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira