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?