BOOT means it comes from drill-override.conf (or the defaults) and cannot be set via ALTER [SYSTEM|SESSION]. Note that -D works for all options that are in drill-override.conf but the better habit is to use the conf file.
On Sun, Mar 15, 2015 at 6:28 PM, Andries Engelbrecht < [email protected]> wrote: > 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/> >
