drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vova Vysotskyi <vvo...@gmail.com>
Subject Re: Illegal Argument Exception while convert unix date format to drill timestamp
Date Thu, 14 Dec 2017 10:14:33 GMT
Hi Divya,

Default timestamp format for Drill is 'YYYY-MM-DD HH:MI:SS'.
For the cases, when you want to get a timestamp from a string with another
format, date pattern should be specified.

Drill allows using both Jodatime patterns (to_date, to_time, to_timestamp
functions, see allowed patterns at [1])
and sql-like patterns (sql_to_date, sql_to_time, sql_to_timestamp
functions, see allowed patterns at [2])

[1]
http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html
[2] https://issues.apache.org/jira/browse/DRILL-4864

2017-12-14 10:17 GMT+02:00 Arjun kr <arjun.kr@outlook.com>:

> Pls see if this works for you.
>
>
> 0: jdbc:drill:schema=dfs> SELECT TO_TIMESTAMP('Sun Apr 1 00:00:01 UTC
> 2018', 'E MMM d HH:mm:ss z yyyy') FROM (VALUES(1));
> +------------------------+
> |         EXPR$0         |
> +------------------------+
> | 2018-04-01 00:00:01.0  |
> +------------------------+
> 1 row selected (0.165 seconds)
> 0: jdbc:drill:schema=dfs>
>
>
>
> Thanks,
>
> Arjun kr
>
> ________________________________
> From: Divya Gehlot <divya.htconex@gmail.com>
> Sent: Thursday, December 14, 2017 9:12 AM
> To: user@drill.apache.org
> Subject: Illegal Argument Exception while convert unix date format to
> drill timestamp
>
> Hi,
> Does Drill supprts to convert Unix date format to Drill timstamp ?
>
> Unix TimeStamp : Thu Dec 14 03:40:50 UTC 2017
> When I Cast to Drill time stamp I get Illegal Argument Exception.
>
>
> Thanks,
> Divya
>



-- 
Kind regards,
Volodymyr Vysotskyi

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message