The JSON below is stored in a VARIANT column named V in a table named jCustRaw: Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?
Technically, none of the statements work properly. The nearest valid option is B.
create or replace table persons as
select parse_json(
'{
"_id": "4534554654640",
"company": "Boo",
"name": "Dean",
"teamMembers": [
{
"age":29,
"eyeColor": "green"
},
{
"age":39,
"eyeColor": "green2"
}
]
}'
) as c ;
select f.value:eyeColor::varchar as eyeColor,
f.value:age
from TASK_DB.PUBLIC.PERSONS as p,
lateral flatten(input => p:teamMembers) f;
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
BigDataBB
1 month, 1 week agostopthisnow
1 month, 3 weeks ago