Re: NULL values for DATE type columns using JDBC connector

2016-09-18 Thread Dan Markhasin
After some debugging it turns out the issue is in the integration between Apache Drill and the SQL4ES JDBC driver, which doesn't implement the getDate(int, java.util.calendar) method (it's a stub that returns null). I have submitted an issue to the maintainer of SQL4ES, but I do wonder why does Dr

Re: NULL values for DATE type columns using JDBC connector

2016-09-15 Thread Khurram Faraaz
This is related to DRILL-4842 On Wed, Sep 14, 2016 at 12:31 AM, Sudheesh Katkam wrote: > Hi Dan, > > Per documentation , I > don’t think sql4es is in the list of actively tested JDBC drivers. But a > “WHERE something IS NOT NULL” returning NULL

Re: NULL values for DATE type columns using JDBC connector

2016-09-13 Thread Sudheesh Katkam
Hi Dan, Per documentation , 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 ? T