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