Fetch multiple array elements

1

How to fetch multiple array elements under extract multiple. As I am successfully able to fetch single elements but I want to try to fetch multiple elements in Dremio UI. Thanks

2

@shrikanth

You would first need to flatten and then extract an element like below

SELECT fragmentProfile, nested_0.fragmentProfile.majorFragmentId AS majorFragmentId
FROM (
SELECT flatten(fragmentProfile) AS fragmentProfile
FROM “@dremio”.“profile-prod” AS “profile-prod”
) nested_0

3

Thanks balaji.ramaswamy