You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2019/04/11 18:38:00 UTC

[jira] [Commented] (SPARK-27429) [SQL] to_timestamp function with additional argument flag that will allow exception if value could not be cast

    [ https://issues.apache.org/jira/browse/SPARK-27429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16815697#comment-16815697 ] 

Hyukjin Kwon commented on SPARK-27429:
--------------------------------------

Usually we take an approach to permissively process them. I don't think we should add each flag to control each behaviour like this.

> [SQL] to_timestamp function with additional argument flag that will allow exception if value could not be cast
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-27429
>                 URL: https://issues.apache.org/jira/browse/SPARK-27429
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.4.1
>            Reporter: t oo
>            Priority: Major
>
> If I am running a SQL on a csv based dataframe and my query has  to_timestamp(input_col,'yyyy-MM-dd HH:mm:ss'), if the values in input_col are not really timestamp like 'ABC' then I would like to_timestamp function to throw an exception rather than happily (silently) return the values as null.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org