Hi Rahul, Looks like the sqline cuts the values, because from drill unit tests the same query returns a full result: ------------------------------------------------ | EXPR$0<DATE(REQUIRED)> | ------------------------------------------------- | 10297-04-27T22:50:00.000Z | ------------------------------------------------
Kind regards Vitalii 2016-11-04 18:34 GMT+00:00 rahul challapalli <[email protected]>: > 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 >
