Re: Exporting SQL DB

2020-05-21 Thread akorensh
Your best choice is to write your own exporter/use sqlline/other tool to get the data from Ignite. Ignite's db files are in a proprietary format that can't be used w/other tools. more info here: https://cwiki.apache.org/confluence/display/IGNITE/Ignite+Persistent+Store+-+under+the+hood -- Sent

Re: Exporting SQL DB

2020-05-21 Thread NSquare
Hi Alex, Thanks for your response. I want to export the data into a SQL db file which can be then loaded with any standard SQL viewer. CSV would be difficult for me as the data stored in these tables is huge. Just to give some context, one of the services running on this cluster would pump one

Re: Exporting SQL DB

2020-05-19 Thread akorensh
Hi, You can record data output from sqlline 0: jdbc:ignite:thin://127.0.0.1/> !outputformat csv jdbc:ignite:thin://127.0.0.1/> !record data.csv Saving all output to "data.csv". Enter "record" with no arguments to stop it. 0: jdbc:ignite:thin://127.0.0.1/> select * from Person here