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?

Reply via email to