You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Alican ERTURK <Al...@enerjisa.com> on 2018/04/06 07:05:28 UTC

About Drill Timezone Parse

Hi,

I try to parse timestamp field in Apache Drill .

Our timestamp field format is :  'Wed June 04 12:09:56 EET 2001'

We use this parse function  -->  TO_TIMESTAMP('Wed June 04 12:09:56 EET 2001', 'E MMMM dd hh:mm:ss z yyyy')  does not work.  We get an error as below :

--- org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalArgumentException: Invalid format: "Wed June 04 12:09:56 EET 2001" is malformed at "EET 2001" ---

However we change the timezone part EET to EST - TO_TIMESTAMP('Wed June 04 12:09:56 EST 2001', 'E MMMM dd hh:mm:ss z yyyy')   - it works. It parses the timestamp field.

How can we parse EET timezone format in Apache Drill ?

Can you help us ?

Best regards,



ALİCAN ERTÜRK
İŞ ZEKASI UZMANI
MİMARİ VE İŞ ZEKASI MÜDÜRLÜĞÜ
ENERJİSA ENERJİ A.Ş.


[Açıklama: cid:image005.png@01D1292C.496C01D0]




________________________________

Bu ileti hukuken korunmuş, gizli veya ifşa edilmemesi gereken bilgiler içerebilir. Şayet mesajın gönderildiği kişi değilseniz, bu iletiyi çoğaltmak ve dağıtmak yasaktır. Bu mesajı yanlışlıkla alan kişi, bu durumu derhal gönderene telefonla ya da e-posta ile bildirmeli ve bilgisayarından silmelidir. Bu iletinin içeriğinden yalnızca iletiyi gönderen kişi sorumludur.

This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return communication and delete it from his or her computer. Only the person who has sent this message is responsible for its content.

RE: About Drill Timezone Parse

Posted by Alican ERTURK <Al...@enerjisa.com>.
Hi Arjun,

Thanks for your help. It works :)

Appreciate you.

Alican.


ALİCAN ERTÜRK
İŞ ZEKASI UZMANI
MİMARİ VE İŞ ZEKASI MÜDÜRLÜĞÜ
ENERJİSA ENERJİ A.Ş.





-----Original Message-----
From: Arjun kr [mailto:arjun.kr@outlook.com]
Sent: Friday, April 06, 2018 12:00 PM
To: user@drill.apache.org
Subject: COMMERCIAL:Şüpheli MailRe: About Drill Timezone Parse

Hi Alican,


Please see if below syntax helps. Looks like hour format is in 24-hour format (HH instead of hh).


0: jdbc:drill:schema=dfs> select TO_TIMESTAMP('Mon June 04 12:09:56 EET 2001', 'E MMM dd HH:mm:ss ZZZ yyyy') from (values(1));
+------------------------+
|         EXPR$0         |
+------------------------+
| 2001-06-04 12:09:56.0  |
+------------------------+
1 row selected (0.285 seconds)


Thanks,

Arjun



________________________________
From: Alican ERTURK <Al...@enerjisa.com>
Sent: Friday, April 6, 2018 12:35 PM
To: user@drill.apache.org
Subject: About Drill Timezone Parse


Hi,



I try to parse timestamp field in Apache Drill .



Our timestamp field format is :  'Wed June 04 12:09:56 EET 2001'



We use this parse function  -->  TO_TIMESTAMP('Wed June 04 12:09:56 EET 2001', 'E MMMM dd hh:mm:ss z yyyy')  does not work.  We get an error as below :



--- org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalArgumentException: Invalid format: "Wed June 04 12:09:56 EET 2001" is malformed at "EET 2001" ---



However we change the timezone part EET to EST - TO_TIMESTAMP('Wed June 04 12:09:56 EST 2001', 'E MMMM dd hh:mm:ss z yyyy')   - it works. It parses the timestamp field.



How can we parse EET timezone format in Apache Drill ?



Can you help us ?



Best regards,







ALİCAN ERTÜRK
İŞ ZEKASI UZMANI
MİMARİ VE İŞ ZEKASI MÜDÜRLÜĞÜ
ENERJİSA ENERJİ A.Ş.



[Açıklama: cid:image005.png@01D1292C.496C01D0]






________________________________

Bu ileti hukuken korunmuş, gizli veya ifşa edilmemesi gereken bilgiler içerebilir. Şayet mesajın gönderildiği kişi değilseniz, bu iletiyi çoğaltmak ve dağıtmak yasaktır. Bu mesajı yanlışlıkla alan kişi, bu durumu derhal gönderene telefonla ya da e-posta ile bildirmeli ve bilgisayarından silmelidir. Bu iletinin içeriğinden yalnızca iletiyi gönderen kişi sorumludur.

This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return communication and delete it from his or her computer. Only the person who has sent this message is responsible for its content.

________________________________

Bu ileti hukuken korunmuş, gizli veya ifşa edilmemesi gereken bilgiler içerebilir. Şayet mesajın gönderildiği kişi değilseniz, bu iletiyi çoğaltmak ve dağıtmak yasaktır. Bu mesajı yanlışlıkla alan kişi, bu durumu derhal gönderene telefonla ya da e-posta ile bildirmeli ve bilgisayarından silmelidir. Bu iletinin içeriğinden yalnızca iletiyi gönderen kişi sorumludur.

This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return communication and delete it from his or her computer. Only the person who has sent this message is responsible for its content.

Re: About Drill Timezone Parse

Posted by Arjun kr <ar...@outlook.com>.
Hi Alican,


Please see if below syntax helps. Looks like hour format is in 24-hour format (HH instead of hh).


0: jdbc:drill:schema=dfs> select TO_TIMESTAMP('Mon June 04 12:09:56 EET 2001', 'E MMM dd HH:mm:ss ZZZ yyyy') from (values(1));
+------------------------+
|         EXPR$0         |
+------------------------+
| 2001-06-04 12:09:56.0  |
+------------------------+
1 row selected (0.285 seconds)


Thanks,

Arjun



________________________________
From: Alican ERTURK <Al...@enerjisa.com>
Sent: Friday, April 6, 2018 12:35 PM
To: user@drill.apache.org
Subject: About Drill Timezone Parse


Hi,



I try to parse timestamp field in Apache Drill .



Our timestamp field format is :  'Wed June 04 12:09:56 EET 2001'



We use this parse function  -->  TO_TIMESTAMP('Wed June 04 12:09:56 EET 2001', 'E MMMM dd hh:mm:ss z yyyy')  does not work.  We get an error as below :



--- org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalArgumentException: Invalid format: "Wed June 04 12:09:56 EET 2001" is malformed at "EET 2001" ---



However we change the timezone part EET to EST - TO_TIMESTAMP('Wed June 04 12:09:56 EST 2001', 'E MMMM dd hh:mm:ss z yyyy')   - it works. It parses the timestamp field.



How can we parse EET timezone format in Apache Drill ?



Can you help us ?



Best regards,







ALİCAN ERTÜRK
İŞ ZEKASI UZMANI
MİMARİ VE İŞ ZEKASI MÜDÜRLÜĞÜ
ENERJİSA ENERJİ A.Ş.



[Açıklama: cid:image005.png@01D1292C.496C01D0]






________________________________

Bu ileti hukuken korunmuş, gizli veya ifşa edilmemesi gereken bilgiler içerebilir. Şayet mesajın gönderildiği kişi değilseniz, bu iletiyi çoğaltmak ve dağıtmak yasaktır. Bu mesajı yanlışlıkla alan kişi, bu durumu derhal gönderene telefonla ya da e-posta ile bildirmeli ve bilgisayarından silmelidir. Bu iletinin içeriğinden yalnızca iletiyi gönderen kişi sorumludur.

This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return communication and delete it from his or her computer. Only the person who has sent this message is responsible for its content.