How to get audience origin data using query in a new dataset

[ShivaniM]

Hello Experts, 

I'm trying to create a dataset which has details like person_id, its qualification time in the audience, status and audience_name, audience_ID and audience origin.

In  segment_ingestion_dataset deatset I'm able to see audience's origin as (AO, AEP segment etc) which I want to ingest in a new dataset. While using c.origin it is giving me error.

Could someone help me modify this query to get audience origin as well:

Select
c.id as SegmentID,
SegmentName, _repo
from
(
select
explode (b) as C,
SegmentName, _repo
from
(
select
explode_outer (a) as b,
SegmentName, _repo
from
(
select
map_values (IdentityMap) as a,
SegmentName,
-- segmentStatus,
_repo
from
segment_ingestion_dataset

)
)
)
(it is the part of that query)

[supratim320]

Can you share the error! Also in terms of debugging, I can see "segment_ingestion_dataset" is at the inner most query, so is that one failing?

To add further, I do not see "origin" field in this dataset, I guess you have to share most of the query for debugging.