set drop_system_columns not working

Question

this from https://experienceleague.adobe.com/en/docs/experience-platform/query/use-cases/data-exploration

it says that set drop_system_columns=false;

would show metadata columns _acp_system_metadata and _ACP_BATCHID

when i run below query, it works fine
select * from datasetName

but when i run this query,
set drop_system_columns=false;
select * from datasetName

it give me following error
Cannot read properties of undefined (reading 'map')

datasetName really dont have any field with dataType map.

Pradeep-Jaiswal · Accepted Answer

Finally i found the wok around syntax, as document is slightly misleading select _acp_system_metadata.*, * from datasetName give me those hidden column in the output

mustufam5967803 · Answer

@pradeep-jaiswal ,If you check the logs of Query Services, you will see that this is not an error. The result has been successfully returned to the client. It is unclear whether this is a limitation of AEP Query Services, but the same results can be fetched using a Python script or DB Visualizer. The document which you are referring also has screenshots from DB Visualizer.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded