Hi Evgenij,
I'd like JSON to be converted to the DB table or tables, same way as it is
done to CSVREAD
On Friday, May 29, 2020 at 5:27:16 PM UTC+3, Evgenij Ryazanov wrote:
>
> Hello.
>
> If you simply want to read a JSON from a file, use
> CAST(FILE_READ('/path/to/file.json') AS VARBINARY) FORMAT JSON
> or something like it. You can't convert a BLOB to JSON directly, but you
> can use VARBINARY in the middle.
>
> If you want to inspect structure of JSON, you need to use some third-party
> library instead; H2 has only JSON constructor functions and JSON predicate
> from SQL:2016. JSON query functions, like JSON_TABLE from SQL:2016 are
> unlikely to be implemented in the near future, because they require
> SQL/JSON path language support, this language is not as complicated as SQL,
> but still isn't trivial.
>
--
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/81d155ba-af44-4120-bead-34db8da3d6a1%40googlegroups.com.
