Skip to Content
Nov 17, 2020 at 09:55 AM

SAP HANA select data from table with json field


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.