Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-09 Thread Jonathan Haddad
as it artived from Kafka, there might already be an event for >>>>>>> this happening saved before, or maybe this is the first one. >>>>>>> >>>>>>> BR, >>>>>>> Tomas >>>>>>> >>>>>>> >>&

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-09 Thread Tomas Bartalos
rote: > You say the events are incremental updates. I am interpreting this to mean > only some columns are updated. Others should keep their original values. > > You are correct that inserting null creates a tombstone. > > Can you only insert the columns that actually have new v

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread DuyHai Doan
ents >>>>>>> may be prohibitive. >>>>>>> >>>>>>> Instead, you can look into driver level support for UNSET values. >>>>>>> Requires Cassandra 2.2 or later IIRC. >>>>>>> >>>>>>> See: >

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread Jonathan Haddad
gt; Java Driver: >>>>>> https://docs.datastax.com/en/developer/java-driver/3.0/manual/statements/prepared/#parameters-and-binding >>>>>> Python Driver: >>>>>> https://www.datastax.com/dev/blog/python-driver-2-6-0-rc1-with-cassandra-2-2-featur

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread Tomas Bartalos
r...@homedepot.com> wrote: >>>>> >>>>>> You say the events are incremental updates. I am interpreting this to >>>>>> mean only some columns are updated. Others should keep their original >>>>>> values. >>>>>> >&

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread Jonathan Haddad
. >>>>> >>>>> You are correct that inserting null creates a tombstone. >>>>> >>>>> Can you only insert the columns that actually have new values? Just >>>>> skip the columns with no information. (Make the insert generator a bit &g

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread Tomas Bartalos
ou only insert the columns that actually have new values? Just >>>> skip the columns with no information. (Make the insert generator a bit >>>> smarter.) >>>> >>>> Create table happening (id text primary key, event text, a text, b >>>> text, c text

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2019-01-04 Thread DuyHai Doan
t smarter.) >>> >>> Create table happening (id text primary key, event text, a text, b text, >>> c text); >>> Insert into table happening (id, event, a, b, c) values >>> ("MainEvent","The most complete info we have right now","P

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2018-12-27 Thread Tomas Bartalos
ening (id, event, a, b, c) values ("MainEvent","The >> most complete info we have right now","Priceless","10 pm","Grand Ballroom"); >> -- b changes >> Insert into happening (id, b) values ("MainEvent","9:30 pm"); >&

Re: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2018-12-27 Thread Eric Stevens
; > > > Sean Durity > > > -Original Message----- > From: Tomas Bartalos > Sent: Thursday, December 27, 2018 9:27 AM > To: user@cassandra.apache.org > Subject: [EXTERNAL] Howto avoid tombstones when inserting NULL values > > Hello, > > I’d start with

RE: [EXTERNAL] Howto avoid tombstones when inserting NULL values

2018-12-27 Thread Durity, Sean R
quot;10 pm","Grand Ballroom"); -- b changes Insert into happening (id, b) values ("MainEvent","9:30 pm"); Sean Durity -Original Message- From: Tomas Bartalos Sent: Thursday, December 27, 2018 9:27 AM To: user@cassandra.apache.org Subject: [EXTERNAL