In case anyone runs into this, the turned out to be trivial. Add -Duser.timezone=UTC to DRILL_JAVA_OPTS in drill-env.sh.
On Thu, Mar 12, 2015 at 4:20 PM, Vince Gonzalez <[email protected]> wrote: > I've got a query that throws the following exception: > > 0: jdbc:drill:zk=node1:5181,node2:5181,node3:> select > SpotPrice,`Timestamp` from dfs.tmp.`spot_prices` order by `Timestamp`; > +------------+------------+ > | SpotPrice | Timestamp | > +------------+------------+ > Query failed: Query failed: *Failure while running fragment., Cannot > parse "2015-03-08 02:58:51": Illegal instant due to time zone offset > transition (America/New_York)* [ de543f7b-2a65-472b-a62c-59441d8d9daa on > node2:31010 ] > > I guess due to daylight savings, 02:58:51 doesn't exist (in > America/New_York we go from 2am to 3am when we "spring ahead"). > > I see a user.timezone option of type "BOOT". Does changing this to UTC > work around this kind of DST related issue? If so, how do I set this? > > --vince > > >
