drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sudheesh Katkam <skat...@maprtech.com>
Subject Re: NULL values for DATE type columns using JDBC connector
Date Tue, 13 Sep 2016 19:01:04 GMT
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