Fetch multiple array elements

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


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

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

Thanks balaji.ramaswamy