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/ab7cbe16-6994-42b9-b06f-7af4af90b044%40googlegroups.com.
