[SPARK-11817] insert of timestamp with factional seconds inserts a NULL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.1
• Fix Version/s: 1.5.3, 1.6.0
• Component/s: SQL
• Target Version/s: 1.5.3, 1.6.0
• Assignee: L. C. Hsieh
• Reporter: Chip Sands
• Created: 18/Nov/15 14:48
• Updated: 20/Nov/15 19:45
• Resolved: 20/Nov/15 19:45

Description

Using the Thrift jdbc interface.

The insert of the value of "1970-01-01 00:00:00.123456789" to a timestamp column, inserts a NULL into the database. I am aware the of the change
From 1.5 releases notes Timestamp Type’s precision is reduced to 1 microseconds (1us). However, to be compatible with previous versions, I would suggest either rounding or truncating the fractional seconds not inserting a NULL.

Issue Links

• links to: [Github] Pull Request #9834 (viirya)