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

Reply via email to