drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Faraaz <kfar...@maprtech.com>
Subject Re: NULL values for DATE type columns using JDBC connector
Date Thu, 15 Sep 2016 18:46:51 GMT
This is related to DRILL-4842

On Wed, Sep 14, 2016 at 12:31 AM, Sudheesh Katkam <skatkam@maprtech.com>
wrote:

> Hi Dan,
>
> Per documentation <http://drill.apache.org/docs/rdbms-storage-plugin/>, I
> don’t think sql4es is in the list of actively tested JDBC drivers. But a
> “WHERE something IS NOT NULL” returning NULL looks like a bug to me. Can
> you open a ticket <https://issues.apache.org/jira/browse/DRILL>?
>
> Thank you,
> Sudheesh
>
> > On Sep 12, 2016, at 8:04 AM, Dan Markhasin <minimizer@gmail.com> wrote:
> >
> > Hi all,
> >
> > I'm using Drill to query ElasticSearch using the sql4es driver (
> > https://github.com/Anchormen/sql4es) and I've run into an issue where
> Drill
> > returns NULL values for Date columns:
> >
> > 0: jdbc:drill:zk=local> select Date_01 from
> > ES23.`data-generator-poc-async`.arm where Date_01 IS NOT NULL limit 1;
> > +----------+
> > | Date_01  |
> > +----------+
> > | null     |
> > +----------+
> >
> > The DESCRIBE command returns the correct data type (DATE).
> >
> > Using other JDBC clients (Squirrel / WorkbenchJ) I am able to run the
> exact
> > same query on the exact source, and get the correct data (which is in the
> > form of 2016-03-21, for example).
> >
> > Any idea why it's returning null?
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message