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/f3ec3ada-a600-46cf-bf50-d39e9d1eb204%40googlegroups.com.
