http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/tables_indexes.adoc ---------------------------------------------------------------------- diff --git a/docs/load_transform/src/asciidoc/_chapters/tables_indexes.adoc b/docs/load_transform/src/asciidoc/_chapters/tables_indexes.adoc index a9f8f78..71de384 100644 --- a/docs/load_transform/src/asciidoc/_chapters/tables_indexes.adoc +++ b/docs/load_transform/src/asciidoc/_chapters/tables_indexes.adoc @@ -20,7 +20,7 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// [[tables-indexes]] @@ -31,13 +31,13 @@ The following guidance helps you set up your tables and indexes for better load [[choose-primary-key]] == Choose Primary Key -The primary key for a Trafodion table must be chosen based on the workload that accesses the table. +The primary key for a {project-name} table must be chosen based on the workload that accesses the table. -Keyed access to Trafodion tables is very efficient since HBase is a key-value store. You need to analyze the queries +Keyed access to {project-name} tables is very efficient since HBase is a key-value store. You need to analyze the queries that are used to access the tables to understand their predicates and join conditions. Once identified, you can choose a primary key that ensures that the leading key columns have highly selective predicates applied to them. -This technique limits the number of rows that need to scanned in the HBase. Trafodion uses MDAM (Multi Dimensional Access Method) to limit +This technique limits the number of rows that need to scanned in the HBase. {project-name} uses MDAM (Multi Dimensional Access Method) to limit the rows scanned when predicates are present to only trailing key columns and not the leading key column. MDAM works best when the unique entry count of leading key columns (on which predicates are absent) is low. @@ -47,7 +47,7 @@ unique entry count of leading key columns (on which predicates are absent) is lo With range partitioned data in some workloads, certain key ranges of data may see more access than other key ranges. This can lead to an unbalanced usage pattern with some HBase RegionServers handling most of the load. This behavior is referred to as "hot-spotting." -With Native HBase tables, hot-spotting is often addressed by designing appropriate keys. In Trafodion, once you choose the key to a table, as +With Native HBase tables, hot-spotting is often addressed by designing appropriate keys. In {project-name}, once you choose the key to a table, as discussed in <<choose-primary-key,Choose Primary Key>>, you can use *salting* to distribute the data evenly. Salting applies a hash function to the salt keys and distributes data to partitions based on this hash value. The hash value is physically stored in the table as the leading key value. Each split of the table will have only one salt key value. @@ -61,13 +61,13 @@ cluster and the expected size of the table. A salted table can split if more dat happens, then more than one partition having rows with the same salt value, which may result in suboptimal execution plans for the table. <<< -You can also choose not to salt Trafodion tables. This is similar to range partitioning in a traditional database. The number of partitions +You can also choose not to salt {project-name} tables. This is similar to range partitioning in a traditional database. The number of partitions grows with the size of the table, and range boundaries are determined by HBase based on the specified split policy. [[compression-encoding]] == Compression and Encoding -Large Trafodion tables must be encoded and compressed. Trafodion tables that have a large key or several columns grow in size to 10X or more +Large {project-name} tables must be encoded and compressed. {project-name} tables that have a large key or several columns grow in size to 10X or more when compared to a Hive table with equivalent data since HBase stores the key separately for every column in a row. HBase provides several types of encoding to avoid storing the same key value to disk for every column in the row. HBase also supports various @@ -80,7 +80,7 @@ determine the best compression technique for your tables. [[create-trafodion-tables-and-indexes]] == Create Tables and Indexes -Create Trafodion tables using the CREATE TABLE statements with the `SALT USING <num> PARTITIONS` clause for salting and +Create {project-name} tables using the CREATE TABLE statements with the `SALT USING <num> PARTITIONS` clause for salting and the `HBASE_OPTIONS` clause for compression and encoding. *Example* @@ -114,10 +114,10 @@ SALT LIKE TABLE; == Update Statistics -To generate good plans that allow queries to execute quickly and use resources wisely, the Trafodion Optimizer must have a good idea about how the -values of columns are distributed, the number of distinct values, and so on. Trafodion supplies this information to the optimizer in the +To generate good plans that allow queries to execute quickly and use resources wisely, the {project-name} Optimizer must have a good idea about how the +values of columns are distributed, the number of distinct values, and so on. {project-name} supplies this information to the optimizer in the form of histograms generated by executing the UPDATE STATISTICS statement. See the -http://trafodion.apache.org/docs/sql_reference/index.html#update_statistics_statement[Trafodion SQL Reference Manual] for a full +{docs-url}/sql_reference/index.html#update_statistics_statement[{project-name} SQL Reference Manual] for a full description of this statement. === Default Sampling @@ -174,7 +174,7 @@ PREPARE s FROM SELECT...; ``` The value of the CQD USTAT_AUTOMATION_INTERVAL is intended to determine the automation interval (in minutes) for update statistics -automation. The PREPARE statement causes the Trafodion Compiler to compile and optimize a query without executing it. In the process +automation. The PREPARE statement causes the {project-name} Compiler to compile and optimize a query without executing it. In the process of doing so with automation enabled, any histograms needed by the optimizer that are missing causes those columns to be marked as needing histograms. Then, the following UPDATE STATISTICS statement can be run against each table to generate the needed histograms:
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/trickle_load.adoc ---------------------------------------------------------------------- diff --git a/docs/load_transform/src/asciidoc/_chapters/trickle_load.adoc b/docs/load_transform/src/asciidoc/_chapters/trickle_load.adoc index 8ab3964..9f2ef91 100644 --- a/docs/load_transform/src/asciidoc/_chapters/trickle_load.adoc +++ b/docs/load_transform/src/asciidoc/_chapters/trickle_load.adoc @@ -20,19 +20,19 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// [[trickle-load]] = Trickle Load -Trafodion Trickle Load allows data to be committed in batches, with sizes ranging from 1 row to a several +{project-name} Trickle Load allows data to be committed in batches, with sizes ranging from 1 row to a several thousand rows in each commit. Trickle Load uses the following SQL statements (defined in the -http://trafodion.incubator.apache.org/docs/sql_reference/index.html[Trafodion SQL Reference Manual]: +{docs-url}/sql_reference/index.html[{project-name} SQL Reference Manual]: -* http://trafodion.incubator.apache.org/docs/sql_reference/index.html#insert_statement[INSERT] -* http://trafodion.apache.org/docs/sql_reference/index.html#upsert_statement[UPSERT] -* http://trafodion.apache.org/docs/sql_reference/index.html#upsert_statement[UPSERT USING LOAD] +* {docs-url}/sql_reference/index.html#insert_statement[INSERT] +* {docs-url}/sql_reference/index.html#upsert_statement[UPSERT] +* {docs-url}/sql_reference/index.html#upsert_statement[UPSERT USING LOAD] Contrary to <<bulk-load,Bulk Load>>, committed rows are immediately visible from other transactions thereby leading to minimal latency in making newly ingested rows visible to applications and end users. @@ -44,12 +44,12 @@ application for this approach. * You want to migrate a smaller amount of data (a few millions rows). Typically, you use JDBC- or ODBC-based ETL tools for this approach; for example: -** <<trickle-load-odb,Trafodion odb^1^>> +** <<trickle-load-odb,{project-name} odb^1^>> ** http://squirrel-sql.sourceforge.net[SQuirrel-SQL] ** http://www.pentaho.com/[Pentaho] ** http://www.informatica.com/us/[Informatica]. -^1^ Trafodion obd typically achieves better load throughput than third-party ETL tools. +^1^ {project-name} obd typically achieves better load throughput than third-party ETL tools. [[trickle-load-improving-throughput]] == Improving Throughput @@ -76,7 +76,7 @@ the `hbase shell` through an `ALTER 'TRAFODION.<schema-name>.<table-name>', MEMS [[trickle-load-odb]] == odb -odb is a Linux and Windows Trafodion client that is: +odb is a Linux and Windows {project-name} client that is: * ODBC based * Database agnostic query driver @@ -85,7 +85,7 @@ odb is a Linux and Windows Trafodion client that is: odb may be installed on: -* The Trafodion cluster. +* The {project-name} cluster. * The machine that contains source data * An intermediate machine that is being used for data loading. @@ -96,7 +96,7 @@ odd uses threads to achieve parallelism, rowsets to improve throughput. You can insert types. NOTE: odb does not use the bulk load command LOAD, and, therefore, throughput when using odb may be lower than what can be achieved -with the bulk loader. However, when using the odb tool, source data need not be moved to the Trafodion cluster in a separate step. +with the bulk loader. However, when using the odb tool, source data need not be moved to the {project-name} cluster in a separate step. odb allows you to access Hadoop data using one of the following methods: @@ -114,7 +114,7 @@ The following odb commands/features are discussed in this guide: * <<trickle-load-odb-extract, odb Extract>> * <<trickle-load-odb-transform, odb Transform>> -See the http://trafodion.incubator.apache.org/docs/odb/index.html[Trafodion odb User Guide] +See the {docs-url}/odb/index.html[{project-name} odb User Guide] for installation instructions and usage syntax for the odb tool. The following subsections assume that you've installed odb. @@ -131,7 +131,7 @@ The default insert type used by odb is INSERT; to use UPSERT USING LOAD, please Copy the table `mytable` from `<source_catalog>.<source_schema>` on the source database to `trafodion.my schema.mytable` -on Trafodion. +on {project-name}. ``` odb64luo -u <src_username>:<tgt_username> -p <src_pswd>:<tgt_pswd> @@ -146,19 +146,19 @@ odb64luo -u <src_username>:<tgt_username> -p <src_pswd>:<tgt_pswd> | `src_username` | User name for the source database. | `src_pswd` | Password for the source database. | `src_dsn` | ODBC DSN for the source database. -| `tgt_username` | User name for the Trafodion database. -| `tgt_pswd` | Password for the Trafodion database. -| `tgt_dsn` | ODBC DSN for the Trafodion database. +| `tgt_username` | User name for the {project-name} database. +| `tgt_pswd` | Password for the {project-name} database. +| `tgt_dsn` | ODBC DSN for the {project-name} database. | `splitby` | Defines the column used to evenly distributed values for parallelism. Consider using a leading key column. -| `parallel=4` | Use four connections to extract data from the source database and another four connections to write data to the target Trafodion database. +| `parallel=4` | Use four connections to extract data from the source database and another four connections to write data to the target {project-name} database. | `loadcmd=UL` | Use UPSERT USING LOAD syntax to write data. |=== [[trickle-load-odb-load]] === odb Load -Refer to the http://trafodion.apache.org/docs/odb/index.html#_load_files[Load Files] section -in the http://trafodion.apache.org/docs/odb/index.html[Trafodion odb User Guide] for complete +Refer to the {docs-url}/odb/index.html#_load_files[Load Files] section +in the {docs-url}/odb/index.html[{project-name} odb User Guide] for complete documentation of this option. You use the `-l` option to load into a table from: @@ -237,10 +237,10 @@ odb64luo -u user -p xx -d dsn -T 5 \ === odb Copy Refer to the -http://trafodion.apache.org/docs/odb/index.html#_copy_tables_from_one_database_to_another[Copy Tables From One Database to Another] -section in the http://trafodion.apache.org/docs/odb/index.html[Trafodion odb User Guide] for complete documentation of this option. +{docs-url}/odb/index.html#_copy_tables_from_one_database_to_another[Copy Tables From One Database to Another] +section in the {docs-url}/odb/index.html[{project-name} odb User Guide] for complete documentation of this option. -Use the `-cp` option to copy tables *directly* from one data-source to another using ODBC (for example, from Trafodion to Teradata +Use the `-cp` option to copy tables *directly* from one data-source to another using ODBC (for example, from {project-name} to Teradata or vice-versa): * Single/Multiple table(s) copy from one database to another @@ -324,8 +324,8 @@ src=TRAFODION.MAURIZIO.LINEITEM:splitby=L_PARTKEY [[trickle-load-odb-extract]] === odb Extract -Refer to the http://trafodion.apache.org/docs/odb/index.html#_extract_tables[Extract Tables] -section in the http://trafodion.apache.org/docs/odb/index.html[Trafodion odb User Guide] for complete documentation of this option. +Refer to the {docs-url}/odb/index.html#_extract_tables[Extract Tables] +section in the {docs-url}/odb/index.html[{project-name} odb User Guide] for complete documentation of this option. Use then -e option to extract from data a table and write it to standard files or named pipes. @@ -412,8 +412,8 @@ appending extraction data and time (`_%d%m`) for the target file name. [[trickle-load-odb-transform]] === odb Transform -Refer to the http://trafodion.apache.org/docs/odb/index.html#load_map_fields[Map Source File Fields to Target Table Columns] -section in the http://trafodion.apache.org/docs/odb/index.html[Trafodion odb User Guide] for complete documentation of +Refer to the {docs-url}/odb/index.html#load_map_fields[Map Source File Fields to Target Table Columns] +section in the {docs-url}/odb/index.html[{project-name} odb User Guide] for complete documentation of odb's mapping/transformation capabilities. odb provides mapping/transformation capabilities though mapfiles. By specifying `map=<mapfile>` load option you can: @@ -491,6 +491,6 @@ $ odb64luo -u user -p xx -d dsn \ The above example: * Reads data from `friends.dat` (`src`). -* Writes data to the `TRAFODION.MFTEST.FRIENDS` Trafodion table (`tgt`). +* Writes data to the `TRAFODION.MFTEST.FRIENDS` {project-name} table (`tgt`). * Uses `ml1.map` to define transformation specifications (`map`). * Uses comma as a field separator (`fs`). http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/_chapters/troubleshoot.adoc ---------------------------------------------------------------------- diff --git a/docs/load_transform/src/asciidoc/_chapters/troubleshoot.adoc b/docs/load_transform/src/asciidoc/_chapters/troubleshoot.adoc index 77624ec..1d8f446 100644 --- a/docs/load_transform/src/asciidoc/_chapters/troubleshoot.adoc +++ b/docs/load_transform/src/asciidoc/_chapters/troubleshoot.adoc @@ -20,7 +20,7 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// [[troubleshoot]] @@ -56,7 +56,7 @@ SELECT MAX(LENGTH(<col-name>)) FROM <hive-tab-name>; If the query returns a value less than the current HIVE_MAX_STRING_LENGTH, then you need to increase that value and retry. If the query returns a value that is far less than the current HIVE_MAX_STRING_LENGTH, then you can achieve better performance by reducing the value. -An approximate value can be used, too. The Trafodion default of 32000 may be too generous in some cases. +An approximate value can be used, too. The {project-name} default of 32000 may be too generous in some cases. == Checking Plan Quality @@ -64,7 +64,7 @@ It is good practice to check the quality of the plan generated by the SQL compil data loading statement that may take a long time to complete. * For INSERT and UPSERT USING LOAD statements, use the EXPLAIN statement, which is described in the -http://trafodion.apache.org/docs/sql_reference/index.html#explain_statement[Trafodion SQL Reference Manual]. +{docs-url}/sql_reference/index.html#explain_statement[{project-name} SQL Reference Manual]. * For the LOAD statement, which is implemented as a utility operator (that is, a collection of secondary SQL statements), use the following SQL statements to see the plan that it uses to add data to the target table: @@ -74,8 +74,8 @@ PREPARE s1 FROM LOAD TRANSFORM INTO <target-table> <select-query-used-as-source> EXPLAIN OPTIONS 'f' s1 ; ``` -A typical problem with the plan is that the scan is not parallel enough. For Trafodion tables, you can address this -issue with the default attribute, PARALLEL_NUM_ESPS. Using this attribute, a Trafodion scan can be parallelized to +A typical problem with the plan is that the scan is not parallel enough. For {project-name} tables, you can address this +issue with the default attribute, PARALLEL_NUM_ESPS. Using this attribute, a {project-name} scan can be parallelized to as many number of SALT partitions that are defined for the table. For Hive source tables, the default attributes, HIVE_NUM_ESPS_PER_DATANODE and HIVE_MIN_BYTES_PER_ESP_PARTITION, can be used to adjust the degree of parallelism. @@ -106,12 +106,12 @@ UPDATE STATISTICS FOR TABLE t ON EVERY COLUMN SAMPLE RANDOM 1 PERCENT; == Index Creation Takes Too Long -When creating an index, all rows of the Trafodion table must be scanned and a subset of columns is returned to the client. -This can take a while to complete. If there is a Hive table with the same data as the Trafodion table being scanned, then +When creating an index, all rows of the {project-name} table must be scanned and a subset of columns is returned to the client. +This can take a while to complete. If there is a Hive table with the same data as the {project-name} table being scanned, then you can specify the default attribute, USE_HIVE_SOURCE. This causes the Hive table to be used as the source creating the index. -NOTE: The name of the Hive table must use the Trafodion table name as its prefix. -For example, if the Trafodion table is TRAFODION.SCH.DEMO, then the Hive +NOTE: The name of the Hive table must use the {project-name} table name as its prefix. +For example, if the {project-name} table is TRAFODION.SCH.DEMO, then the Hive table name can be DEMO_SRC. In this case, set the attribute as follows: + + ``` @@ -131,7 +131,7 @@ or update should be broken up into multiple statements each affecting less than == Large UPSERT USING LOAD On a Table With Index Errors Out -UPSERT USING LOAD automatically reverts to a transactional UPSERT when used on a table with an index. This causes Trafodion +UPSERT USING LOAD automatically reverts to a transactional UPSERT when used on a table with an index. This causes {project-name} to run into the limitation discusses in <<large-deletes,Large Deletes Take Too Long or Error Out>> above: no more than 10,000*n rows (n = number of nodes) can be affected in a single statement. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/load_transform/src/asciidoc/index.adoc ---------------------------------------------------------------------- diff --git a/docs/load_transform/src/asciidoc/index.adoc b/docs/load_transform/src/asciidoc/index.adoc index 7f41e22..16118f7 100644 --- a/docs/load_transform/src/asciidoc/index.adoc +++ b/docs/load_transform/src/asciidoc/index.adoc @@ -32,7 +32,8 @@ :experimental: :source-language: text :revnumber: {project-version} -:title-logo-image: ../../../shared/trafodion-logo.jpg +:title-logo-image: {project-logo} +:project-name: {project-name} :images: ../images :leveloffset: 1 @@ -41,22 +42,13 @@ // processing of files found in directories starting with an _. This // prevents each chapter being built as its own book. -**License Statement** +include::../../shared/license.txt[] +<<< -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 +include::../../shared/acknowledgements.txt[] -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. - -[cols="2",options="header"] -|=== -| Version | Date -| 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/messages_guide/pom.xml ---------------------------------------------------------------------- diff --git a/docs/messages_guide/pom.xml b/docs/messages_guide/pom.xml index e3d3e27..31d4c52 100644 --- a/docs/messages_guide/pom.xml +++ b/docs/messages_guide/pom.xml @@ -183,6 +183,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> @@ -201,6 +205,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/messages_guide/src/asciidoc/_chapters/about.adoc ---------------------------------------------------------------------- diff --git a/docs/messages_guide/src/asciidoc/_chapters/about.adoc b/docs/messages_guide/src/asciidoc/_chapters/about.adoc index fe6c999..586b010 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/about.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/about.adoc @@ -20,19 +20,19 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// = About This Document -Trafodion is a relational database management system based on +{project-name} is a relational database management system based on ANSI SQL. It uses the industry standard Structured Query Language (SQL) to define and manipulate data. This manual describes messages -produced by the Trafodion SQL engine and its associated +produced by the {project-name} SQL engine and its associated components. == Intended Audience -This manual was written for Trafodion database administrators and -programmers who use the Trafodion database software conversational or +This manual was written for {project-name} database administrators and +programmers who use the {project-name} database software conversational or programmatic interface. == New and Changed Information @@ -166,19 +166,8 @@ match-value [NOT] LIKE _pattern [ESCAPE esc-char-expression] ``` -== Publishing History -[cols="2*",options="header"] -|=== -| Product Version | Publication Date -| Trafodion Release 1.3.0 | To be announced. -|=== - == 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/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc ---------------------------------------------------------------------- diff --git a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc index bd3122d..20c9d5b 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc @@ -20,7 +20,7 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// [[binder-and-compilation-messages]] @@ -36,7 +36,7 @@ Column <name-1> is not found. Tables in scope: <name-2>. Default schema: <name-3>. ``` -*Cause:* You referenced column <name-1>, which the Trafodion database +*Cause:* You referenced column <name-1>, which the {project-name} database software could not find. The table <name-2> or tables in the scope of the column reference and the default schema <name-3> appear. @@ -76,7 +76,7 @@ found, and resubmit. Column <name-1> is not found. Table <name-2> not exposed. Tables in scope: <name-3>. Default schema: <name-4>. ``` -*Cause:* You referenced column <name-1>, which the Trafodion database +*Cause:* You referenced column <name-1>, which the {project-name} database software could not find. Table <name-2> is not exposed. The table <name-3> or tables in the scope of the column reference and the default schema <name-4> appear. @@ -211,7 +211,7 @@ Reference made to column <name> via star (*) is ambiguous. Where <name> is the name of the column. *Cause:* You referred to column <name> using the `SELECT *` or `SELECT TBL.*` -reference, and the Trafodion database software could not locate the column +reference, and the {project-name} database software could not locate the column because the reference is ambiguous. *Effect:* The operation fails. @@ -425,7 +425,7 @@ Error while preparing constraint <name> on table <table-name>. Where <table-name> is the name of the table. -*Cause:* Trafodion received an error while +*Cause:* {project-name} received an error while preparing constraint <name> on <table-name>. See accompanying error messages. @@ -912,7 +912,7 @@ partition, which is not supported. The preceding error actually occurred in function <name>. ``` -*Cause:* Trafodion detected an error in function +*Cause:* {project-name} detected an error in function <name>. Errors that appear before this one refer to the low level computations that this function uses. @@ -1234,7 +1234,7 @@ which is not supported. The number of output dynamic parameters (<value-1>) must equal the number of selected values (<value-2>). ``` -*Cause:* Trafodion requires that the number of +*Cause:* {project-name} requires that the number of output dynamic parameters, <value-1), match the number of selected values, <value-2>. @@ -1250,7 +1250,7 @@ The number of output host variables (<value-1>) must equal the number of selected values (<value-2>). ``` -*Cause:* Trafodion requires that the number of +*Cause:* {project-name} requires that the number of output host variables, <value-1>, match the number of selected values, <value-2>. @@ -1352,7 +1352,7 @@ clause, the preceding join search condition must be enclosed in parentheses. ``` -*Cause:* A syntax error has caused the Trafodion database software to +*Cause:* A syntax error has caused the {project-name} database software to treat object <name> as an ambiguous entity. *Effect:* The operation fails. @@ -1382,7 +1382,7 @@ other than an outermost SELECT statement. ``` If a character literal was intended, you must use the single quote -delimiter: <literal>. The use of double quotes causes Trafodion to +delimiter: <literal>. The use of double quotes causes {project-name} to interpret <column-name> as a delimited identifier column name. ``` @@ -1414,10 +1414,10 @@ single quote delimiter instead of the double: 'Lower' instead of Translation name is not recognized. ``` -*Cause:* Trafodion does not recognize the +*Cause:* {project-name} does not recognize the translation name. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Use one of the supported translation names. @@ -1577,7 +1577,7 @@ Absolute and relative sampling cannot occur in the same BALANCE expression. *Cause:* You attempted to perform absolute and relative sampling in the same balance expression, which is not supported. -*Effect:* Trafodion is unable to prepare the +*Effect:* {project-name} is unable to prepare the query. *Recovery:* Correct the syntax and resubmit. @@ -1592,7 +1592,7 @@ The sample size for <type> Sampling must be <size-type>. *Cause:* You specified an invalid combination of sample <type> and sample <size-type>. -*Effect:* Trafodion is unable to prepare the +*Effect:* {project-name} is unable to prepare the query. *Recovery:* Correct the syntax and resubmit. @@ -1607,7 +1607,7 @@ An absolute sample size must have a scale of zero. *Cause:* You specified an absolute sample size with a scale greater than zero, which is not supported. -*Effect:* Trafodion is unable to prepare the +*Effect:* {project-name} is unable to prepare the query. *Recovery:* Correct the syntax and resubmit. @@ -1622,7 +1622,7 @@ The sample size must be less than or equal to the sample period. *Cause:* You specified a sample size that is greater than the sample period. It must be less than or equal to the sample period. -*Effect:* Trafodion is unable to prepare the +*Effect:* {project-name} is unable to prepare the query. *Recovery:* Correct the syntax and resubmit. @@ -1690,7 +1690,7 @@ join query is not updatable. *Effect:* The operation fails. *Recovery:* An updatable cursor query should not specify a join or a -nonupdatable query. A Trafodion database software statement cursor is +nonupdatable query. A {project-name} database software statement cursor is updatable if all the following are true: * It is a SELECT statement. @@ -1792,7 +1792,7 @@ More than one table will be locked: <name>. Where <name> is the name of the table. -*Cause:* Trafodion is preparing to lock more than +*Cause:* {project-name} is preparing to lock more than one table. *Effect:* None. @@ -1853,7 +1853,7 @@ Default volume and subvolume information could not be retrieved from=_DEFAULTS d Where <number> is the error message. -*Cause:* Trafodion was not able to retrieve +*Cause:* {project-name} was not able to retrieve default volume and subvolume information using the =_DEFAULTS define. *Effect:* The operation fails. @@ -1911,7 +1911,7 @@ CHARACTER. The operation (<name>) is not allowed. Try UNION ALL instead. ``` -*Cause:* You attempted to perform an operation that the Trafodion +*Cause:* You attempted to perform an operation that the {project-name} database software does not allow. *Effect:* The operation fails. @@ -1965,7 +1965,7 @@ the second expression for your join. You must use the primary key to prevent returning multiple rows being returned for a single deleted or updated row. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the WHERE clause to use the primary key of the table @@ -1981,7 +1981,7 @@ Stream access is supported only on updatable views. View: <table-name>. *Cause:* You attempted to access a nonupdatable view using stream access mode. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -1995,7 +1995,7 @@ Table <name> cannot be both read and updated. *Cause:* You attempted to read from and update the same table. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2011,7 +2011,7 @@ Statement may not compile due to an order requirement on stream expression. on columns that do not define the prefix of the clustering key of the base table or of a secondary index. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Create a secondary index whose clustering key materializes @@ -2029,7 +2029,7 @@ Statement may not compile due to an order requirement on embedded expression using an ORDER BY without using a clustering key or a secondary index. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Create a secondary index materializing the order and @@ -2059,7 +2059,7 @@ Inner relation of left join cannot be stream expression. Tables in scope: <name> *Cause:* You attempted to perform a left join using the result set of a stream expression as the inner relation. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2073,7 +2073,7 @@ Join of stream expressions is not supported. Tables in scope: <name>. *Cause:* You attempted to perform a join of stream expressions. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2087,7 +2087,7 @@ Intersection of stream expressions is not supported. Tables in scope: <name>. *Cause:* You attempted to perform an intersection of stream expressions. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2103,7 +2103,7 @@ Intersection between embedded <name-1> expression and embedded *Cause:* You attempted to perform an intersection between two embedded expressions. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2119,7 +2119,7 @@ expression not supported. Tables in scope: <name-3>, <name-4>. *Cause:* You attempted to perform a union between two embedded expressions. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2134,7 +2134,7 @@ GROUP BY is not supported for stream expression. Tables in scope: <name>. *Cause:* You attempted to perform a GROUP BY in conjunction with a stream expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2150,7 +2150,7 @@ scope: <name-2>. *Cause:* You attempted to perform a GROUP BY in conjunction with an embedded expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2166,7 +2166,7 @@ Tables in scope: <name>. *Cause:* You attempted to perform a right join using an embedded expression as the outer relation. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2182,7 +2182,7 @@ scope: <name>. *Cause:* You attempted to perform a right join using a stream expression as the outer relation. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2198,7 +2198,7 @@ scope: <name-1>, <name-2>. *Cause:* You attempted to use an ORDER BY clause in the UNION of two streams. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2213,7 +2213,7 @@ Embedded <name> statements are not supported in subqueries. *Cause:* You attempted to perform a subquery that included an embedded statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2228,7 +2228,7 @@ Stream expressions are not supported in subqueries. *Cause:* You attempted to perform a subquery that included a stream expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2244,7 +2244,7 @@ FOR UPDATE clause. *Cause:* You attempted to perform a DECLARE... FOR UPDATE clause that included an embedded DELETE statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2259,7 +2259,7 @@ Stream expressions are not supported for insert statements. *Cause:* You attempted to perform an insert statement that includes a stream expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2274,7 +2274,7 @@ Embedded <name> statements are not supported in INSERT statements. *Cause:* You attempted to perform an INSERT that included an embedded statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2289,7 +2289,7 @@ Stream expression is not supported for top level UPDATE statements. *Cause:* You attempted to perform a top-level UPDATE statement that included a stream expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2301,10 +2301,10 @@ statement. JOIN_ORDER_BY_USER prevented compiler from reordering query tree. ``` -*Cause:* Trafodion compiler could not reorder the +*Cause:* {project-name} compiler could not reorder the join tree because the JOIN_ORDER_BY_USER directive is in effect. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Disable the JOIN_ORDER_BY_USER directive and resubmit. @@ -2319,7 +2319,7 @@ Join between embedded <name-1> expression and embedded <name-2> expression is no *Cause:* You attempted to perform a join between two embedded expressions. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2335,7 +2335,7 @@ not supported. Tables in scope: <name-2>. *Cause:* You attempted to perform a join between a stream expression and an embedded expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2350,7 +2350,7 @@ Update of <name-1> column <name-2> is not permitted on rollback. *Cause:* You attempted to update clustering key components or columns associated with referential integrity constraints during a rollback. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2365,7 +2365,7 @@ Update of variable length column <name> is not permitted on rollback. *Cause:* You attempted to perform a rollback that included an update of a variable length column. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2379,7 +2379,7 @@ SEQUENCE BY is not supported for stream expressions. *Cause:* You included a SEQUENCE BY statement in a stream expression. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2394,7 +2394,7 @@ Stream expression is not supported for top level DELETE statement. *Cause:* You attempted to use a stream expression to perform a top-level DELETE. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2454,7 +2454,7 @@ Stream expressions are not supported for compound statements. *Cause:* You attempted to use a stream expression for a compound statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2469,7 +2469,7 @@ Embedded <name> expression is not supported for compound statements. *Cause:* You attempted to use an embedded expression for a compound statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2484,7 +2484,7 @@ SEQUENCE BY is not supported for embedded <name> expressions. *Cause:* You attempted to perform an embedded expression that included SEQUENCE BY. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2509,7 +2509,7 @@ error, depending on how you have set this attribute value. on a non-audited table and IUD_NONAUDITED_INDEX_MAINT is set to OFF. This message is displayed as an error. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2518,7 +2518,7 @@ statement. on a non-audited table and IUD_NONAUDITED_INDEX_MAINT is set to WARN. This message appears as an warning. -*Effect:* Trafodion performs the INSERT, UPDATE, +*Effect:* {project-name} performs the INSERT, UPDATE, or DELETE operation. If the operation encounters an error, you will see other messages about that condition. @@ -2534,7 +2534,7 @@ Stream access is supported for only key-sequenced tables. Table: <name>. *Cause:* You attempted to use stream access on a table that is not key-sequenced, which is required. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2549,7 +2549,7 @@ Embedded <name-1> is supported for only key-sequenced tables. Table: <name-2>. *Cause:* You attempted to perform an embedded action that is supported only for key-sequenced tables. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2564,7 +2564,7 @@ Embedded <name> is supported only for updatable views. View: <name-2>. *Cause:* You attempted to perform an embedded action that is supported only for updatable views. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2580,7 +2580,7 @@ cover all output values of stream. *Cause:* You attempted to use an index for stream access that does not cover all output columns of the base table. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Restrict the select list or add the missing columns to the @@ -2597,7 +2597,7 @@ cover all columns referenced in WHERE clause of stream. *Cause:* You attempted to use an index for stream access that does not cover all base table columns referenced in the WHERE clause. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Add the missing columns to the index. @@ -2612,7 +2612,7 @@ Update of nullable column <name> is not permitted on rollback. *Cause:* You attempted to perform a rollback that included an update of a nullable column. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2627,7 +2627,7 @@ Embedded update/delete statements not supported within an IF statement. *Cause:* You attempted to embed UPDATE/DELETE statements within an IF statement. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2643,7 +2643,7 @@ stream because it is partitioned. *Cause:* You specified <table-name>, a partitioned table, as the order requirement on a stream. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2658,7 +2658,7 @@ Use of row sets in a predicate with embedded update/delete is not supported. *Cause:* You attempted to use a row set as a predicate with an embedded update or embedded delete. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the statement. *Recovery:* Modify the statement and resubmit. @@ -2710,12 +2710,12 @@ The FIRST/ANY n syntax cannot be used with an embedded update or embedded delete Procedure <procedure-name> expects <value-1> parameters but was called with <value-2> parameters. ``` -*Cause:* In the Trafodion database software statement being compiled, a +*Cause:* In the {project-name} database software statement being compiled, a stored procedure invocation contains an incorrect number of parameters. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. -*Recovery:* Correct the Trafodion database software statement and retry +*Recovery:* Correct the {project-name} database software statement and retry the compilation. [[SQL-4303]] @@ -2725,11 +2725,11 @@ the compilation. The supplied type for parameter <value> of routine <routine-name> was <type-name-1> which is not compatible with the expected type <type-name-2>. ``` -*Cause:* In the Trafodion database software statement being compiled, +*Cause:* In the {project-name} database software statement being compiled, you attempted to invoke a stored procedure with a type of parameter that is incompatible with the formal type of the parameter. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. *Recovery:* Supply the correct parameter and type and retry the compilation. @@ -2741,7 +2741,7 @@ compilation. Host variable or dynamic parameter <parameter-name> is used in more than one OUT or INOUT parameter for routine <routine-name>. Results may be unpredictable. ``` -*Cause:* In the Trafodion database software statement being compiled, +*Cause:* In the {project-name} database software statement being compiled, you attempted to invoke a stored procedure that contains the same host variable or dynamic parameter in more than one OUT or INOUT parameter. @@ -2759,13 +2759,13 @@ Parameter <value> for user-defined routine <routine-name> is an OUT or INOUT parameter and must be a host variable or a dynamic parameter. ``` -*Cause:* In the Trafodion database software statement being compiled, +*Cause:* In the {project-name} database software statement being compiled, you attempted to invoke a stored procedure that has an OUT or INOUT parameter that is neither a host variable nor a dynamic parameter. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. -*Recovery:* Correct the Trafodion database software statement. Supply a +*Recovery:* Correct the {project-name} database software statement. Supply a host variable or a dynamic parameter for OUT or INOUT parameters, and retry the compilation. @@ -2776,10 +2776,10 @@ retry the compilation. A CALL statement is not allowed within a compound statement. ``` -*Cause:* In the Trafodion database software statement being compiled, a +*Cause:* In the {project-name} database software statement being compiled, a CALL statement was present within a BEGIN...END block. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. *Recovery:* Remove the CALL statement from the compound statement and retry the compilation. @@ -2791,11 +2791,11 @@ retry the compilation. Rowset parameters are not allowed in a CALL statement. ``` -*Cause:* In the Trafodion database software statement being compiled, +*Cause:* In the {project-name} database software statement being compiled, you attempted to use a row set as a parameter in a stored procedure invocation. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. *Recovery:* Alter the data type of the relevant variable, or use a different non-row-set host variable. Retry the compilation. @@ -2808,11 +2808,11 @@ Internal error: Unsupported SQL data type <value> specified for a CALL statement parameter. ``` -*Cause:* In the Trafodion database software statement being compiled, a +*Cause:* In the {project-name} database software statement being compiled, a parameter in a stored procedure invocation had an unsupported SQL data type. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. *Recovery:* This error should never occur. Drop the stored procedure and re-create it with an appropriate data type. Report this problem to HP @@ -2828,15 +2828,15 @@ stored procedure result sets are not yet supported. Where <procedure-name> is the ANSI name of a stored procedure. -*Cause:* You are running a Trafodion database software version that does +*Cause:* You are running a {project-name} database software version that does not support stored procedure result sets and attempted to compile a CALL statement for a stored procedure that returns result sets. This message indicates a downgrade has been performed without removing stored procedures that return result sets. -*Effect:* Trafodion statement is not compiled. +*Effect:* {project-name} statement is not compiled. -*Recovery:* Migrate to a Trafodion database software version that +*Recovery:* Migrate to a {project-name} database software version that supports stored procedure result sets. [[SQL-4310]] http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/21d6d8d3/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc ---------------------------------------------------------------------- diff --git a/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc index e5abe09..b062199 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc @@ -20,11 +20,11 @@ * under the License. * * @@@ END COPYRIGHT @@@ - */ +*/ //// [[trafodion-compiler-messages]] -= Trafodion Compiler Messages (2000 through 2999) += {project-name} Compiler Messages (2000 through 2999) This section includes process creation errors, IPC errors, static compilation errors, and miscellaneous errors from the optimizer. @@ -35,11 +35,11 @@ This section includes process creation errors, IPC errors, static compilation er Internal error: error from MXCMP; cannot work on this query. ``` -*Cause:* Trafodion received an internal error from the Trafodion compiler. +*Cause:* {project-name} received an internal error from the {project-name} compiler. *Effect:* The operation fails. -*Recovery:* None. Report the entire message to mailto:u...@trafodion.incubator.apache.org[the Trafodion User mailing list]. +*Recovery:* None. Report the entire message to {project-support}. [[SQL-2009]] == SQL 2009 @@ -48,7 +48,7 @@ Internal error: error from MXCMP; cannot work on this query. The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed. ``` -*Cause:* An outstanding transaction must be resolved before the Trafodion compiler can be restarted. +*Cause:* An outstanding transaction must be resolved before the {project-name} compiler can be restarted. *Effect:* The operation fails. @@ -66,7 +66,7 @@ Where error <number> is the error number. Where <name> is the name of the program file. -*Cause:* Trafodion was unable to create a server +*Cause:* {project-name} was unable to create a server process because of the process control procedure error <number> it received while resolving the program file name. @@ -90,7 +90,7 @@ Where <number-2> is the TPCError. Where <text> is the error message text. -*Cause:* Trafodion was unable to create server +*Cause:* {project-name} was unable to create server process <name> because of the process control procedure error <number> it received. More information appears in detail <text>. @@ -110,7 +110,7 @@ Where <name> is the name of the server process. Where <number> is the error number. -*Cause:* Trafodion was unable to create server +*Cause:* {project-name} was unable to create server process <name> because of the process control procedure error <number> it received on the program file. @@ -129,11 +129,11 @@ Where <name> is the server process name. Where <number> is the error number. -*Cause:* Trafodion was unable to create server +*Cause:* {project-name} was unable to create server process <name> because of the process control procedure error <number> it received on the swap file. -*Effect:* Trafodion does not create the server process. +*Effect:* {project-name} does not create the server process. *Recovery:* Use the process control procedure error to diagnose and correct the problem. @@ -147,7 +147,7 @@ Server process <name> could not be created - unlicensed privileged program. Where <name> is the server process name. -*Cause:* Trafodion was unable to create server +*Cause:* {project-name} was unable to create server process <name> because it is an unlicensed privileged program. The server process was configured incorrectly at installation. @@ -205,11 +205,11 @@ Where <number> is the error number. Where <name> is the name of the server process. -*Cause:* The Trafodion database <process-id> received process control +*Cause:* The {project-name} database <process-id> received process control procedure error <number> while communicating with the server process <name>. -*Effect:* Trafodion is not able to communicate +*Effect:* {project-name} is not able to communicate with the process. *Recovery:* Use the process control procedure error to diagnose and @@ -229,11 +229,11 @@ Where <number> is the error number. Where <name> is the name of the server process. -*Cause:* The Trafodion database <process-id> received process control +*Cause:* The {project-name} database <process-id> received process control procedure error <number> while communicating with server process <name>. -*Effect:* Trafodion process is not able to +*Effect:* {project-name} process is not able to communicate with the server process. *Recovery:* Use the process control procedure error to diagnose and @@ -252,7 +252,7 @@ Where <name> is the name of the server process. Where <number> is the error number. -*Cause:* The Trafodion database <process-id> was unable to open server +*Cause:* The {project-name} database <process-id> was unable to open server process <name> because of the operating system error <number> it received. @@ -287,7 +287,7 @@ Where <attribute> is the attribute name you specified. *Cause:* If the SQLSTATE is 42000, this is an error. You attempted to set a CONTROL QUERY DEFAULT setting, but the <attribute> name you -specified is not valid. If the SQLSTATE is 01000, this is a warning. In an earlier Trafodion +specified is not valid. If the SQLSTATE is 01000, this is a warning. In an earlier {project-name} database session, you inserted a row into a DEFAULTS table whose <attribute> column value is invalid. @@ -329,7 +329,7 @@ will work. *Recovery:* Informational message only; no corrective action is needed. This message will be accompanied by an assertion failure message and, possibly, CONTROL QUERY SHAPE information. However, report the entire -message, and the preceding assertion failure message, to mailto:u...@trafodion.incubator.apache.org[the Trafodion User mailing list]. +message, and the preceding assertion failure message, to {project-support}. This additional information will also be helpful: the DDL for the tables involved, the query that produced this warning, and any CONTROL QUERY @@ -446,7 +446,7 @@ Where <name> is the procedure name. *Cause:* You defined procedure <name> twice in this module. -*Effect:* Trafodion uses the first definition. +*Effect:* {project-name} uses the first definition. *Recovery:* This is an informational message only; no corrective action is needed. @@ -462,7 +462,7 @@ Where <name> is the cursor name. *Cause:* You defined the static cursor <name> twice in this module. -*Effect:* Trafodion uses the first static cursor +*Effect:* {project-name} uses the first static cursor definition. *Recovery:* This is an informational message only; no corrective action @@ -480,7 +480,7 @@ Where <name> is the cursor name. *Cause:* You defined the static cursor <name> twice in this module. -*Effect:* Trafodion uses the first dynamic cursor +*Effect:* {project-name} uses the first dynamic cursor definition. *Recovery:* This is an informational message only; no corrective action @@ -497,7 +497,7 @@ Where <name> is the cursor name. *Cause:* You defined the dynamic cursor <name> twice in this module. -*Effect:* Trafodion uses the first static cursor +*Effect:* {project-name} uses the first static cursor definition. *Recovery:* This is an informational message only; no corrective action @@ -515,7 +515,7 @@ Where <name> is the cursor name. *Cause:* You defined the dynamic cursor <name> twice in this module. -*Effect:* Trafodion uses the first dynamic cursor +*Effect:* {project-name} uses the first dynamic cursor definition. *Recovery:* This is an informational message only; no corrective action is needed. @@ -531,7 +531,7 @@ Where <name> is the statement name. Where <name> is the module name. -*Cause:* Trafodion could not find statement <name> +*Cause:* {project-name} could not find statement <name> in module <name>. *Effect:* The operation fails. @@ -550,7 +550,7 @@ Where <name> is the cursor name. Where <name> is the module name. -*Cause:* Trafodion could not find cursor <name> in +*Cause:* {project-name} could not find cursor <name> in module <name>. *Effect:* The operation fails. @@ -568,7 +568,7 @@ Where <name> is the descriptor name. *Cause:* You defined the descriptor <name> twice in this module. -*Effect:* Trafodion uses the first definition. +*Effect:* {project-name} uses the first definition. *Recovery:* Informational message only; no corrective action is needed. @@ -614,7 +614,7 @@ Statement is not valid in this context. such as SELECT, INSERT, UPDATE, DELETE, or a DDL statement. These statements must be embedded in procedures. -*Effect:* Trafodion is unable to compile the +*Effect:* {project-name} is unable to compile the module. *Recovery:* Correct the syntax and resubmit. @@ -633,7 +633,7 @@ Where <definition-type> is the previous definition *Cause:* You defined <name> twice in this module in which it was defined as a type _definition type_. -*Effect:* Trafodion uses the previous definition. +*Effect:* {project-name} uses the previous definition. *Recovery:* Specify a new name for the item and resubmit, if necessary. @@ -729,14 +729,14 @@ quality. Error <number> while reading file: <value> bytes were read from <text> when <value> were expected in module <name>. ``` -*Cause:* Trafodion received error <number> while +*Cause:* {project-name} received error <number> while reading module <name>. <value> shows the number of bytes read from <text>. The module file is unusable. Either it has been corrupted or overwritten. *Effect:* The operation fails. -*Recovery:* Recompile the module definition file, using the Trafodion +*Recovery:* Recompile the module definition file, using the {project-name} compiler, to create a valid module file. <<< @@ -751,10 +751,10 @@ Where <number> is the error number. Where <name> is the name of the file. -*Cause:* Trafodion received error <number> while +*Cause:* {project-name} received error <number> while opening file <name> for read. -*Effect:* Trafodion does not open the file. +*Effect:* {project-name} does not open the file. *Recovery:* Use the error number to diagnose and correct the problem. @@ -769,10 +769,10 @@ Where <number> is the error number. Where <name> is the name of the file. -*Cause:* Trafodion received error <number> while +*Cause:* {project-name} received error <number> while opening file <name> for write. -*Effect:* Trafodion does not open the file. +*Effect:* {project-name} does not open the file. *Recovery:* Use the error number to diagnose and correct the problem. @@ -788,10 +788,10 @@ Where <number> is the error number. Where <name> is the name of the file. -*Cause:* Trafodion received error <number> while +*Cause:* {project-name} received error <number> while naming or locating file <name>. -*Effect:* Trafodion does not name or locate the +*Effect:* {project-name} does not name or locate the file. *Recovery:* Use the error to diagnose and correct the problem. @@ -803,11 +803,11 @@ file. Error <number> while writing <value> bytes to file <name>. ``` -*Cause:* Trafodion database software received error <number> while +*Cause:* {project-name} database software received error <number> while writing to file <name>. <value> shows the number of bytes being written. -*Effect:* Trafodion does not open the file. +*Effect:* {project-name} does not open the file. *Recovery:* Use the error to diagnose and correct the problem. @@ -823,10 +823,10 @@ Where <number> is the error number. Where <name> is the name of the file. -*Cause:* Trafodion received error <number> when +*Cause:* {project-name} received error <number> when closing file <name>. -*Effect:* Trafodion does not close the file. +*Effect:* {project-name} does not close the file. *Recovery:* Use the error number to diagnose and correct the problem. @@ -839,12 +839,12 @@ The file <name> could not be purged. This file contains the results of a failed Where <name> is the name of the file. -*Cause:* A compilation failed, and for some reason Trafodion database +*Cause:* A compilation failed, and for some reason {project-name} database software was not able to purge the module file. *Effect:* The module file is not valid and should not be used. -*Recovery:* Purge the file from the Trafodion platform. +*Recovery:* Purge the file from the {project-name} platform. <<< [[SQL-2090]] @@ -856,7 +856,7 @@ The command line argument for module name, <name-1>, is being ignored in favor o Where <name-1>, <name-2>, and <name-3> are module file names. -*Cause:* Trafodion ignored the command line +*Cause:* {project-name} ignored the command line argument for module <name-1>. Instead, it used the second module <name-2> in file <name-3>. @@ -873,7 +873,7 @@ The required module statement was not found in file <name>. Where <name> is the name of the file. -*Cause:* Trafodion could not find the required +*Cause:* {project-name} could not find the required module statement in file <name>. *Effect:* The operation fails. @@ -893,7 +893,7 @@ Where <name> is the name of the file. *Cause:* You included more than one module statement. <name> will be used. -*Effect:* Trafodion ignores the second module +*Effect:* {project-name} ignores the second module statement. *Recovery:* Informational message only; no corrective action is needed. @@ -907,10 +907,10 @@ A module timestamp statement was not found in file <name>. Where <name> is the name of the file. -*Cause:* Trafodion did not find a module timestamp +*Cause:* {project-name} did not find a module timestamp statement in the module definition file <name>. -*Effect:* Trafodion uses a default timestamp value +*Effect:* {project-name} uses a default timestamp value of all zeros. *Recovery:* Supply a timestamp and resubmit. @@ -925,7 +925,7 @@ A module timestamp statement has already appeared in this module. The previous t *Cause:* You specified a timestamp statement twice in this module. -*Effect:* Trafodion uses the first timestamp. +*Effect:* {project-name} uses the first timestamp. *Recovery:* Informational message only; no corrective action is needed. @@ -938,7 +938,7 @@ Module file <name-1>, expected to contain module <name-2>, instead contains <nam Where <name-1>, <name-2>, and <name-3> are module file names. -*Cause:* Trafodion expected to find the first +*Cause:* {project-name} expected to find the first module <name-1>, but instead found the second module <name-2>, in file <name-3>. @@ -954,7 +954,7 @@ module <name-1>, but instead found the second module <name-2>, in file A source file statement has already appeared in this module. The previous source file is being retained and this latest one ignored. ``` -*Cause:* The Trafodion compiler was invoked on a module definition file +*Cause:* The {project-name} compiler was invoked on a module definition file that contains more than one SOURCE_FILE statement. A module definition can have only one SOURCE_FILE statement that specifies that module's SQL source file. @@ -962,7 +962,7 @@ source file. *Effect:* The operation fails. *Recovery:* Edit the module definition file so that it contains no more -than one SOURCE_FILE statement, and rerun the Trafodion compiler on the +than one SOURCE_FILE statement, and rerun the {project-name} compiler on the module definition. [[SQL-2097]] @@ -972,7 +972,7 @@ module definition. Source file name is over 1024 characters long. ``` -*Cause:* The Trafodion compiler was invoked on a module definition file +*Cause:* The {project-name} compiler was invoked on a module definition file that contains a SOURCE_FILE statement whose _source path name_ has over 1024 characters. @@ -980,7 +980,7 @@ that contains a SOURCE_FILE statement whose _source path name_ has over *Recovery:* Edit the module definition file so that its SOURCE_FILE statement's _source path name_ is no more than 1024 characters long. -Rerun the Trafodion compiler on the module definition file. +Rerun the {project-name} compiler on the module definition file. <<< [[SQL-2098]] @@ -1019,10 +1019,10 @@ Otherwise, correct the syntax and resubmit. Break was received. The compilation has been aborted. ``` -*Cause:* Trafodion received a break and aborted +*Cause:* {project-name} received a break and aborted the compilation. -*Effect:* Trafodion does not continue compilation. +*Effect:* {project-name} does not continue compilation. *Recovery:* Informational message only; no corrective action is needed. @@ -1033,10 +1033,10 @@ the compilation. This query could not be compiled with 'MINIMUM' optimization level. Suggestion: Retry with 'MEDIUM' optimization level. ``` -*Cause:* Trafodion was unable to compile this +*Cause:* {project-name} was unable to compile this query using the MINIMUM optimization level. -*Effect:* Trafodion is unable to process this +*Effect:* {project-name} is unable to process this query. *Recovery:* Resubmit the query with MEDIUM optimization level. Precede @@ -1050,12 +1050,12 @@ the statement with: CONTROL QUERY DEFAULT OPTIMIZATION-LEVEL 'MEDIUM'; This query could not be compiled for one/both of the following reasons: a) Use of 'MINIMUM' optimization level, or b) incompatible Control Query Shape specifications. ``` -*Cause:* Trafodion was unable to compile this +*Cause:* {project-name} was unable to compile this query, either because it was not able to use the MINIMUM optimization level or because you used an incompatible CONTROL QUERY SHAPE specification. -*Effect:* Trafodion is unable to process this +*Effect:* {project-name} is unable to process this query. *Recovery:* If applicable, resubmit the query with MINIMUM optimization @@ -1071,12 +1071,12 @@ QUERY SHAPE specification and resubmit. This query could not be compiled for one of two reasons: a) incompatible Control Query Shape (CQS) specifications, or b) 'MEDIUM' optimization level is not sufficient to satisfy the CQS in effect. Suggestion: a) inspect the CQS in effect; or b) raise the optimization level to 'MAXIMUM'. Note that for this query, 'MAXIMUM' optimization level may result in a long compile time. ``` -*Cause:* Trafodion was unable to compile this +*Cause:* {project-name} was unable to compile this query, either because it was not able to use the MEDIUM optimization level or because you used an incompatible CONTROL QUERY SHAPE specification. -*Effect:* Trafodion is unable to process this +*Effect:* {project-name} is unable to process this query. *Recovery:* If applicable, use the MAXIMUM optimization level, correct @@ -1090,11 +1090,11 @@ the CONTROL QUERY SHAPE specification, and resubmit. This query could not be compiled because of incompatible Control Query Shape (CQS) specifications. Inspect the CQS in effect. ``` -*Cause:* Trafodion was unable to compile this +*Cause:* {project-name} was unable to compile this query because you used an incompatible CONTROL QUERY SHAPE specification. -*Effect:* Trafodion is unable to process this +*Effect:* {project-name} is unable to process this query. *Recovery:* Correct the CONTROL QUERY SHAPE specification and resubmit. @@ -1106,10 +1106,10 @@ query. This statement could not be compiled since it is too long. Break up large statements into smaller pieces. ``` -*Cause:* Trafodion was unable to compile this +*Cause:* {project-name} was unable to compile this query because it is too long. -*Effect:* Trafodion is unable to process this +*Effect:* {project-name} is unable to process this query. *Recovery:* Try breaking the statement into smaller pieces. @@ -1122,7 +1122,7 @@ query. This statement could not be compiled. Suggestion: Address the issue(s) raised in the reported warning(s). ``` -*Cause:* Trafodion was unable to compile the +*Cause:* {project-name} was unable to compile the query. *Effect:* The operation fails. @@ -1137,11 +1137,11 @@ diagnose and correct the problem. Statement was compiled as if query plan caching were off. ``` -*Cause:* Trafodion attempted to compile this query +*Cause:* {project-name} attempted to compile this query with query caching on but failed. It then successfully compiled this query with caching turned off. -*Effect:* Trafodion compiled the query as if query +*Effect:* {project-name} compiled the query as if query plan caching was turned off even though caching is currently on. The prepared query can be executed as usual. @@ -1174,12 +1174,12 @@ SQL compilation return code is <mxcmp-non-zero-exit-code>. *Cause:* You invoked mxCompileUserModule on an application file that has an embedded module definition. An SQL compilation of an embedded module -definition resulted in a Trafodion compiler nonzero exit code, +definition resulted in a {project-name} compiler nonzero exit code, indicating a warning or error. *Effect:* The operation fails. -*Recovery:* Review the Trafodion compiler warning or error message. +*Recovery:* Review the {project-name} compiler warning or error message. Trace the diagnostic back to the module source file and correct the offending source statement. Retry preprocessing, translating, compiling, and SQL compiling the application file. @@ -1193,7 +1193,7 @@ and SQL compiling the application file. ``` *Cause:* You invoked mxCompileUserModule on an application file that is -not a Trafodion platform ELF object file. +not a {project-name} platform ELF object file. *Effect:* The operation fails. @@ -1229,11 +1229,11 @@ Where <module-name> is the name of the module. *Cause:* You invoked mxCompileUserModule on an application file that has embedded module definition(s). The SQL compilation of the named embedded -module definition produced a Trafodion compiler warning or error. +module definition produced a {project-name} compiler warning or error. *Effect:* The operation fails. -*Recovery:* Review the Trafodion compiler warning or error. Trace the +*Recovery:* Review the {project-name} compiler warning or error. Trace the diagnostic back to the source file of the named module. Correct offending source statements. Retry preprocessing, translating, compiling, and SQL compiling the application file. @@ -1309,7 +1309,7 @@ application file. *Effect:* The operation fails. *Recovery:* Invoke mxCompileUserModule on an application file, such as a -Trafodion platform ELF object file. +{project-name} platform ELF object file. [[SQL-2209]] == SQL 2209 @@ -1412,7 +1412,7 @@ during the operation. *Effect:* The operation fails. -*Recovery:* None. Contact the Trafodion User Distribution List +*Recovery:* None. Contact the {project-name} User Distribution List [[SQL-2215]] == SQL 2215 @@ -1441,16 +1441,16 @@ reserved words and retry the command. <mxcmp-path> (MXCMP environment variable) does not exist or is not executable. ``` -Where <mxcmp-path> is the Trafodion compiler environment variable. +Where <mxcmp-path> is the {project-name} compiler environment variable. -*Cause:* You set your Trafodion compiler environment variable to point -to your own Trafodion compiler and invoked mxCompileUserModule on an -application file to SQL compile its module definitions. Your Trafodion +*Cause:* You set your {project-name} compiler environment variable to point +to your own {project-name} compiler and invoked mxCompileUserModule on an +application file to SQL compile its module definitions. Your {project-name} compiler is not executable. *Effect:* The operation fails. -*Recovery:* Verify that your Trafodion compiler exists and is executable +*Recovery:* Verify that your {project-name} compiler exists and is executable and retry the command. [[SQL-2221]] @@ -1463,7 +1463,7 @@ SQL compiler invocation failed with return code <error-code>. Where <error-code> is the error message code. *Cause:* You invoked mxCompileUserModule on an application file to SQL -compile its module definitions. This command invoked the Trafodion +compile its module definitions. This command invoked the {project-name} compiler, which returned _error code,_ indicating an abnormal termination. @@ -1471,7 +1471,7 @@ termination. *Recovery:* If the system is heavily loaded, retry the command later. If the problem persists under normal system load, report it as an internal -error and Contact the mailto:u...@trafodion.incubator.apache.org[Trafodion User Distribution mailing list]. +error and contact {project-support}. <<< [[SQL-2222]]
