Matt, Evgenij, thank you for your suggestions. I've just tried the Jackson library (it can convert some JSON flat arrays to CSV which H2 can consume and convert to table) and it worked fine as a start. However, yes, as a target I was looking for something that could convert not a flat (arbitrary) JSON data to relational view (a set of tables, etc. in H2 in-memory DB)
On Friday, May 29, 2020 at 6:55:07 PM UTC+3, Matt Pavlovich wrote: > > George- > > What is the structure of the JSON data? JSON data can have lots of > different *shapes* to it, so its complicated to make an automatic > JSON-to-database table import tool that works for all use cases. If the > data is *flat*, like CSV, than you may look for an intermediate tool to > convert it to CSV and then import to H2 using the existing CSV import tools. > > A tool you may find useful is the open source AtlasMap-- ( > http://atlasmap.io) which I believe just added CSV support. You can use > it to design and convert JSON to CSV. Disclaimer-- I created AtlasMap, but > am not currently actively contributing and do not receive any financial > benefit at this time. > > If your JSON is not flat and you don't want to use existing tools, you'd > need to write some intermediary tools to convert JSON data that is not flat > to groups of flat data that look more like database tables-- as Evgenij is > mentioning using Jackson, Johnson, or other JSON java library to read in > the JSON data and convert out to a database friendly table structure. > > -Matt Pavlovich > > On Friday, May 29, 2020 at 10:05:02 AM UTC-5, George Ivanov wrote: >> >> Or, may be you see some workaround, such as a third party lib (as you >> mentioned). Which one can be used? >> >> On Friday, May 29, 2020 at 5:56:13 PM UTC+3, George Ivanov wrote: >>> >>> Thank you! >>> Can I place a feature request or something? Can I support this function >>> implementation by a donation? >>> >>> On Friday, May 29, 2020 at 5:47:10 PM UTC+3, Evgenij Ryazanov wrote: >>>> >>>> You need JSON_TABLE for it, but it isn't implemented yet and AFAIK >>>> nobody works on its implementation. >>>> >>> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/21c21187-2838-42bc-a345-80155a3cc9eb%40googlegroups.com.
