[TRAFODION-3040] Support nanosecond fractional precision for time,timestamp, interval columns

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Anoop Sharma
• Reporter: Anoop Sharma
• Created: 23/Apr/18 18:44
• Updated: 23/Apr/18 18:45

Description

Trafodion supports max of 6 digits(microseconds) of fractional precision for timestamp, time and interval second datatypes.

Besides restricting traf columns to microseconds, it also prevents reading of external hive data inserted with nanosecond precision. An error is returned when that data is selected. That same data could be accessed directly from hive shell.

 

From hive:

hive> select * from thivens;
OK
thivens.a
2018-01-01 10:10:10.123456789
Time taken: 0.198 seconds, Fetched: 1 row(s)
hive>

From traf:

>>select * from hive.hive.thivens;

• • • ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 2018-01-01 10:10:10.123456789

— 0 row(s) selected.
>>

This Jira is being filed to allow timestamp/time/interval datatype to go up to 9 digits(nanoseconds) of fractional precision. It should apply to column definitions, CAST clause, CALL procedure columns, and be supported for selects,insert/update statements.