Amazon web services – function json_extract_path_text(super, "unknown") does not exist – Redshift
Alright. I have a table that has SUPER type fields. These fields hold values like below: id mycol --------------------------------- 1 [{"Title":"first"},{"Title":"Second"},{"Title":"Third"},{"Title":"fourth"}] 2 [{"Title":"some"},{"Title":"thing"}] 3 [{"Title":"else"}] I want to extract the JSON values and concatenate them with commas in each row.…