You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2017/05/18 13:57:10 UTC
[2/4] incubator-trafodion git commit: add numeric (precision, scale)
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...@esgyn.cn>
Authored: Wed May 17 11:40:06 2017 +0800
Committer: liu.yu <yu...@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