You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/06/20 21:23:00 UTC
[jira] [Commented] (TRAFODION-3115) Support nanoseconds(9)
precision for Timestamp columns
[ https://issues.apache.org/jira/browse/TRAFODION-3115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16518614#comment-16518614 ]
ASF GitHub Bot commented on TRAFODION-3115:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/trafodion/pull/1616
TRAFODION-3115 Support nanosec precision for Timestamp/Interval datatypes
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/trafodion ansharma_tsnano_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1616.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1616
----
commit 319abf81860b6102658f48802172b6ea9aa607a0
Author: Anoop Sharma <an...@...>
Date: 2018-06-11T18:16:21Z
nanosecs precision for timestamp/interval datatypes
commit 50c2a891c4b6044283b01c37796785ad92a96ed9
Author: Anoop Sharma <an...@...>
Date: 2018-06-11T18:19:39Z
Merge remote branch 'origin/master' into ansharma_tsnano_br
Conflicts:
core/sql/regress/hive/EXPECTED005
commit 6bcca437a6a6850976dcfd0026df5834f52cf924
Author: Anoop Sharma <an...@...>
Date: 2018-06-15T15:27:19Z
Merge remote branch 'origin/master' into ansharma_tsnano_br
commit e3af7d910f62c34b7c7d49922de9d06b91459ba2
Author: Anoop Sharma <an...@...>
Date: 2018-06-20T18:56:51Z
Merge remote branch 'origin/master' into ansharma_tsnano_br
commit 84d76f4d3203b9e51803851713bfaeda4112e0b3
Author: Anoop Sharma <an...@...>
Date: 2018-06-20T21:19:41Z
TRAFODION-3115 Support nanosec precision for Timestamp/Interval datatypes
----
> Support nanoseconds(9) precision for Timestamp columns
> ------------------------------------------------------
>
> Key: TRAFODION-3115
> URL: https://issues.apache.org/jira/browse/TRAFODION-3115
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> Traf supports max fractional precision of 6 (microseconds) for Timestamp columns.
> It prevents values with fractional precision greater than 6 digits to be inserted into these columns.
> This becomes a bigger issue when dealing with Hive tables that have existing data with nanoseconds(9) precision. Selecting that data returns an error and causes queries to fail. Using a CAST to truncate data to timestamp(6) doesn't work either.
> Example:
> From Traf: create table hive.hive.ts (a timestamp);
> From Hive: insert into ts values ('2018-01-01 10:10:10.123456789');
> From Traf: selecting data from table 'ts' returns error:
> >>select * from hive.hive.ts;
> *** 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.
>
> >>select cast(a as timestamp(6)) from hive.hive.ts;
> *** 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 filed to add support for max precision of 9 for Timestamp columns. of Traf and Hive tables.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)