This is related to DRILL-4842 On Wed, Sep 14, 2016 at 12:31 AM, Sudheesh Katkam <skat...@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 <minimi...@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? > >