[
https://issues.apache.org/jira/browse/SPARK-16981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15670614#comment-15670614
]
Herman van Hovell commented on SPARK-16981:
-------------------------------------------
Could you retest this on the current master? I think this has been fixed.
> For CSV files nullValue is not respected for Date/Time data type
> ----------------------------------------------------------------
>
> Key: SPARK-16981
> URL: https://issues.apache.org/jira/browse/SPARK-16981
> Project: Spark
> Issue Type: Bug
> Affects Versions: 2.0.0
> Reporter: Lev
> Priority: Critical
>
> Test case
> val struct = StructType(Seq(StructField("col1", StringType,
> true),StructField("col2", TimestampType, true), Seq(StructField("col3",
> StringType, true)))
> val cq = sqlContext.readStream
> .format("csv")
> .option("nullValue", " ")
> .schema(struct)
> .load(s"somepath")
> .writeStream(....)
> content of the file
> "abc", ,"def"
> Result:
> Exception is thrown:
> scala.MatchError: java.lang.IllegalArgumentException: Timestamp format must
> be yyyy-mm-dd hh:mm:ss[.fffffffff] (of class
> java.lang.IllegalArgumentException)
> Code analysis:
> Problem is caused by code in castTo method of CSVTypeCast object
> For all data types except temporal there is the following check:
> if (datum == options.nullValue && nullable) {
> null
> }
> But for temporal types it is missing
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
