Re: Issue with time zone

2017-12-14 Thread Vitalii Diravka
Hi Kostyantyn, * Without zookeeper you can just run drillbit in embedded mode: *bin/drill-embedded* * Also "*timeofday()*" Drill function can help you to identify a timezone used by your drillbit: "start your sql engine" 0: jdbc:drill:zk=local> SELECT TIMEOFDAY() FROM (VALUES(1));

Re: Issue with time zone

2017-12-14 Thread Vova Vysotskyi
Hi Kostyantyn, I just checked this issue: 1) With timezone America/New_York query fails as it was described: 0: jdbc:drill:zk=local> select to_timestamp('2015-03-08 02:58:51','-MM-dd HH:mm:ss') from sys.version; Error: SYSTEM ERROR: IllegalInstantException: Cannot parse "2015-03-08 02:58:51":

Issue with time zone

2017-12-13 Thread Kostyantyn Krakovych
Hi Team, I faced with the issue described in http://www.openkb.info/2015/05/understanding-drills-timestamp-and.html Drill 1.11 I run sqlline -u jdbc:drill:zk=local on local computer. Meantime I do not see user.timestamp