Topic: Queries

Hi, I've a simple query which I'm executing from Query Service UI & API. Query Service UI execution return records successfully where as API query execution fails. I can see status of both the execution in Query Service log.   I'm executing the same query from UI & API. Query : Select * FROM <table...

Hi, I've a dataset which contains 51 columns but when I query my dataset in query service it return just 16 columns. Column in dataset :  _idendUserIDs._experience.emailid.idweb.webInteraction.URL application.launches.valueendUserIDs._experience.emailid.namespace.codeweb.webInteraction.linkClicks.id...

Why do these queries throw the same error in Queries? SELECT * FROM table WHERE table.eventType LIKE "purchases" LIMIT 10; SELECT * FROM table WHERE table.eventType = "commerce.purchases" LIMIT 10; Error: ErrorCode: 08P01 Unknown error encountered. Reason: [Column 'commerce.purchases' does not exist...

Description - A simple query takes an unexpectedly long time to complete. See examples below. This indicates that AEP Queries is just not ready for widespread, "production" use, really. Why is this feature important to you - 99% of writing a correct, working query is figuring out the way to write it...

Adobe Experience Platform Query Service was released in June 2019. The following blog post describes our architectural approach and provides examples.