Systems, methods, and devices for managing data skew in a join operation

A first server comprising:

• at least one hardware processor;
• and
• one or more non-transitory computer-readable storage media containing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
• asynchronously receiving a frequent build-side row at the first server from a second server, the frequent build-side row corresponding to a join operation being conducted at least in part by the second server, the frequent build-side row comprising a frequent build-side join key;
• generating, at the first server for the received frequent build-side row, a local hash table for processing a local instance of a portion of the join operation;
• and
• altering, at the first server, a local input link to route, to the local instance of the portion of the join operation, a frequent probe-side row comprising a frequent probe-side join key corresponding to the frequent build-side join key.

One or more non-transitory computer-readable storage media containing instructions that, when executed by at least one hardware processor of a first server, cause the at least one hardware processor to perform operations comprising:

• asynchronously receiving a frequent build-side row at the first server from a second server, the frequent build-side row corresponding to a join operation being conducted at least in part by the second server, the frequent build-side row comprising a frequent build-side join key;
• generating, at the first server for the received frequent build-side row, a local hash table for processing a local instance of a portion of the join operation;
• and
• altering, at the first server, a local input link to route, to the local instance of the portion of the join operation, a frequent probe-side row comprising a frequent probe-side join key corresponding to the frequent build-side join key.