Load Editor stuck on 'Starting to load'

robindc — Sat, 16 Nov 2024 05:26:27 GMT

Hi!

I've ceated a QVD containing about 194M records and about 11 columns.

Now, I want to load this QVD in the data load editor and build some logic on it.

This is the code I would like to execute:

TRANS_FLAGS_UNIQUE: LOAD Min(ACTIONDATE) as Date, Year, Month, Day, Hour, CAMPAIGNID, ACTIONID, PROBEID, USERID, SUM(Opened) as Unique_Opened, SUM(Clicked) as Unique_Clicked, SUM(Optout) as Unique_Optout FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd] (qvd) group by CAMPAIGNID, ACTIONID, PROBEID, USERID; join TRANS_FLAGS_ALL: LOAD Min(ACTIONDATE) as Date, Year, Month, Day, Hour, CAMPAIGNID, ACTIONID, PROBEID, FLAGID, USERID, SUM(Opened) as All_Opened, SUM(Clicked) as All_Clicked, SUM(Optout) as All_Optout FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd] (qvd) group by CAMPAIGNID, ACTIONID, PROBEID, USERID,FLAGID;

When I start the data load, it keeps saying: 'Started loading data'.

How can I fix this? When I load in the QVD without any additional logic, it takes around 3 minutes.

Thanks!

topic Load Editor stuck on 'Starting to load' in App Development

Load Editor stuck on 'Starting to load'