1 Answer
- Newest
- Most votes
- Most comments
0
STRUCT is accessed via join and ARRAY is accessed via dot notation.
Kindly refer to this lab which demonstrates with JSON samples https://catalog.us-east-1.prod.workshops.aws/workshops/9f29cdba-66c0-445e-8cbb-28a092cb5ba7/en-US/lab8
Try using something on the lines of below
select
c.svc_genre_id
from
pmc.publish_info pi,
pi.category c,
c.svc_genre_id_list c
answered 2 years ago
Relevant content
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago