cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA select data from table with json field

unic
Discoverer
0 Kudos

hi all.

i have a table with several fields and one of them is a json field (i mean it contains json structure). json field contains data related to other fields in the row. question is how can i select data from usual fields like id, name and etc and json field (with parsed values). i tried json_table and i was able to get values but it returnes data for all the rows in a table. and i need this to be returned like id, name, json_field1, json_field2 and so on.

thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

Did you check function JSON_VALUE. That should fit to your requirement.