[ 
https://issues.apache.org/jira/browse/CASSANDRA-18920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773920#comment-17773920
 ] 

Stefan Miklosovic commented on CASSANDRA-18920:
-----------------------------------------------

I did 

{code}
./tools/bin/sstabledump 
/home/fermat/dev/cassandra/cassandra-instaclustr/cassandra/data/data/ks2/tb2-0f6f1170560011eea640211a707bb47d/snapshots/dropped-1695372637610-tb2/nc-1-big-Data.db
 -l
{code}

I got:

{code}
{"table 
kind":"REGULAR","partition":{"key":["1"],"position":0},"rows":[{"type":"row","position":18,"liveness_info":{"tstamp":"2023-09-18T08:48:09.523758Z"},"cells":[]}]}
{"table 
kind":"REGULAR","partition":{"key":["2"],"position":23},"rows":[{"type":"row","position":41,"liveness_info":{"tstamp":"2023-09-18T08:48:11.044306Z"},"cells":[]}]}
{"table 
kind":"REGULAR","partition":{"key":["3"],"position":48},"rows":[{"type":"row","position":66,"liveness_info":{"tstamp":"2023-09-18T08:48:12.044742Z"},"cells":[]}]}
{code}

I pasted it to https://jsonlines.org/validator/ and it says it is a valid jsonl.

Could you show me the output where it is invalid?

> Add jsonl support to sstabledump
> --------------------------------
>
>                 Key: CASSANDRA-18920
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-18920
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Legacy/Tools
>            Reporter: Geoff Lay
>            Assignee: Geoff Lay
>            Priority: Low
>             Fix For: 5.x
>
>
> Add a new option to sstabledump to allow the generation of jsonl format.
> The -l option for sstabledump does not produce valid jsonl.
> [https://jsonlines.org/validator/]
> Valid jsonl removes whitespace, including newlines, to make the format 
> compact.  
> By adding an option to generate valid jsonl, jsonl can be generated that is 
> smaller.
> Smaller output is better for execution time, storage, and transport. 
> jsonl also allows the splitting of a file for processing at a known good line 
> for processing without parsing the file, as each row is a line.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to