Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <4DF9C596.3020400@toptarif.de>
Date: Thu, 16 Jun 2011 10:57:58 +0200
From: Timo Nentwig <timo.nentwig@toptarif.de>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: sstable2json2sstable bug with json data stored
References: <4DF8D2C2.1020808@toptarif.de> <4DF9B58D.1060108@toptarif.de>
 <BANLkTim_ucG0omTWcu4sP9uVcrS=c58ysw@mail.gmail.com>
 <4DF9BAF3.4010306@toptarif.de>
In-Reply-To: <4DF9BAF3.4010306@toptarif.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 6/16/11 10:12, Timo Nentwig wrote:
> On 6/16/11 10:06, Sasha Dolgy wrote:
>> The JSON you are showing below is an export from cassandra?
>
> Yes. Just posted the solution:
> https://issues.apache.org/jira/browse/CASSANDRA-2780?focusedCommentId=13050274&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13050274
>
> Guess this could simply be done in the quote() method.

Hm, is this the way it's supposed to be?

[default@foo] set transactions[test][data]='{"foo":"bar"}';
Value inserted.
[default@foo] get transactions[test][data];
=> (column=data, value={"foo":"bar"}, timestamp=1308214517443000)
[default@foo] set transactions[test][data]='{\"foo\":"bar"}';
Value inserted.
[default@foo] get transactions[test][data];
=> (column=data, value={"foo":"bar"}, timestamp=1308214532484000)


Otherwise here's a regex that cares about existing backslashes:

     private static String quote(final String val)
     {
         return String.format("\"%s\"", val.replaceAll("(?<!\\\\)\"", "\\\""));
     }

>> { "74657374": [["data", "{"foo":"bar"}", 1308209845388000]] }
>>
>> Does this work?
>>
>> {
>> 74657374: [["data", {foo:"bar"}, 1308209845388000]]
>> }
>>
>> -sd
>>
>> On Thu, Jun 16, 2011 at 9:49 AM, Timo Nentwig<timo.nentwig@toptarif.de> wrote:
>>> On 6/15/11 17:41, Timo Nentwig wrote:
>>>>
>>>> (json can likely be boiled down even more...)
>>>
>>> Any JSON (well, probably anything with quotes...) breaks it:
>>>
>>> {
>>> "74657374": [["data", "{"foo":"bar"}", 1308209845388000]]
>>> }
>>>
>>> [default@foo] set transactions[test][data]='{"foo":"bar"}';
>>>
>>> I feared that storing data in a readable fashion would be a fateful idea.
>>>
>>> https://issues.apache.org/jira/browse/CASSANDRA-2780
>