You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/05/05 23:39:42 UTC
[11/22] incubator-trafodion git commit: Prepared documents for TLP
and centralized shared information.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/_chapters/grant_privileges.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/_chapters/grant_privileges.adoc b/docs/spj_guide/src/asciidoc/_chapters/grant_privileges.adoc
index f369931..76f3f20 100644
--- a/docs/spj_guide/src/asciidoc/_chapters/grant_privileges.adoc
+++ b/docs/spj_guide/src/asciidoc/_chapters/grant_privileges.adoc
@@ -1,23 +1,23 @@
////
/**
- *@@@ START COPYRIGHT @@@
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * @@@ END COPYRIGHT @@@
- */
+*@@@ START COPYRIGHT @@@
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* @@@ END COPYRIGHT @@@
+*/
////
[[grant-privileges]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/_chapters/introduction.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/_chapters/introduction.adoc b/docs/spj_guide/src/asciidoc/_chapters/introduction.adoc
index d877409..9881403 100644
--- a/docs/spj_guide/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/spj_guide/src/asciidoc/_chapters/introduction.adoc
@@ -1,23 +1,23 @@
////
/**
- *@@@ START COPYRIGHT @@@
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * @@@ END COPYRIGHT @@@
- */
+*@@@ START COPYRIGHT @@@
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* @@@ END COPYRIGHT @@@
+*/
////
[[introduction]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/_chapters/performance_troubleshooting.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/_chapters/performance_troubleshooting.adoc b/docs/spj_guide/src/asciidoc/_chapters/performance_troubleshooting.adoc
index ed5b4e0..476995c 100644
--- a/docs/spj_guide/src/asciidoc/_chapters/performance_troubleshooting.adoc
+++ b/docs/spj_guide/src/asciidoc/_chapters/performance_troubleshooting.adoc
@@ -1,23 +1,23 @@
////
/**
- *@@@ START COPYRIGHT @@@
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * @@@ END COPYRIGHT @@@
- */
+*@@@ START COPYRIGHT @@@
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* @@@ END COPYRIGHT @@@
+*/
////
[[performance-and-troubleshooting]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/_chapters/sample_database.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/_chapters/sample_database.adoc b/docs/spj_guide/src/asciidoc/_chapters/sample_database.adoc
index db1fd42..f79d8f4 100644
--- a/docs/spj_guide/src/asciidoc/_chapters/sample_database.adoc
+++ b/docs/spj_guide/src/asciidoc/_chapters/sample_database.adoc
@@ -1,23 +1,23 @@
////
/**
- *@@@ START COPYRIGHT @@@
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * @@@ END COPYRIGHT @@@
- */
+*@@@ START COPYRIGHT @@@
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* @@@ END COPYRIGHT @@@
+*/
////
[[b-sample-database]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/_chapters/sample_spjs.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/_chapters/sample_spjs.adoc b/docs/spj_guide/src/asciidoc/_chapters/sample_spjs.adoc
index a22f1a1..1667e4c 100644
--- a/docs/spj_guide/src/asciidoc/_chapters/sample_spjs.adoc
+++ b/docs/spj_guide/src/asciidoc/_chapters/sample_spjs.adoc
@@ -1,23 +1,23 @@
////
/**
- *@@@ START COPYRIGHT @@@
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- * @@@ END COPYRIGHT @@@
- */
+*@@@ START COPYRIGHT @@@
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* @@@ END COPYRIGHT @@@
+*/
////
[[a-sample-spjs]]
@@ -37,7 +37,7 @@ sample name. For example, click on
link:{sourcedir}/Sales.java[Sales.java]
to download the sample sales class source file.
+
-You can access the complete source directory at: http://trafodion.apache.org/docs/spj_guide/resources/source/
+You can access the complete source directory at: {docs-url}/spj_guide/resources/source/
<<<
[[procedures-in-the-sales-schema]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/asciidoc/index.adoc
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/asciidoc/index.adoc b/docs/spj_guide/src/asciidoc/index.adoc
index 6bc14f9..ee0d7ce 100644
--- a/docs/spj_guide/src/asciidoc/index.adoc
+++ b/docs/spj_guide/src/asciidoc/index.adoc
@@ -45,17 +45,10 @@
include::../../shared/license.txt[]
<<<
-include::resources/acknowledgements.txt[]
+include::../../shared/acknowledgements.txt[]
<<<
-*Revision History*
-
-[cols="2",options="header"]
-|===
-| Version | Date
-| 2.0.0 | To be announced.
-| 1.3.0 | January, 2016
-|===
+include::../../shared/revisions.txt[]
include::asciidoc/_chapters/about.adoc[]
include::asciidoc/_chapters/introduction.adoc[]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/spj_guide/src/resources/acknowledgements.txt
----------------------------------------------------------------------
diff --git a/docs/spj_guide/src/resources/acknowledgements.txt b/docs/spj_guide/src/resources/acknowledgements.txt
deleted file mode 100644
index c395596..0000000
--- a/docs/spj_guide/src/resources/acknowledgements.txt
+++ /dev/null
@@ -1,38 +0,0 @@
-*Acknowledgements*
-
-Microsoft�, Windows�, Windows NT�, Windows� XP, and Windows Vista� are
-U.S. registered trademarks of Microsoft Corporation. Intel� and Intel�
-Itanium� are trademarks of Intel Corporation in the U.S. and other
-countries. Java� is a registered trademark of Oracle and/or its
-affiliates. Motif, OSF/1, UNIX�, X/Open�, and the X device is a
-trademark of X/Open Company Ltd. in the UK and other countries.
-
-OSF, OSF/1, OSF/Motif, Motif, and Open Software Foundation are trademarks of
-the Open Software Foundation in the U.S. and other countries.
-� 1990, 1991, 1992, 1993 Open Software Foundation, Inc.
-
-The OSF documentation and the OSF software to which it relates are derived in
-part from materials supplied by the following: � 1987, 1988, 1989
-Carnegie-Mellon University. � 1989, 1990, 1991 Digital Equipment
-Corporation. � 1985, 1988, 1989, 1990 Encore Computer Corporation. � 1988 Free
-Software Foundation, Inc. � 1987, 1988, 1989, 1990, 1991 Hewlett-Packard
-Company. � 1985, 1987, 1988, 1989, 1990, 1991, 1992 International
-Business Machines Corporation. � 1988, 1989 Massachusetts Institute of
-Technology. � 1988, 1989, 1990 Mentat Inc. � 1988 Microsoft Corporation.
-� 1987, 1988, 1989, 1990, 1991,
-1992 SecureWare, Inc. � 1990, 1991 Siemens Nixdorf Informations systeme
-AG. � 1986, 1989, 1996, 1997 Sun Microsystems, Inc. � 1989, 1990, 1991
-Transarc Corporation.
-
-OSF software and documentation are based in part
-on the Fourth Berkeley Software Distribution under license from The
-Regents of the University of California. OSF acknowledges the following
-individuals and institutions for their role in its development: Kenneth
-C.R.C. Arnold, Gregory S. Couch, Conrad C. Huang, Ed James, Symmetric
-Computer Systems, Robert Elz. � 1980, 1981, 1982, 1983, 1985, 1986,
-1987, 1988, 1989 Regents of the University of California. OSF MAKES NO
-WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN,
-INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
-AND FITNESS FOR A PARTICULAR PURPOSE. OSF shall not be liable for errors
-contained herein or for incidental consequential damages in connection
-with the furnishing, performance, or use of this material.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/pom.xml
----------------------------------------------------------------------
diff --git a/docs/sql_reference/pom.xml b/docs/sql_reference/pom.xml
index 6e91e6b..bb51e5b 100644
--- a/docs/sql_reference/pom.xml
+++ b/docs/sql_reference/pom.xml
@@ -187,6 +187,10 @@
<!-- Location of centralized stylesheet -->
<stylesheet>${basedir}/../shared/trafodion-manuals.css</stylesheet>
<project-version>${env.TRAFODION_VER}</project-version>
+ <project-name>Trafodion</project-name>
+ <project-logo>${basedir}/../shared/trafodion-logo.jpg</project-logo>
+ <project-support>user@trafodion.incubator.apache.org</project-support>
+ <docs-url>http://trafodion.incubator.apache.org/docs</docs-url>
<build-date>${maven.build.timestamp}</build-date>
<google-analytics-account>UA-72491210-1</google-analytics-account>
</attributes>
@@ -205,6 +209,10 @@
<outputDirectory>${basedir}/target</outputDirectory>
<attributes>
<project-version>${env.TRAFODION_VER}</project-version>
+ <project-name>Trafodion</project-name>
+ <project-logo>${basedir}/../shared/trafodion-logo.jpg</project-logo>
+ <project-support>user@trafodion.incubator.apache.org</project-support>
+ <docs-url>http://trafodion.incubator.apache.org/docs</docs-url>
<build-date>${maven.build.timestamp}</build-date>
<pdf-stylesdir>${basedir}/../shared</pdf-stylesdir>
<pdf-style>trafodion</pdf-style>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/about.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/about.adoc b/docs/sql_reference/src/asciidoc/_chapters/about.adoc
index 0cc63d6..247e70d 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/about.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/about.adoc
@@ -20,18 +20,18 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[About_This_Document]]
= About This Document
This manual describes reference information about the syntax of SQL statements, functions, and other
-SQL language elements supported by the Trafodion project\u2019s database software.
+SQL language elements supported by the {project-name} project\u2019s database software.
-Trafodion SQL statements and utilities are entered interactively or from script files using a client-based tool,
+{project-name} SQL statements and utilities are entered interactively or from script files using a client-based tool,
such as the Trafodion Command Interface (TrafCI). To install and configure a client application that enables you
-to connect to and use a Trafodion database, see the
-http://trafodion.incubator.apache.org/docs/client_install/index.html[_Trafodion Client Installation Guide_].
+to connect to and use a {project-name} database, see the
+{docs-url}/client_install/index.html[_{project-name} Client Installation Guide_].
NOTE: In this manual, SQL language elements, statements, and clauses within statements are based on the
ANSI SQL:1999 standard.
@@ -39,7 +39,7 @@ ANSI SQL:1999 standard.
[[Intended_Audience]]
== Intended Audience
This manual is intended for database administrators and application programmers who are using SQL to read, update,
-and create Trafodion SQL tables, which map to HBase tables, and to access native HBase and Hive tables.
+and create {project-name} SQL tables, which map to HBase tables, and to access native HBase and Hive tables.
You should be familiar with structured query language (SQL) and with the American National Standard Database Language SQL:1999.
@@ -74,20 +74,20 @@ command through an SQL interface | <<get_hbase_objects_st
[cols="50%,50%",options="header"]
|===
|Chapter or Appendix | Description
-| <<Introduction,Introduction>> | Introduces Trafodion SQL and covers topics such as data consistency,
+| <<Introduction,Introduction>> | Introduces {project-name} SQL and covers topics such as data consistency,
transaction management, and ANSI compliance.
-| <<SQL_Statements,SQL Statements>> | Describes the SQL statements supported by Trafodion SQL.
-| <<SQL_Utilities,SQL Utilities>> | Describes the SQL utilities supported by Trafodion SQL.
+| <<SQL_Statements,SQL Statements>> | Describes the SQL statements supported by {project-name} SQL.
+| <<SQL_Utilities,SQL Utilities>> | Describes the SQL utilities supported by {project-name} SQL.
| <<SQL_Language Elements,SQL Language Elements>> | Describes parts of the language, such as database objects, data types,
-expressions, identifiers, literals, and predicates, which occur within the syntax of Trafodion SQL statements.
-| <<SQL_Clauses,SQL Clauses>> | Describes clauses used by Trafodion SQL statements.
+expressions, identifiers, literals, and predicates, which occur within the syntax of {project-name} SQL statements.
+| <<SQL_Clauses,SQL Clauses>> | Describes clauses used by {project-name} SQL statements.
| <<SQL_Functions_and_Expressions,SQL Functions and Expressions>> | Describes specific functions and expressions that you can use in
-Trafodion SQL statements.
+{project-name} SQL statements.
| <<SQL_Runtime_Statistics,SQL Runtime Statistics>> | Describes how to gather statistics for active queries or for the Runtime
Management System (RMS) and describes the RMS counters that are returned.
| <<OLAP_Functions,OLAP Functions>> | Describes specific on line analytical processing functions.
-| <<Reserved_Words,Appendix A: Reserved Words>> | Lists the words that are reserved in Trafodion SQL.
-| <<Limits,Appendix B: Limits>> | Describes limits in Trafodion SQL.
+| <<Reserved_Words,Appendix A: Reserved Words>> | Lists the words that are reserved in {project-name} SQL.
+| <<Limits,Appendix B: Limits>> | Describes limits in {project-name} SQL.
|===
@@ -218,24 +218,8 @@ match-value [NOT] LIKE _pattern
```
<<<
-== Publishing History
-[cols="2*",options="header"]
-|===
-| Product Version | Publication Date
-| Trafodion Release 1.3.0 | January 2016
-| Trafodion Release 1.1.0 | April 2015
-| Trafodion Release 1.0.0 | January 2015
-| Trafodion Release 0.9.0 Beta | October 2014
-| Trafodion Release 0.8.1 Beta | August 2014
-| Trafodion Release 0.8.0 Beta | June 2014
-|===
-
== Comments Encouraged
-The Trafodion community encourages your comments concerning this document. We are committed to providing documentation that meets your
-needs. Send any errors found, suggestions for improvement, or compliments to:
-
-issues@trafodion.incubator.apache.org
+We encourage your comments concerning this document. We are committed to providing documentation that meets your
+needs. Send any errors found, suggestions for improvement, or compliments to {project-support}.
Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.
-Or, even better, join our community and help us improve our documentation. Please refer to
-http://trafodion.incubator.apache.org/contributing_redirect.html[Trafodion Contributor Guide] for details.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/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 2badda6..b22f498 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/introduction.adoc
@@ -20,25 +20,25 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[introduction]]
= Introduction
-The Trafodion SQL database software allows you to use SQL statements, which comply closely to
-ANSI SQL:1999, to access data in Trafodion SQL tables, which map to HBase tables, and to access
+The {project-name} SQL database software allows you to use SQL statements, which comply closely to
+ANSI SQL:1999, to access data in {project-name} SQL tables, which map to HBase tables, and to access
native HBase tables and Hive tables.
This introduction describes:
* <<sql_language,SQL Language>>
-* <<using_trafodion_sql_to_access_hbase_tables,Using Trafodion SQL to Access HBase Tables>>
-* <<using_trafodion_sql_to_access_hive_tables,Using Trafodion SQL to Access Hive Tables>>
+* <<using_trafodion_sql_to_access_hbase_tables,Using {project-name} SQL to Access HBase Tables>>
+* <<using_trafodion_sql_to_access_hive_tables,Using {project-name} SQL to Access Hive Tables>>
* <<data_consistency_and_access_options,Data Consistency and Access Options>>
* <<transaction_management,Transaction Management>>
-* <<ansi_compliance_and_trafodion_sql_extensions,ANSI Compliance and Trafodion SQL Extensions>>
-* <<trafodion_sql_error_messages,Trafodion SQL Error Messages>>
+* <<ansi_compliance_and_trafodion_sql_extensions,ANSI Compliance and {project-name} SQL Extensions>>
+* <<trafodion_sql_error_messages,{project-name} SQL Error Messages>>
Other sections of this manual describe the syntax and semantics of individual statements, commands, and language elements.
@@ -62,36 +62,36 @@ For information on specific functions and expressions, see:
<<<
[[using_trafodion_sql_to_access_hbase_tables]]
-== Using Trafodion SQL to Access HBase Tables
+== Using {project-name} SQL to Access HBase Tables
-You can use Trafodion SQL statements to read, update, and create HBase tables.
+You can use {project-name} SQL statements to read, update, and create HBase tables.
-* <<initializing_the_trafodion_metadata,Initializing the Trafodion Metadata>>
+* <<initializing_the_trafodion_metadata,Initializing the {project-name} Metadata>>
* <<ways_to_access_hbase_tables,Ways to Access HBase Tables>>
-* <<trafodion_sql_tables_versus_native_hbase_tables,Trafodion SQL Tables Versus Native HBase Tables>>
+* <<trafodion_sql_tables_versus_native_hbase_tables,{project-name} SQL Tables Versus Native HBase Tables>>
* <<supported_sql_statements_with_hbase_tables,Supported SQL Statements With HBase Tables>>
For a list of Control Query Default (CQD) settings for the HBase environment, see the
-http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl[Trafodion Control Query Default (CQD) Reference Guide].
+{docs-url}/cqd_reference/index.hmtl[{project-name} Control Query Default (CQD) Reference Guide].
[[ways_to_access_hbase_tables]]
=== Ways to Access HBase Tables
-Trafodion SQL supports these ways to access HBase tables:
+{project-name} SQL supports these ways to access HBase tables:
-* <<accessing_trafodion_sql_tables,Accessing Trafodion SQL Tables>>
+* <<accessing_trafodion_sql_tables,Accessing {project-name} SQL Tables>>
* <<cell_per_row_access_to_hbase_tables,Cell-Per-Row Access to HBase Tables (Technology Preview)>>
* <<rowwise_access_to_hbase_tables,Rowwise Access to HBase Tables (Technology Preview)>>
<<<
[[accessing_trafodion_sql_tables]]
-==== Accessing Trafodion SQL Tables
+==== Accessing {project-name} SQL Tables
-A Trafodion SQL table is a relational SQL table generated by a `CREATE TABLE` statement and mapped
-to an HBase table. Trafodion SQL tables have regular ANSI names in the catalog `TRAFODION`.
-A Trafodion SQL table name can be a fully qualified ANSI name of the form
+A {project-name} SQL table is a relational SQL table generated by a `CREATE TABLE` statement and mapped
+to an HBase table. {project-name} SQL tables have regular ANSI names in the catalog `TRAFODION`.
+A {project-name} SQL table name can be a fully qualified ANSI name of the form
`TRAFODION._schema-name.object-name_`.
-To access a Trafodion SQL table, specify its ANSI table name in a Trafodion SQL statement, similar
+To access a {project-name} SQL table, specify its ANSI table name in a {project-name} SQL statement, similar
to how you would specify an ANSI table name when running SQL statements in a relational database.
*Example*
@@ -112,8 +112,8 @@ SET SCHEMA trafodion.sales;
SELECT * FROM odetail;
```
-For more information about Trafodion SQL tables, see
-<<trafodion_sql_tables_versus_native_hbase_tables,Trafodion SQL Tables Versus Native HBase Tables>>.
+For more information about {project-name} SQL tables, see
+<<trafodion_sql_tables_versus_native_hbase_tables,{project-name} SQL Tables Versus Native HBase Tables>>.
<<<
[[cell_per_row_access_to_hbase_tables]]
@@ -124,7 +124,7 @@ 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
-it was created through Trafodion SQL.
+it was created through {project-name} SQL.
*Example*
@@ -158,7 +158,7 @@ complete but has not been tested or debugged.
To access HBase data using rowwise mode, specify the schema `HBASE."_ROW_"` 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
-it was created through Trafodion SQL.
+it was created through {project-name} SQL.
*Example*
@@ -182,9 +182,9 @@ PRIMARY KEY (ROW_ID)
<<<
[[trafodion_sql_tables_versus_native_hbase_tables]]
-=== Trafodion SQL Tables Versus Native HBase Tables
+=== {project-name} SQL Tables Versus Native HBase Tables
-Trafodion SQL tables have many advantages over regular HBase tables:
+{project-name} SQL tables have many advantages over regular HBase tables:
* They can be made to look like regular, structured SQL tables with fixed columns.
* They support the usual SQL data types supported in relational databases.
@@ -194,7 +194,7 @@ Trafodion SQL tables have many advantages over regular HBase tables:
key prefix to avoid hot spots for sequential keys. For the syntax,
see the <<create_table_statement,CREATE TABLE Statement>>.
-The problem with Trafodion SQL tables is that they use a fixed format to represent column values,
+The problem with {project-name} SQL tables is that they use a fixed format to represent column values,
making it harder for native HBase applications to access them. Also, they have a fixed structure,
so users lose the flexibility of dynamic columns that comes with HBase.
@@ -216,24 +216,24 @@ You can use these SQL statements with HBase tables:
<<<
[[using_trafodion_sql_to_access_hive_tables]]
-== Using Trafodion SQL to Access Hive Tables
+== Using {project-name} SQL to Access Hive Tables
-You can use Trafodion SQL statements to access Hive tables.
+You can use {project-name} SQL statements to access Hive tables.
* <<ansi_names_for_hive_tables,ANSI Names for Hive Tables>>
-* <<type_mapping_from_hive_to_trafodion_sql,Type Mapping From Hive to Trafodion SQL>>
+* <<type_mapping_from_hive_to_trafodion_sql,Type Mapping From Hive to {project-name} SQL>>
* <<supported_sql_statements_with_hive_tables,Supported SQL Statements With Hive Tables>>
For a list of Control Query Default (CQD) settings for the Hive environment, see the
-http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl[Trafodion Control Query Default (CQD) Reference Guide].
+{docs-url}/cqd_reference/index.hmtl[{project-name} Control Query Default (CQD) Reference Guide].
[[ansi_names_for_hive_tables]]
=== ANSI Names for Hive Tables
-Hive tables appear in the Trafodion Hive ANSI name space in a special catalog and schema named `HIVE.HIVE`.
+Hive tables appear in the {project-name} Hive ANSI name space in a special catalog and schema named `HIVE.HIVE`.
To select from a Hive table named `T`, specify an implicit or explicit name, such as `HIVE.HIVE.T`,
-in a Trafodion SQL statement.
+in a {project-name} SQL statement.
*Example*
This example should work if a Hive table named `T` has already been defined:
@@ -252,13 +252,13 @@ select * from hive.hive.t; -- explicit table name
<<<
[[type_mapping_from_hive_to_trafodion_sql]]
-=== Type Mapping From Hive to Trafodion SQL
+=== Type Mapping From Hive to {project-name} SQL
-Trafodion performs the following data-type mappings:
+{project-name} performs the following data-type mappings:
[cols="2*",options="header"]
|===
-| Hive Type | Trafodion SQL Type
+| Hive Type | {project-name} SQL Type
| `tinyint` | `smallint`
| `smallint` | `smallint`
| `int` | `int`
@@ -270,8 +270,8 @@ Trafodion performs the following data-type mappings:
|===
1. The value `_n_` is determined by `CQD HIVE_MAX_STRING_LENGTH`. See the
-http://trafodion.incubator.apache.org/docs/cqd_reference/index.hmtl[Trafodion Control Query Default (CQD) Reference Guide].
-2. Hive supports timestamps with nanosecond resolution (precision of 9). Trafodion SQL supports only microsecond resolution (precision 6).
+{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).
[[supported_sql_statements_with_hive_tables]]
=== Supported SQL Statements With Hive Tables
@@ -354,15 +354,15 @@ Transactions you define are called _user-defined transactions_. To be sure that
successfully or not at all, you can define one transaction consisting of these statements by using the BEGIN WORK
statement and COMMIT WORK statement. You can abort a transaction by using the ROLLBACK WORK statement.
-If AUTOCOMMIT is on, then you do not have to end the transaction explicitly as Trafodion SQL will end the transaction
-automatically. Sometimes an error occurs that requires the user-defined transaction to be aborted. Trafodion SQL
+If AUTOCOMMIT is on, then you do not have to end the transaction explicitly as {project-name} SQL will end the transaction
+automatically. Sometimes an error occurs that requires the user-defined transaction to be aborted. {project-name} SQL
will automatically abort the transaction and return an error indicating that the transaction was rolled back.
<<<
[[system_defined_transactions]]
==== System-Defined Transactions
-In some cases, Trafodion SQL defines transactions for you. These transactions are called _system-defined transactions_.
+In some cases, {project-name} SQL defines transactions for you. These transactions are called _system-defined transactions_.
Most DML statements initiate transactions implicitly at the start of execution.
See <<implicit_transactions,Implicit Transactions>>.
@@ -377,11 +377,11 @@ If deadlock occurs, the DML statement times out and receives an error.
[[effect_of_autocommit_option]]
=== Effect of AUTOCOMMIT Option
-AUTOCOMMIT is an option that can be set in a SET TRANSACTION statement. It specifies whether Trafodion SQL will commit
+AUTOCOMMIT is an option that can be set in a SET TRANSACTION statement. It specifies whether {project-name} SQL will commit
automatically, or roll back if an error occurs, at the end of statement execution. This option applies to any statement
for which the system initiates a transaction. See <<set_transaction_statement,SET TRANSACTION Statement>>.
-If this option is set to ON, Trafodion SQL automatically commits any changes, or rolls back any changes, made to the
+If this option is set to ON, {project-name} SQL automatically commits any changes, or rolls back any changes, made to the
database at the end of statement execution.
[[concurrency]]
@@ -392,7 +392,7 @@ available — whether a process that requests access to data that is already
in a wait queue — depends on the purpose of the access mode (read or update) and the isolation level. Currently, the only
isolation level is READ COMMITTED.
-Trafodion SQL provides concurrent database access for most operations and controls database access through concurrency
+{project-name} SQL provides concurrent database access for most operations and controls database access through concurrency
control and the mechanism for opening and closing tables. For DML operations, the access option affects the degree of
concurrency. See <<data_consistency_and_access_options,Data Consistency and Access Options>>.
@@ -417,17 +417,17 @@ The default isolation level is READ COMMITTED.
<<<
[[ansi_compliance_and_trafodion_sql_extensions]]
-== ANSI Compliance and Trafodion SQL Extensions
+== ANSI Compliance and {project-name} SQL Extensions
-Trafodion SQL complies most closely with Core SQL 99. Trafodion SQL also includes some features from SQL 99 and part of
-the SQL 2003 standard, and special Trafodion SQL extensions to the SQL language.
+{project-name} SQL complies most closely with Core SQL 99. {project-name} SQL also includes some features from SQL 99 and part of
+the SQL 2003 standard, and special {project-name} SQL extensions to the SQL language.
-Statements and SQL elements in this manual are ANSI compliant unless specified as Trafodion SQL extensions.
+Statements and SQL elements in this manual are ANSI compliant unless specified as {project-name} SQL extensions.
[[ansi_compliant_statements]]
=== ANSI-Compliant Statements
-These statements are ANSI compliant, but some might contain Trafodion SQL extensions:
+These statements are ANSI compliant, but some might contain {project-name} SQL extensions:
|===
| <<alter_table_statement,ALTER TABLE Statement>> | <<call_statement,CALL Statement>>
@@ -450,9 +450,9 @@ These statements are ANSI compliant, but some might contain Trafodion SQL extens
<<<
[[statements_that_are_trafodion_sql_extensions]]
-=== Statements That Are Trafodion SQL Extensions
+=== Statements That Are {project-name} SQL Extensions
-These statements are Trafodion SQL extensions to the ANSI standard.
+These statements are {project-name} SQL extensions to the ANSI standard.
|===
| <<alter_library_statement,ALTER LIBRARY Statement>> | <<alter_user_statement,ALTER USER Statement>>
@@ -475,7 +475,7 @@ These statements are Trafodion SQL extensions to the ANSI standard.
[[ansi_compliant_functions]]
=== ANSI-Compliant Functions
-These functions are ANSI compliant, but some might contain Trafodion SQL extensions:
+These functions are ANSI compliant, but some might contain {project-name} SQL extensions:
|===
| <<avg,AVG function>> | <<case, CASE expression>>
@@ -492,16 +492,16 @@ These functions are ANSI compliant, but some might contain Trafodion SQL extensi
| <<upper,UPPER>>
|===
-All other functions are Trafodion SQL extensions.
+All other functions are {project-name} SQL extensions.
-== Trafodion SQL Error Messages
+== {project-name} SQL Error Messages
-Trafodion SQL reports error messages and exception conditions. When an error condition occurs,
-Trafodion SQL returns a message number and a brief description of the condition.
+{project-name} SQL reports error messages and exception conditions. When an error condition occurs,
+{project-name} SQL returns a message number and a brief description of the condition.
*Example*
-Trafodion SQL might display this error message:
+{project-name} SQL might display this error message:
```
*** ERROR[1000] A syntax error occurred.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/limits.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/limits.adoc b/docs/sql_reference/src/asciidoc/_chapters/limits.adoc
index 27af6d0..5bbe2f4 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/limits.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/limits.adoc
@@ -20,13 +20,13 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[limits]]
= Limits
-This section lists limits for various parts of Trafodion SQL.
+This section lists limits for various parts of {project-name} SQL.
[cols="30%h,70%"]
|===
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
index e01b45b..8923214 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
@@ -20,19 +20,18 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
-<<<
[[olap_functions]]
-=== OLAP Functions
+= OLAP Functions
This section describes the syntax and semantics of the On Line
Analytical Process (OLAP) window functions. The OLAP window functions
are ANSI compliant.
[[considerations_for_window_functions]]
-=== Considerations for Window Functions
+== Considerations for Window Functions
These considerations apply to all window functions.
@@ -63,7 +62,7 @@ CURRENT ROW".
"ROWS _preceding-row_" is equivalent to "ROWS BETWEEN _preceding-row_
AND CURRENT ROW".
-==== Nulls
+=== Nulls
All nulls are eliminated before the function is applied to the set of
values. If the window contains all NULL values, the result of the window
@@ -136,7 +135,7 @@ GROUP BY num, workgroupnum, annualsalary;
These limitations apply to all window functions.
-* The ANSI _window-clause_ is not supported by Trafodion. Only the
+* The ANSI _window-clause_ is not supported by {project-name}. Only the
_inline-window-specification_ is supported. An attempt to use an ANSI
_window-clause_ will result in a syntax error.
@@ -149,10 +148,10 @@ term, either explicitly or implicitly will result in the "4343" error
message.
* The window frame units can only be ROWS. RANGE is not supported by
-Trafodion. An attempt to use RANGE will result in a syntax error.
+{project-name}. An attempt to use RANGE will result in a syntax error.
* The ANSI _window-frame-exclusion-specification_ is not supported by
-Trafodion. An attempt to use a _window-frame-exclusion-specification_
+{project-name}. An attempt to use a _window-frame-exclusion-specification_
will result in a syntax error.
* Multiple _inline-window-specifications_ in a single SELECT clause are
@@ -163,13 +162,13 @@ _inline-window-specifications_ in a single SELECT clause will result in
the "4340" error message.
* The ANSI _null-ordering-specification_ within the ORDER BY clause is
-not supported by Trafodion. Null values will always be sorted as if they
+not supported by {project-name}. Null values will always be sorted as if they
are greater than all non-null values. This is slightly different than a
null ordering of NULLS LAST. An attempt to use a
_null-ordering-specification_ will result in a syntax error.
* The ANSI _filter-clause_ is not supported for window functions by
-Trafodion. The _filter-clause_ applies to all aggregate functions
+{project-name}. The _filter-clause_ applies to all aggregate functions
(grouped and windowed) and that the _filter-clause_ is not currently
supported for grouped aggregate functions. An attempt to use a
_filter-clause_ will result in a syntax error.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc b/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
index 478a2e5..0362601 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
@@ -20,23 +20,22 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
-<<<
[[reserved_words]]
= Reserved Words
-The words listed in this appendix are reserved for use by Trafodion SQL.
+The words listed in this appendix are reserved for use by {project-name} SQL.
To prevent syntax errors, avoid using these words as identifiers in
-Trafodion SQL. In Trafodion SQL, if an operating system name contains a
+{project-name} SQL. In {project-name} SQL, if an operating system name contains a
reserved word, you must enclose the reserved word in double quotes (")
to access that column or object.
-NOTE: In Trafodion SQL, ABSOLUTE, DATA, EVERY, INITIALIZE, OPERATION,
+NOTE: In {project-name} SQL, ABSOLUTE, DATA, EVERY, INITIALIZE, OPERATION,
PATH, SPACE, STATE, STATEMENT, STATIC, and START are not reserved words.
-Trafodion SQL treats these words as reserved when they are part of
-Trafodion SQL stored text. They cannot be used as identifiers unless you
+{project-name} SQL treats these words as reserved when they are part of
+{project-name} SQL stored text. They cannot be used as identifiers unless you
enclose them in double quotes.
[[reserved_sql_identifiers_a]]
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/runtime_stats.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/runtime_stats.adoc b/docs/sql_reference/src/asciidoc/_chapters/runtime_stats.adoc
index 56dc11d..6f1e17d 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/runtime_stats.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/runtime_stats.adoc
@@ -20,15 +20,14 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
-<<<
[[sql_runtime_statistics]]
= SQL Runtime Statistics
The Runtime Management System (RMS) shows the status of queries while
-they are running. RMS can service on-demand requests from the Trafodion
+they are running. RMS can service on-demand requests from the {project-name}
Command Interface (TrafCI) to get statistics for a given query ID or for
active queries in a given process. RMS also provides information about
itself to determine the health of the RMS infrastructure.
@@ -1089,7 +1088,7 @@ provided for each node.
[cols="30%l,70%",options="header"]
|===
| Counter | Description
-| CPU | The node number of the Trafodion cluster.
+| CPU | The node number of the {project-name} cluster.
| RMS Version | Internal version of RMS.
| SSCP PID | SQL Statistics control process ID.
| SSCP Creation Timestamp | Actual timestamp when SQL statistics control process was created.
@@ -1102,7 +1101,7 @@ provided for each node.
| No. of Process Regd. | Number of processes registered in the shared segment.
| No. of Query Fragments Regd. | Number of query fragments registered in the shared segment.
| RMS Semaphore Owner | Process ID that locked the semaphore at this instance of time.
-| No. of SSCPs Opened | Number of Statistics Control Processes opened. Normally, this should be equal to the number of nodes in the Trafodion cluster.
+| No. of SSCPs Opened | Number of Statistics Control Processes opened. Normally, this should be equal to the number of nodes in the {project-name} cluster.
| No. of SSCPs Open Deleted | Number of Statistics Control Processes with broken communication. Usually, this should be 0.
| Last GC Time | The recent timestamp at which the shared segment was garbage collected.
| Queries GCed in Last Run | Number of queries that were garbage collected in the recent GC run.
@@ -1184,8 +1183,8 @@ these parts of the query ID:
[cols="30%l,70%",options="header"]
|===
| Attribute Value | Description
-| SEGMENTNUM | Logical node ID in Trafodion cluster
-| CPUNUM or CPU | Logical node ID in Trafodion cluster
+| SEGMENTNUM | Logical node ID in {project-name} cluster
+| CPUNUM or CPU | Logical node ID in {project-name} cluster
| PIN | Linux process ID number
| EXESTARTTIME | Executor start time
| SESSIONNUM | Session number
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc
index 7ae2973..dbe39a3 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc
@@ -20,13 +20,13 @@
* under the License.
*
* @@@ END COPYRIGHT @@@
- */
+*/
////
[[sql_clauses]]
= SQL Clauses
-Clauses are used by Trafodion SQL statements to specify default values,
+Clauses are used by {project-name} SQL statements to specify default values,
ways to sample or sort data, how to store physical data, and other
details.
@@ -318,7 +318,7 @@ statement. The intermediate result table consists of the rows returned
by a WHERE clause or, if no WHERE clause exists, the FROM clause. See
<<select_statement,SELECT Statement>>.
-SAMPLE is a Trafodion SQL extension.
+SAMPLE is a {project-name} SQL extension.
```
SAMPLE sampling-methodis:
@@ -346,7 +346,7 @@ rows-size is:
* `RANDOM _percent-size_`
+
-directs Trafodion SQL to choose rows randomly (each row having an
+directs {project-name} SQL to choose rows randomly (each row having an
unbiased probability of being chosen) without replacement from the
result table. The sampling size is determined by the _percent-size_,
defined as:
@@ -366,7 +366,7 @@ Therefore, the actual size of the resulting sample is approximately _r_% of _N_.
The number of rows picked follows a binomial distribution with
mean equal to _r_ *c_N_/100.
+
-If you specify a sample size greater than 100 PERCENT, Trafodion SQL
+If you specify a sample size greater than 100 PERCENT, {project-name} SQL
returns all the rows in the result table plus duplicate rows. The
duplicate rows are picked from the result table according to the
specified sampling method. This technique is called oversampling.
@@ -377,7 +377,7 @@ specifies row sampling. Row sampling is the default.
** `BALANCE`
+
-If you specify a BALANCE expression, Trafodion SQL performs stratified
+If you specify a BALANCE expression, {project-name} SQL performs stratified
sampling. The intermediate result table is divided into disjoint strata
based on the WHEN conditions.
+
@@ -389,8 +389,8 @@ no true condition exists, the row belongs to the ELSE stratum.
* `FIRST _rows-size_ [SORT BY _colname_ [ASC[ENDING] | DESC[ENDING]]
[,_colname_ [ASC[ENDING] | DESC[ENDING]]]…]`
+
-directs Trafodion SQL to choose the first rows from the result table.
-You can specify the order of the rows to sample. Otherwise, Trafodion
+directs {project-name} SQL to choose the first rows from the result table.
+You can specify the order of the rows to sample. Otherwise, {project-name}
SQL chooses an arbitrary order. The sampling size is determined by the
_rows-size_, defined as:
@@ -410,13 +410,13 @@ is the minimum of _s_ and _N_.
[ASC[ENDING] | DESC[ENDING]] [,_colname_ [ASC[ENDING] |
DESC[ENDING]]]…]`
+
-directs Trafodion SQL to choose the first rows from each block (or
+directs {project-name} SQL to choose the first rows from each block (or
period) of contiguous rows. This sampling method is equivalent to a
separate FIRST sampling for each period, and the _rows-size_ is defined
as in FIRST sampling.
+
The size of the period is specified as a number of rows. You can specify
-the order of the rows to sample. Otherwise, Trafodion SQL chooses an
+the order of the rows to sample. Otherwise, {project-name} SQL chooses an
arbitrary order.
+
<<<
@@ -786,7 +786,7 @@ of the intermediate result table for calculating sequence functions.
This option is used for processing time-sequenced rows in data mining
applications. See <<select_statement>>.
-Sequence by is a Trafodion SQL extension.
+Sequence by is a {project-name} SQL extension.
```
SEQUENCE BY colname[ASC[ENDING]|DESC[ENDING]]
@@ -807,7 +807,7 @@ considered equal to one another but greater than all other non-null
values.
+
You must include a SEQUENCE BY clause if you include a sequence function
-in the select list of the SELECT statement. Otherwise, Trafodion SQL
+in the select list of the SELECT statement. Otherwise, {project-name} SQL
returns an error. Further, you cannot include a SEQUENCE BY clause if no
sequence function exists in the select list. See
<<sequence_functions,Sequence Functions>> .
@@ -1001,7 +1001,7 @@ The result table of the TRANSPOSE clause has all the columns of the
source table plus, for each transpose item list, a value column or
columns and an optional key column.
-TRANSPOSE is a Trafodion SQL extension.
+TRANSPOSE is a {project-name} SQL extension.
```
TRANSPOSE transpose-set [transpose-set]...