<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 <ali.rac...@gmail.com> 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" <matt.john...@algomi.com>
> 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
>>
>>
>>
>

Reply via email to