I am having an issue with summing minutes using intervalmatch. I am currently loading the following.
scheduleEvents:
LOAD id, starttime, stoptime, ActivityTypeName from events;
intervalTable:
LOAD minute, timeRangeName from MinuteSheet.xlsx;
LEFT JOIN (intervalTable)
INTERVALMATCH (minute) LOAD starttime, stoptime RESIDENT scheduleEvents;
LEFT JOIN (intervalTable) LOAD * RESIDENT scheduleEvents;
DROP TABLE scheduleEvents;
Once loaded I am able to group by timeRangeName and count the the minutes field to get total time for the interval. The issue that I am having is the amount of resources its using and the shear size of the application. I had to scale my load down to a week worth of data at one time for 100 employee events.
I really want to increase about of days I am loading but I am scared that my terminal would explode if I did so. Is there anything that anyone recommends that might help me out with my issue.
Thank you,
