Weird Cassandra upsert behaviour

This post is about explaining one huge difference between cassandra upsert and insert and how things get hairy when you use ttl with a column. Table schema Here is the cql statement to create the table. Normal insert so far so good. Normal update This is an update which behaves like normal insert. insert and update with a null In the insert statement as we have mentioned a primary key but set a non-primary-key column to null a row should be inserted into the table.…