Does changing the query to something like this work?:

SELECT CAST(CASE WHEN table.cf.myColumn IS NOT NULL THEN
table.cf.myColumn ELSE NULL END as INTEGER)
...

​

Chris Matta
[email protected]
215-701-3146

On Thu, Sep 10, 2015 at 12:49 PM, Nathaniel Auvil <[email protected]
> wrote:

> i have a MaprDB table which has nulls for some of the columns.  When i
> create a select where i CAST(table.cf.myColumn as INTEGER) and there are
> nulls instead of simply returning null for the value, there is a
> NullPointerException.
>
> Why not simply return null for the value if it is missing from a row?
>

Reply via email to