Hi, Needed a suggestion for a schema query. I want to build a reconciliation using Cassandra. Basically two or more systems send message to a reconciliation process. The reconciliation process first does a level one match of id's and than does complete comparison of messages.
The best I could think of is a queue table with id's. My consumer thread would, poll this table, create a pair and would have to delete from this table. But this is a known anti pattern to not use Cassandra as a queue causing tombstones etc. But I could not think of any other way. Does anyone have any other suggestion so as to not delete after a pair is crated. Is Cassandra not the correct technology for a recon process? Thanks, Sagar
