Under the sys.options I noticed there is a user.timezone option. Unfortunately it seems to be a BOOT option, and also I was not able to set it with alter system or session.
Ideally it will be best for this to be runtime option that can be set at session level, so different users can use a different timezone. Filed for an enhancement, but see if you can get the sys option to work. --Andries On Sat, Mar 14, 2015 at 12:45 PM, Vince Gonzalez <[email protected]> wrote: > 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 > > > > > > > -- Andries Engelbrecht Solution Architect [email protected] mapr.com <http://www.mapr.com/>
