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>u...@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>u...@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âs database software. +SQL language elements supported by the {project-name} projectâs 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: - -iss...@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]...
