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
