a week ago
Hello all,
I see that there are other questions here about HANA, pretty old but still decided to ask.
I am trying to query some data and have a NCLOB column with a JSON inside. I can get a specific field using JSON_VALUE function.
Why I cannot use JSON_VALUE in a WHERE clause, doesn't it work exactly the same as a normal filtering, gets some column, check if matches a value, just a little bit more complicated etc. parsing and getting a specific field from a column with JSON inside.
Take a look at the JSON_TABLE function. It will present the result of the function as a table structure which can then be referenced as a table in other queries: JSON_TABLE Function (JSON)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.