[jira] [Created] (TRAFODION-3040) Support nanosecond fractional precision for time,timestamp interval columns

["Anoop Sharma (JIRA)" <ji...@apache.org>]

Anoop Sharma created TRAFODION-3040:
---------------------------------------

             Summary: Support nanosecond fractional precision for time,timestamp interval columns
                 Key: TRAFODION-3040
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3040
             Project: Apache Trafodion
          Issue Type: Improvement
            Reporter: Anoop Sharma
            Assignee: Anoop Sharma


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.

 



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