Hello,

I'm trying to optimize very long-running queries (few hours):

We want to change user type for all activities done in span of 10 seconds (so for specific activity if there's any other activity done in 5 seconds before or 5 seconds after by same user and with same activity name the user type should be adjusted).

I've marked red a rows that won't be updated due to failing match (Different user_name, activity_name or exceeded time span).

Do you have any ideas? Right now I've got 2 queries:

A) Alter table - add integer column

B) First assign row numbers by just updating

C) Make selfjoin based on row numbering with just update

I know it could be easly done with LAG/LEAD analytical Vertica 10.0.x functions, however these are not supported.

Only other idea is to not assign row numbers but to use identity and try also to use MERGE.

help would be highly appreciated

Best Regards,

Mateusz Dudek