trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lium...@apache.org
Subject [2/4] incubator-trafodion git commit: add numeric (precision, scale)
Date Thu, 18 May 2017 13:57:10 GMT
add numeric (precision, scale)


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/1e6657d0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/1e6657d0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/1e6657d0

Branch: refs/heads/master
Commit: 1e6657d09344a131354722e7c461ec1276c399b2
Parents: a5329dd
Author: liu.yu <yu.liu@esgyn.cn>
Authored: Wed May 17 11:40:06 2017 +0800
Committer: liu.yu <yu.liu@esgyn.cn>
Committed: Wed May 17 11:40:06 2017 +0800

----------------------------------------------------------------------
 docs/sql_reference/src/asciidoc/_chapters/introduction.adoc | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1e6657d0/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
index 187a3bb..b29ca9e 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
@@ -267,15 +267,18 @@ select * from hive.hive.t; -- explicit table name
 | `varchar`             | `varchar`
 | `char`                | `char`
 | `float`               | `real`
-| `decimal (precision, scale)`                | `decimal (precision, scale)`
+| `decimal (precision, scale)`                | `decimal (precision, scale)`^2^ +
+`numeric (precision, scale)`^3^
 | `double`              | `float(54)`
-| `timestamp`           | `timestamp(6)`^2^
+| `timestamp`           | `timestamp(6)`^4^
 | `date`                | `date`
 |===
 
 1. The value `_n_` is determined by `CQD HIVE_MAX_STRING_LENGTH`. See the
 {docs-url}/cqd_reference/index.hmtl[{project-name} Control Query Default (CQD) Reference
Guide].
-2. Hive supports timestamps with nanosecond resolution (precision of 9). {project-name} SQL
supports only microsecond resolution (precision 6).
+2. If p is less than 18, decimal (precision, scale) is mapped to decimal (precision, scale).
+3. If p is greater than 18, decimal (precision, scale) is mapped to numeric (precision, scale).
+4. Hive supports timestamps with nanosecond resolution (precision of 9). {project-name} SQL
supports only microsecond resolution (precision 6).
 
 [[supported_sql_statements_with_hive_tables]]
 === Supported SQL Statements With Hive Tables


Mime
View raw message