Community Topics

Query Service - is user able to Create Table ( without Data Distiller SKU ) ?

I would like to understand how FLATTEN feature work. While connecting to Power BI it should be put like that?Then thanks to that I can work with nested tables from Data Lake without the need to make them flat?The other solution which I think about is flattening the Data Lake tables using the Query S...

I have got a problem, do you know what only the highest key in schema hierarchy shows up? Two screenshots for you to understand what I talk about.Of course this column is empty:The particular event as you all know looks like this:  

Hi  I keep getting into this error where I try to access query service and the "Initializing connection..." message in the terminal never disappear and therefore I cannot run queries. I tried clearing the cache, reloading the page multiple times and restarting the browser, but nothing works. This ha...

Hi,  I created a data set few days ago and made simple data ingestion. Ingestion was successful. However if I run query like 'SHOW TABLES' in query service I do not see my dataset. Do you know why is that? I am sure I am under UI limit display for results.  Thanks Mike 

Hi, I'm trying to query a dataset using the query service. I would like to query only the latest batch data received. We are using a fully custom schema (_tenant...). I've tried accessing the system-generated such as createdByBatchID, but it seems that it is not accessible in the dataset.ex.SELECT c...

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.