Repository: trafodion-site Updated Branches: refs/heads/asf-site fa7941bbc -> 454b56a27 http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/dependencies.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/dependencies.html b/docs/sql_reference/dependencies.html index 22f557e..94090c4 100644 --- a/docs/sql_reference/dependencies.html +++ b/docs/sql_reference/dependencies.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
- Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html index 6c659f5..27c54df 100644 --- a/docs/sql_reference/index.html +++ b/docs/sql_reference/index.html @@ -23052,7 +23052,7 @@ FRACTION in 4 bytes

TIMESTAMP (with time precision)

Point in time, with time precision

-

Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte

+

Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 7 or 11 bytes

Interval Data Types

@@ -23719,14 +23719,126 @@ default for time-precision is 0, and the maximum is 6.

  • -

    TIMESTAMP [(timestamp-precision)]

    +

    TIMESTAMP

    +
    + +
    +
    +
    +
    SQL>CREATE TABLE test1(c1 TIMESTAMP);
    +
    +--- SQL operation complete.
    +
    +
    +SQL>SHOWDDL test1;
    +
    +CREATE TABLE TRAFODION.SEABASE.TEST1
    +  (
    +    C1                               TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED
    +  )
    + ATTRIBUTES ALIGNED FORMAT
    +;
    +
    +-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.TEST1 TO DB__ROOT WITH GRANT OPTION;
    +
    +--- SQL operation complete.
    +
    +
    +
  • +
  • +

    TIMESTAMP (timestamp-precision)

    -

    specifies a datetime column that, without the optional -timestamp-precision, contains a timestamp in the external form -yyyy-mm-dd hh:mm:ss and is stored in seven bytes. timestamp-precision -is an unsigned integer that specifies the number of digits in the -fractional seconds and is stored in four bytes. The default for -timestamp-precision is 6, and the maximum is 6.

    +

    specifies a datetime column with the timestamp-precision.

    +
    +
    +

    The timestamp-precision is an unsigned integer that specifies the number of digits in the +fractional seconds, the range of timestamp-precision is from 0 to 9, the storage size varies depending +on the timestamp-precision.

    +
    + ++++ + + + + + + + + + + + + + + +

    time-precision

    Storage Size (bytes)

    0

    7

    1~9

    11

    +
    +

    Example

    +
    +
    +
    +
    SQL>CREATE TABLE test2 (c1 TIMESTAMP, c2 TIMESTAMP(0), c3 TIMESTAMP(1), c4 TIMESTAMP(2), c5 TIMESTAMP(6), c6 TIMESTAMP(9));
    +
    +--- SQL operation complete.
    +
    +
    +SQL>SELECT COLUMN_NAME, COLUMN_SIZE from "_MD_".columns_view WHERE TABLE_NAME = 'TEST2';
    +
    +COLUMN_NAME                   COLUMN_SIZE
    +-----------------------------------------
    +C1                                     11
    +C2                                      7
    +C3                                     11
    +C4                                     11
    +C5                                     11
    +C6                                     11
    +SYSKEY                                  8
    +
    +--- 7 row(s) selected.
    +
    +
    +SQL>SHOWDDL test2;
    +
    +CREATE TABLE TRAFODION.SEABASE.TEST2
    +  (
    +    C1                               TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED
    +  , C2                               TIMESTAMP(0) DEFAULT NULL NOT SERIALIZED
    +  , C3                               TIMESTAMP(1) DEFAULT NULL NOT SERIALIZED
    +  , C4                               TIMESTAMP(2) DEFAULT NULL NOT SERIALIZED
    +  , C5                               TIMESTAMP(6) DEFAULT NULL NOT SERIALIZED
    +  , C6                               TIMESTAMP(9) DEFAULT NULL NOT SERIALIZED
    +  )
    + ATTRIBUTES ALIGNED FORMAT
    +;
    +
    +-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SEABASE.TEST2 TO DB__ROOT WITH GRANT OPTION;
    +
    +--- SQL operation complete.
    +
  • http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/integration.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/integration.html b/docs/sql_reference/integration.html index 03b99d5..5989de5 100644 --- a/docs/sql_reference/integration.html +++ b/docs/sql_reference/integration.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/issue-tracking.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/issue-tracking.html b/docs/sql_reference/issue-tracking.html index c7c6735..c975b19 100644 --- a/docs/sql_reference/issue-tracking.html +++ b/docs/sql_reference/issue-tracking.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/license.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html index 6904f99..a6e6197 100644 --- a/docs/sql_reference/license.html +++ b/docs/sql_reference/license.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/mail-lists.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/mail-lists.html b/docs/sql_reference/mail-lists.html index 5bd15e6..1a4278e 100644 --- a/docs/sql_reference/mail-lists.html +++ b/docs/sql_reference/mail-lists.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/project-info.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-info.html b/docs/sql_reference/project-info.html index e6a6973..ae42a28 100644 --- a/docs/sql_reference/project-info.html +++ b/docs/sql_reference/project-info.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/project-summary.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/project-summary.html b/docs/sql_reference/project-summary.html index 2d1190e..af02c76 100644 --- a/docs/sql_reference/project-summary.html +++ b/docs/sql_reference/project-summary.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/source-repository.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/source-repository.html b/docs/sql_reference/source-repository.html index def98e6..c8c252f 100644 --- a/docs/sql_reference/source-repository.html +++ b/docs/sql_reference/source-repository.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/docs/sql_reference/team-list.html ---------------------------------------------------------------------- diff --git a/docs/sql_reference/team-list.html b/docs/sql_reference/team-list.html index 136de3c..aa8457d 100644 --- a/docs/sql_reference/team-list.html +++ b/docs/sql_reference/team-list.html @@ -1,5 +1,5 @@ - + @@ -10,7 +10,7 @@ @import url("./css/site.css"); - + @@ -27,7 +27,7 @@
    - Last Published: 2018-08-10 + Last Published: 2018-08-21  | Version: 2.4.0
    Trafodion SQL Reference Manual http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/index.html ---------------------------------------------------------------------- diff --git a/index.html b/index.html index cf9a869..914e54b 100644 --- a/index.html +++ b/index.html @@ -1,7 +1,7 @@ @@ -160,16 +160,16 @@
    Hadoop Scale
    Trafodion Stack
    @@ -180,48 +180,48 @@
    -
    -

    News

    - - - - - - -

    -
    -
    -
    -
    We're working on release 2.3!
    -

    -

    Check out the Roadmap page for planned content.

    -

    -
    -
    -
    Apache Trafodion 2.2.0, our first release as a Top Level Project, was released on March 12, 2018.
    -

    -

    Check it out on the Download page.

    -

    -
    -
    -
    Apache Trafodion is now a Top Level Project!
    -

    -

    See the NewsWire article for the official announcement.

    -

    See also this nice article where Trafodion's own Suresh Subbiah spreads the word on Trafodion's features.

    -

    -
    -
    -
    Apache Trafodion 2.1.0-incubating was released on May 1, 2017.
    -

    -

    -
    -
    -
    Want to discuss Trafodion in Chinese? Join the Trafodion discussion on Tencent QQ!
    -

    -

    QQ Group ID: 233105278.

    -
    -
    -
    +
    +

    News

    + + + + + + +

    +
    +
    +
    +
    We're working on release 2.3!
    +

    +

    Check out the Roadmap page for planned content.

    +

    +
    +
    +
    Apache Trafodion 2.2.0, our first release as a Top Level Project, was released on March 12, 2018.
    +

    +

    Check it out on the Download page.

    +

    +
    +
    +
    Apache Trafodion is now a Top Level Project!
    +

    +

    See the NewsWire article for the official announcement.

    +

    See also this nice article where Trafodion's own Suresh Subbiah spreads the word on Trafodion's features.

    +

    +
    +
    +
    Apache Trafodion 2.1.0-incubating was released on May 1, 2017.
    +

    +

    +
    +
    +
    Want to discuss Trafodion in Chinese? Join the Trafodion discussion on Tencent QQ!
    +

    +

    QQ Group ID: 233105278.

    +
    +
    +
    -
    -
    -

    About

    -

    Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop.

    -

    The name "Trafodion" (the Welsh word for transactions, pronounced "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem.

    -

    Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop.

    +Are you using Trafodion? We need permission to add your company's logo here. --> +
    +
    +

    About

    +

    Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Apache Hadoop.

    +

    The name "Trafodion" (the Welsh word for transactions, pronounced "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that Trafodion provides in closing a critical gap in the Hadoop ecosystem.

    +

    Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop.

    -

    Key Features

    -
      -
    • Full-functioned ANSI SQL language support
    • -
    • JDBC/ODBC connectivity for Linux/Windows clients
    • -
    • Distributed ACID transaction protection across multiple statements, tables and rows
    • -
    • Performance improvements for OLTP workloads with compile-time and run-time optimizations
    • -
    • Support for large data sets using a parallel-aware query optimizer
    • -
    -
    +

    Key Features

    +
      +
    • Full-functioned ANSI SQL language support
    • +
    • JDBC/ODBC connectivity for Linux/Windows clients
    • +
    • Distributed ACID transaction protection across multiple statements, tables and rows
    • +
    • Performance improvements for OLTP workloads with compile-time and run-time optimizations
    • +
    • Support for large data sets using a parallel-aware query optimizer
    • +
    +
    -

    Key Benefits

    -
      -
    • Reuse existing SQL skills and improve developer productivity
    • -
    • Distributed ACID transactions guarantee data consistency across multiple rows and tables
    • -
    • Interoperability with existing tools and applications
    • -
    • Hadoop and Linux distribution neutral
    • -
    • Easy to add to your existing Hadoop infrastructure
    • +

      Key Benefits

      +
        +
      • Reuse existing SQL skills and improve developer productivity
      • +
      • Distributed ACID transactions guarantee data consistency across multiple rows and tables
      • +
      • Interoperability with existing tools and applications
      • +
      • Hadoop and Linux distribution neutral
      • +
      • Easy to add to your existing Hadoop infrastructure
    @@ -276,71 +276,71 @@ Are you using Trafodion? We need permission to add your company's logo here. -->
    - - - - - - - - +
    -
    -
    -

    Understand

    - -
    -
    -

    What makes Trafodion unique

    -
    - . -
    -
    -
    -
    -
    -
    -
    -
    -

    Use

    - -
    -
    -

    Download and try Trafodion

    -
    - . -
    -
    -
    -
    -
    -
    -
    -
    -

    Community

    - -
    -
    -

    Be part of Trafodion

    -
    - . -
    -
    -
    -
    -
    -
    + + + + + + +
    +
    +
    +

    Understand

    + +
    +
    +

    What makes Trafodion unique

    +
    + . +
    +
    +
    +
    +
    +
    +
    +
    +

    Use

    + +
    +
    +

    Download and try Trafodion

    +
    + . +
    +
    +
    +
    +
    +
    +
    +
    +

    Community

    + +
    +
    +

    Be part of Trafodion

    +
    + . +
    +
    +
    +
    +
    +
    @@ -491,12 +491,12 @@ Are you using Trafodion? We need permission to add your company's logo here. -->
    -
    Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational - workloads on Hadoop.

    The name "Trafodion" (the Welsh word for transactions, pronounced - "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that - Trafodion provides in closing a critical gap in the Hadoop ecosystem.

    - Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends - Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data +
    Apache Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational + workloads on Hadoop.

    The name "Trafodion" (the Welsh word for transactions, pronounced + "Tra-vod-eee-on") was chosen specifically to emphasize the differentiation that + Trafodion provides in closing a critical gap in the Hadoop ecosystem.

    + Trafodion builds on the scalability, elasticity, and flexibility of Hadoop. Trafodion extends + Hadoop to provide guaranteed transactional integrity, enabling new kinds of big data applications to run on Hadoop.
    http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/integration.html ---------------------------------------------------------------------- diff --git a/integration.html b/integration.html index 85b73be..17c2a5e 100644 --- a/integration.html +++ b/integration.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/issue-tracking.html ---------------------------------------------------------------------- diff --git a/issue-tracking.html b/issue-tracking.html index 9369a5d..fa40432 100644 --- a/issue-tracking.html +++ b/issue-tracking.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/license.html ---------------------------------------------------------------------- diff --git a/license.html b/license.html index 167dbc5..f0af40b 100644 --- a/license.html +++ b/license.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/mail-lists.html ---------------------------------------------------------------------- diff --git a/mail-lists.html b/mail-lists.html index 24ac369..c6861c1 100644 --- a/mail-lists.html +++ b/mail-lists.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/modules.html ---------------------------------------------------------------------- diff --git a/modules.html b/modules.html index d1743ae..4015a7b 100644 --- a/modules.html +++ b/modules.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/project-info.html ---------------------------------------------------------------------- diff --git a/project-info.html b/project-info.html index c4a03c6..256a202 100644 --- a/project-info.html +++ b/project-info.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/project-summary.html ---------------------------------------------------------------------- diff --git a/project-summary.html b/project-summary.html index 2d14638..130f884 100644 --- a/project-summary.html +++ b/project-summary.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/source-repository.html ---------------------------------------------------------------------- diff --git a/source-repository.html b/source-repository.html index 6e0726d..cdd7814 100644 --- a/source-repository.html +++ b/source-repository.html @@ -1,7 +1,7 @@ http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/454b56a2/team-list.html ---------------------------------------------------------------------- diff --git a/team-list.html b/team-list.html index 5a328be..c79183d 100644 --- a/team-list.html +++ b/team-list.html @@ -1,7 +1,7 @@