drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rahul challapalli <challapallira...@gmail.com>
Subject JDBC Plugin and Date type
Date Fri, 04 Nov 2016 18:34:42 GMT
Folks,

I have a couple of questions.

1. After the fix for DRILL-4203, I tried querying parquet files by
disabling the auto-correction. Below is what I got from JDBC . However
sqlline gets rid of the first character and displays the proper result

Query : select l_shipdate from table(cp.`tpch/lineitem.parquet` (type =>
'parquet', autoCorrectCorruptDates => false)) order by l_shipdate limit 10;


^@356-03-19
^@356-03-21
^@356-03-21
^@356-03-23
^@356-03-24
^@356-03-24
^@356-03-26
^@356-03-26
^@356-03-26
^@356-03-26
2. From sqlline, I can't get date values greater than 9999th year. The
below query should have returned '10297-04-27'. Am I missing anything?

0: jdbc:drill:zk=local> select TO_DATE(262784904600000) from (VALUES(1));
+-------------+
|   EXPR$0    |
+-------------+
| 297-04-27  |
+-------------+


- Rahul

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message