PHOENIX-3817 Verify Replication using SQL conditions

[akshita-malhotra]

The motivation is to be able to verify replication between two tables - source and a target table (on same or some other cluster) , based on some sql conditions. Per source input split an aligned target scan is retrieved, the verification is done by comparing rows once the start row is aligned. Based on the comparison the target scan row is moved. This approach is scn aware. I will be including more test scenarios in future updates.

[akshita-malhotra]

@vincentpoon @karanmehta93 @aaraujo @gjacoby126 @twdsilva Will appreciate your review feedback! Thanks.

[akshita-malhotra]

Thanks for the feedback @karanmehta93 ! I will look into the changes.

[karanmehta93]

It would be good to add some comments @akshita-malhotra once you are done with the dev part.

[akshita-malhotra]

@karanmehta93 Updated the test suite based on your comments. Added some more comments, will add some more :) @twdsilva Reused the split system catalog logic as per your suggestion, seems to be working well. It would be great if you can take another pass at the PR. @gjacoby126 @vincentpoon Please take a look whenever you get a chance.

[akshita-malhotra]

@aaraujo, @apurtell : It will be great if you can take a look as well. Thank you

[twdsilva]

@karanmehta93 or @gjacoby126 can you also please review and commit this patch if it looks good?

[akshita-malhotra]

@gjacoby126 Thanks a lot for the review. I will incorporate the changes and update the PR and jira patch.

[aaraujo]

Hey @akshita-malhotra, I'll take a look at your next patch!