You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by Sagar Jambhulkar <sa...@gmail.com> on 2016/12/17 12:08:05 UTC

Schema help needed

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

Re: Schema help needed

Posted by Sagar Jambhulkar <sa...@gmail.com>.
Apologies sorry for the spam.

On Dec 18, 2016 12:53 AM, "Eric Stevens" <mi...@gmail.com> wrote:

> Hi Sagar, you'll probably do better to ask this question on the users group
> rather than the dev group.  Dev groups are about internal development while
> users groups are about using the software.
>
> On Sat, Dec 17, 2016 at 5:08 AM Sagar Jambhulkar <
> sagar.jambhulkar@gmail.com>
> wrote:
>
> 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
>

Re: Schema help needed

Posted by Eric Stevens <mi...@gmail.com>.
Hi Sagar, you'll probably do better to ask this question on the users group
rather than the dev group.  Dev groups are about internal development while
users groups are about using the software.

On Sat, Dec 17, 2016 at 5:08 AM Sagar Jambhulkar <sa...@gmail.com>
wrote:

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