<auto promotion mode on> The problem of NULL insert is already solved long time ago with Insert Strategy in Achilles: https://github.com/doanduyhai/Achilles/wiki/Insert-Strategy
</auto promotion off> However, it's nice to see there will be a flag on the protocol side to handle this problem On Wed, Apr 29, 2015 at 2:27 PM, Ali Akhtar <[email protected]> wrote: > Have you considered adding a 'toSafe' method which checks if the item is > null, and if so, returns a default value? E.g String too = safe(bar, ""); . > On Apr 29, 2015 3:14 PM, "Matthew Johnson" <[email protected]> > wrote: > >> Hi all, >> >> >> >> I have some fields that I am storing into Cassandra, but some of them >> could be null at any given point. As there are quite a lot of them, it >> makes the code much more readable if I don’t check each one for null before >> adding it to the INSERT. >> >> >> >> I can see a few Jiras around CQL 3 supporting inserting nulls: >> >> >> >> https://issues.apache.org/jira/browse/CASSANDRA-3783 >> >> https://issues.apache.org/jira/browse/CASSANDRA-5648 >> >> >> >> But I have tested inserting null and it seems to work fine (when querying >> the table with cqlsh, it shows up as a red lowercase *null*). >> >> >> >> Are there any obvious pitfalls to look out for that I have missed? Could >> it be a performance concern to insert a row with some nulls, as opposed to >> checking the values first and inserting the row and just omitting those >> columns? >> >> >> >> Thanks! >> >> Matt >> >> >> >
