Did a Jira get opened for this? If not, Nathaniel, can you provide me with your query and a sample data set so I can open one?
Chris Matta [email protected] 215-701-3146 On Thu, Sep 10, 2015 at 5:03 PM, Jason Altekruse <[email protected]> wrote: > A SQL level null is different than a null at the JAVA level that would be > giving this exception (we don't represent nulls with an actual null java > object). There might be a way to work around it, but this is a bug in > Drill. You should be able to make a cast between compatible types even if > there are nulls in the dataset. > > Could you open a JIRA and put as much description about your data and query > as possible? If you have the time to create a small repro, loading an Hbase > table with a small set of data that produces the problem that would be very > helpful. In any case, whatever you can provide will be useful the dev who > picks up the JIRA. > > On Thu, Sep 10, 2015 at 12:49 PM, Christopher Matta <[email protected]> > wrote: > > > 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? > > > > > >
