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:09 UTC
[1/4] incubator-trafodion git commit: add data-type mappings of hive
and trafodion
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 9a9833a05 -> ced104a79
add data-type mappings of hive and trafodion
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/a5329dd3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/a5329dd3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/a5329dd3
Branch: refs/heads/master
Commit: a5329dd3fd32618a820e0296a24e5b003eea06bd
Parents: 113c4de
Author: liu.yu <yu...@esgyn.cn>
Authored: Tue May 16 12:54:19 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Tue May 16 12:54:19 2017 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/introduction.adoc | 14 +++++---------
1 file changed, 5 insertions(+), 9 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a5329dd3/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 abbb0a3..187a3bb 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
@@ -120,7 +120,7 @@ For more information about {project-name} SQL tables, see
==== Cell-Per-Row Access to HBase Tables (Technology Preview)
NOTE: This is a _Technology Preview (Complete But Not Tested)_ feature, meaning that it is functionally
-complete but has not been tested or debugged.
+complete but has not been tested or debugged.
To access HBase data using cell-per-row mode, specify the schema `HBASE."_CELL_"` and the full ANSI
name of the table as a delimited table name. You can specify the name of any HBase table, regardless of whether
@@ -264,9 +264,13 @@ select * from hive.hive.t; -- explicit table name
| `int` | `int`
| `bigint` | `largeint`
| `string` | `varchar(_n_ bytes) character set utf8`^1^
+| `varchar` | `varchar`
+| `char` | `char`
| `float` | `real`
+| `decimal (precision, scale)` | `decimal (precision, scale)`
| `double` | `float(54)`
| `timestamp` | `timestamp(6)`^2^
+| `date` | `date`
|===
1. The value `_n_` is determined by `CQD HIVE_MAX_STRING_LENGTH`. See the
@@ -508,11 +512,3 @@ All other functions are {project-name} SQL extensions.
```
The message number is the SQLCODE value (without the sign). In this example, the SQLCODE value is `1000`.
-
-
-
-
-
-
-
-
[4/4] incubator-trafodion git commit: Merge Fix for [TRAFODION-2549]
update sql reference manual about new hive data type
Posted by li...@apache.org.
Merge Fix for [TRAFODION-2549] update sql reference manual about new hive data type
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/ced104a7
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/ced104a7
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/ced104a7
Branch: refs/heads/master
Commit: ced104a79eab9ff886047f8c03b271db3335d958
Parents: 9a9833a 40647ad
Author: Liu Ming <ov...@sina.com>
Authored: Thu May 18 13:56:32 2017 +0000
Committer: Liu Ming <ov...@sina.com>
Committed: Thu May 18 13:56:32 2017 +0000
----------------------------------------------------------------------
.../src/asciidoc/_chapters/introduction.adoc | 21 ++++++++++----------
1 file changed, 10 insertions(+), 11 deletions(-)
----------------------------------------------------------------------
[3/4] incubator-trafodion git commit: add if p is less than or equal
to 18
Posted by li...@apache.org.
add if p is less than or equal to 18
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/40647ad8
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/40647ad8
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/40647ad8
Branch: refs/heads/master
Commit: 40647ad83d656d250960d4a73f62337c71abd74b
Parents: 1e6657d
Author: liu.yu <yu...@esgyn.cn>
Authored: Wed May 17 12:36:55 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Wed May 17 12:36:55 2017 +0800
----------------------------------------------------------------------
docs/sql_reference/src/asciidoc/_chapters/introduction.adoc | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/40647ad8/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 b29ca9e..48f11b9 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
@@ -276,7 +276,7 @@ select * from hive.hive.t; -- explicit table name
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. If p is less than 18, decimal (precision, scale) is mapped to decimal (precision, scale).
+2. If p is less than or equal to 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).
[2/4] incubator-trafodion git commit: add numeric (precision, scale)
Posted by li...@apache.org.
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