This is an automated email from the ASF dual-hosted git repository.

maxgekk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git


The following commit(s) were added to refs/heads/master by this push:
     new b557f5752af [SPARK-44268][CORE][TEST] Add tests to ensure 
error-classes.json and docs are in sync
b557f5752af is described below

commit b557f5752afc32d614b37be610dbbca44519664b
Author: Jia Fan <fanjiaemi...@qq.com>
AuthorDate: Sun Jul 2 18:51:09 2023 +0300

    [SPARK-44268][CORE][TEST] Add tests to ensure error-classes.json and docs 
are in sync
    
    ### What changes were proposed in this pull request?
    Add new test to make sure to `error-classes.json` are match with series of 
`sql-error-conditions.md`.
    After this PR, any difference between `error-classes.json` and document 
with report a error during test.
    Note: only compare error class name at now.
    
    Also fix all different which be found by new test case.
    
    ### Why are the changes needed?
    Make sure our error-classes.json always sync with doc.
    
    ### Does this PR introduce _any_ user-facing change?
    No
    
    ### How was this patch tested?
    new test.
    
    Closes #41813 from Hisoka-X/SPARK-44268_sync_error_classes_to_doc.
    
    Authored-by: Jia Fan <fanjiaemi...@qq.com>
    Signed-off-by: Max Gekk <max.g...@gmail.com>
---
 .../org/apache/spark/SparkThrowableSuite.scala     |  51 ++
 ...ror-conditions-datatype-mismatch-error-class.md |   4 +
 ...tions-incompatible-data-to-table-error-class.md |  64 ---
 ...ror-conditions-insert-column-arity-mismatch.md} |  30 +-
 ...rror-conditions-insufficient-table-property.md} |  26 +-
 ... => sql-error-conditions-invalid-as-of-join.md} |  26 +-
 ...md => sql-error-conditions-invalid-boundary.md} |  26 +-
 ... sql-error-conditions-invalid-default-value.md} |  26 +-
 ...> sql-error-conditions-invalid-inline-table.md} |  26 +-
 ...ror-conditions-invalid-lamdba-function-call.md} |  26 +-
 ...or-conditions-invalid-limit-like-expression.md} |  26 +-
 ...nditions-invalid-parameter-value-error-class.md |  14 +-
 ...rror-conditions-invalid-partition-operation.md} |  26 +-
 docs/sql-error-conditions-invalid-sql-syntax.md    |  92 ++++
 ...nditions-invalid-time-travel-timestamp-expr.md} |  26 +-
 ...error-conditions-invalid-write-distribution.md} |  26 +-
 ...rror-conditions-malformed-record-in-parsing.md} |  24 +-
 ... => sql-error-conditions-missing-attributes.md} |  26 +-
 ...onditions-not-a-constant-string-error-class.md} |  26 +-
 ...=> sql-error-conditions-not-allowed-in-from.md} |  26 +-
 ...or-conditions-not-supported-in-jdbc-catalog.md} |  26 +-
 ...> sql-error-conditions-unsupported-add-file.md} |  26 +-
 ...-error-conditions-unsupported-default-value.md} |  26 +-
 ...r-conditions-unsupported-feature-error-class.md |  36 ++
 ... => sql-error-conditions-unsupported-insert.md} |  26 +-
 ...rror-conditions-unsupported-merge-condition.md} |  26 +-
 ... sql-error-conditions-unsupported-overwrite.md} |  26 +-
 docs/sql-error-conditions.md                       | 609 ++++++++++++++++++++-
 28 files changed, 984 insertions(+), 434 deletions(-)

diff --git a/core/src/test/scala/org/apache/spark/SparkThrowableSuite.scala 
b/core/src/test/scala/org/apache/spark/SparkThrowableSuite.scala
index 96c4e3b8ab7..034a782e533 100644
--- a/core/src/test/scala/org/apache/spark/SparkThrowableSuite.scala
+++ b/core/src/test/scala/org/apache/spark/SparkThrowableSuite.scala
@@ -141,6 +141,57 @@ class SparkThrowableSuite extends SparkFunSuite {
     checkIfUnique(messageFormats)
   }
 
+  test("SPARK-44268: Error classes match with document") {
+    val sqlstateDoc = "sql-error-conditions-sqlstates.md"
+    val errors = errorReader.errorInfoMap
+    val errorDocPaths = getWorkspaceFilePath("docs").toFile
+      .listFiles(_.getName.startsWith("sql-error-conditions-"))
+      .filter(!_.getName.equals(sqlstateDoc))
+      .map(f => IOUtils.toString(f.toURI, 
StandardCharsets.UTF_8)).map(_.split("\n"))
+    // check the error classes in document should be in error-classes.json
+    val linkInDocRegex = "\\[(.*)\\]\\((.*)\\)".r
+    val commonErrorsInDoc = IOUtils.toString(getWorkspaceFilePath("docs",
+      "sql-error-conditions.md").toUri, StandardCharsets.UTF_8).split("\n")
+      .filter(_.startsWith("###")).map(s => s.replace("###", "").trim)
+      .filter(linkInDocRegex.findFirstMatchIn(_).isEmpty)
+
+    commonErrorsInDoc.foreach(s => assert(errors.contains(s),
+      s"Error class: $s is not in error-classes.json"))
+
+    val titlePrefix = "title:"
+    val errorsInDoc = errorDocPaths.map(lines => {
+      val errorClass = lines.filter(_.startsWith(titlePrefix))
+        .map(s => s.replace("error class", "").replace(titlePrefix, 
"").trim).head
+      assert(errors.contains(errorClass), s"Error class: $errorClass is not in 
error-classes.json")
+      val subClasses = lines.filter(_.startsWith("##")).map(s => 
s.replace("##", "").trim)
+        .map { s =>
+          assert(errors(errorClass).subClass.get.contains(s),
+            s"Error class: $errorClass does not contain sub class: $s in 
error-classes.json")
+          s
+        }
+      errorClass -> subClasses
+    }).toMap
+
+    // check the error classes in error-classes.json should be in document
+    errors.foreach { e =>
+      val errorClass = e._1
+      val subClasses = e._2.subClass.getOrElse(Map.empty).keys.toSeq
+      if (subClasses.nonEmpty) {
+        assert(errorsInDoc.contains(errorClass),
+          s"Error class: $errorClass do not have sql-error-conditions sub doc, 
please create it")
+        val subClassesInDoc = errorsInDoc(errorClass)
+        subClasses.foreach { s =>
+          assert(subClassesInDoc.contains(s),
+            s"Error class: $errorClass contains sub class: $s which is not in 
" +
+              s"sql-error-conditions sub doc")
+        }
+      } else if (!errorClass.startsWith("_LEGACY_ERROR_TEMP_")) {
+        assert(commonErrorsInDoc.contains(errorClass),
+          s"Error class: $errorClass is not in sql-error-conditions.md")
+      }
+    }
+  }
+
   test("Round trip") {
     val tmpFile = File.createTempFile("rewritten", ".json")
     val mapper = JsonMapper.builder()
diff --git a/docs/sql-error-conditions-datatype-mismatch-error-class.md 
b/docs/sql-error-conditions-datatype-mismatch-error-class.md
index 6ccd63e6ee9..7d203432562 100644
--- a/docs/sql-error-conditions-datatype-mismatch-error-class.md
+++ b/docs/sql-error-conditions-datatype-mismatch-error-class.md
@@ -121,6 +121,10 @@ The key of map cannot be/contain `<keyType>`.
 
 The `<functionName>` does not support ordering on type `<dataType>`.
 
+## INVALID_ROW_LEVEL_OPERATION_ASSIGNMENTS
+
+`<errors>`
+
 ## IN_SUBQUERY_DATA_TYPE_MISMATCH
 
 The data type of one or more elements in the left hand side of an IN subquery 
is not compatible with the data type of the output of the subquery. Mismatched 
columns: [`<mismatchedColumns>`], left side: [`<leftType>`], right side: 
[`<rightType>`].
diff --git 
a/docs/sql-error-conditions-incompatible-data-to-table-error-class.md 
b/docs/sql-error-conditions-incompatible-data-to-table-error-class.md
deleted file mode 100644
index d1e633661a3..00000000000
--- a/docs/sql-error-conditions-incompatible-data-to-table-error-class.md
+++ /dev/null
@@ -1,64 +0,0 @@
----
-layout: global
-title: INCOMPATIBLE_DATA_TO_TABLE error class
-displayTitle: INCOMPATIBLE_DATA_TO_TABLE error class
-license: |
-  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.
----
-
-SQLSTATE: none assigned
-
-Cannot write incompatible data to table `<tableName>`:
-
-This error class has the following derived error classes:
-
-## AMBIGUOUS_COLUMN_NAME
-
-Ambiguous column name in the input data: `<colPath>`.
-
-## CANNOT_FIND_DATA
-
-Cannot find data for output column `<colPath>`.
-
-## CANNOT_SAFELY_CAST
-
-Cannot safely cast `<colPath>`: `<from>` to `<to>`.
-
-## EXTRA_STRUCT_FIELDS
-
-Cannot write extra fields to struct `<colPath>`: `<extraCols>`.
-
-## NULLABLE_ARRAY_ELEMENTS
-
-Cannot write nullable elements to array of non-nulls: `<colPath>`.
-
-## NULLABLE_COLUMN
-
-Cannot write nullable values to non-null column `<colPath>`.
-
-## NULLABLE_MAP_VALUES
-
-Cannot write nullable elements to array of non-nulls: `<colPath>`.
-
-## STRUCT_MISSING_FIELDS
-
-Struct `<colPath>` missing fields: `<missingFields>`.
-
-## UNEXPECTED_COLUMN_NAME
-
-Struct `<colPath>` `<order>`-th field name does not match (may be out of 
order): expected `<expected>`, found `<found>`.
-
-
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-insert-column-arity-mismatch.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-insert-column-arity-mismatch.md
index d80084bf01f..947cc67a414 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-insert-column-arity-mismatch.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INSERT_COLUMN_ARITY_MISMATCH error class
+displayTitle: INSERT_COLUMN_ARITY_MISMATCH error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,20 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+[SQLSTATE: 
21S01](sql-error-conditions-sqlstates.html#class-21-cardinality-violation)
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Cannot write to `<tableName>`, the reason is
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## NOT_ENOUGH_DATA_COLUMNS
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+not enough data columns:
+Table columns: `<tableColumns>`.
+Data columns: `<dataColumns>`.
 
+## TOO_MANY_DATA_COLUMNS
 
+too many data columns:
+Table columns: `<tableColumns>`.
+Data columns: `<dataColumns>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-insufficient-table-property.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-insufficient-table-property.md
index d80084bf01f..0ac89cbbe76 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-insufficient-table-property.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INSUFFICIENT_TABLE_PROPERTY error class
+displayTitle: INSUFFICIENT_TABLE_PROPERTY error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,14 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Can't find table property:
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
+## MISSING_KEY
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+`<key>`.
 
+## MISSING_KEY_PART
 
+`<key>`, `<totalAmountOfParts>` parts are expected.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-as-of-join.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-as-of-join.md
index d80084bf01f..39f190474e6 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-as-of-join.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: AS_OF_JOIN error class
+displayTitle: AS_OF_JOIN error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,14 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Invalid as-of join
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
+## TOLERANCE_IS_NON_NEGATIVE
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The input argument `tolerance` must be non-negative.
 
+## TOLERANCE_IS_UNFOLDABLE
 
+The input argument `tolerance` must be a constant.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-boundary.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-boundary.md
index d80084bf01f..c6871509629 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-boundary.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_BOUNDARY error class
+displayTitle: INVALID_BOUNDARY error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,14 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The boundary `<boundary>` is invalid: `<invalidValue>`.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
+## END
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Expected the value is '0', '`<longMaxValue>`', '[`<intMinValue>`, 
`<intMaxValue>`]'.
 
+## START
 
+Expected the value is '0', '`<longMinValue>`', '[`<intMinValue>`, 
`<intMaxValue>`]'.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-default-value.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-default-value.md
index d80084bf01f..5bfaca381b4 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-default-value.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_DEFAULT_VALUE error class
+displayTitle: INVALID_DEFAULT_VALUE error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,18 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Failed to execute `<statement>` command because the destination table column 
`<colName>` has a DEFAULT value `<defaultValue>`,
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
+## DATA_TYPE
 
-`<value>`.
+which requires `<expectedType>` type, but the statement provided a value of 
incompatible `<actualType>` type.
 
-## ZERO_INDEX
+## SUBQUERY_EXPRESSION
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+which contains subquery expressions.
 
+## UNRESOLVED_EXPRESSION
 
+which fails to resolve as a valid expression.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-inline-table.md
similarity index 58%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-inline-table.md
index d80084bf01f..feb4b909d17 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-inline-table.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_INLINE_TABLE error class
+displayTitle: INVALID_INLINE_TABLE error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,22 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Invalid inline table.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
+## CANNOT_EVALUATE_EXPRESSION_IN_INLINE_TABLE
 
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
+Cannot evaluate the expression `<expr>` in inline table definition.
 
-## PATTERN
+## FAILED_SQL_EXPRESSION_EVALUATION
 
-`<value>`.
+Failed to evaluate the SQL expression `<sqlExpr>`. Please check your syntax 
and ensure all required tables and columns are available.
 
-## ZERO_INDEX
+## INCOMPATIBLE_TYPES_IN_INLINE_TABLE
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Found incompatible types in the column `<colName>` for inline table.
 
+## NUM_COLUMNS_MISMATCH
 
+Inline table expected `<expectedNumCols>` columns but found `<actualNumCols>` 
columns in row `<rowIndex>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-lamdba-function-call.md
similarity index 60%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-lamdba-function-call.md
index d80084bf01f..e22150d325c 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-lamdba-function-call.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_LAMBDA_FUNCTION_CALL error class
+displayTitle: INVALID_LAMBDA_FUNCTION_CALL error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,18 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Invalid lambda function call.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
+## DUPLICATE_ARG_NAMES
 
-`<value>`.
+The lambda function has duplicate arguments <args>. Please, consider to rename 
the argument names or set <caseSensitiveConfig> to "true".
 
-## ZERO_INDEX
+## NON_HIGHER_ORDER_FUNCTION
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+A lambda function should only be used in a higher order function. However, its 
class is `<class>`, which is not a higher order function.
 
+## NUM_ARGS_MISMATCH
 
+A higher order function expects <expectedNumArgs> arguments, but got 
<actualNumArgs>.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-limit-like-expression.md
similarity index 65%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-limit-like-expression.md
index d80084bf01f..e4d3ee10ac6 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-limit-like-expression.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_LIMIT_LIKE_EXPRESSION error class
+displayTitle: INVALID_LIMIT_LIKE_EXPRESSION error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,22 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The limit like expression `<expr>` is invalid.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
+## DATA_TYPE
 
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
+The `<name>` expression must be integer type, but got `<dataType>`.
 
-## PATTERN
+## IS_NEGATIVE
 
-`<value>`.
+The `<name>` expression must be equal to or greater than 0, but got `<v>`.
 
-## ZERO_INDEX
+## IS_NULL
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The evaluated `<name>` expression must not be null.
 
+## IS_UNFOLDABLE
 
+The `<name>` expression must evaluate to a constant value.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-parameter-value-error-class.md
index d80084bf01f..370e6da3362 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-parameter-value-error-class.md
@@ -25,18 +25,30 @@ The value of parameter(s) `<parameter>` in `<functionName>` 
is invalid:
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## AES_CRYPTO_ERROR
 
 detail message: `<detailMessage>`
 
+## AES_IV_LENGTH
+
+supports 16-byte CBC IVs and 12-byte GCM IVs, but got `<actualLength>` bytes 
for `<mode>`.
+
 ## AES_KEY_LENGTH
 
 expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
 
+## DATETIME_UNIT
+
+expects one of the units without quotes YEAR, QUARTER, MONTH, WEEK, DAY, 
DAYOFYEAR, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND, but got the string 
literal `<invalidValue>`.
+
 ## PATTERN
 
 `<value>`.
 
+## REGEX_GROUP_INDEX
+
+Expects group index between 0 and `<groupCount>`, but got `<groupIndex>`.
+
 ## ZERO_INDEX
 
 expects `%1$`, `%2$` and so on, but got `%0$`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-partition-operation.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-partition-operation.md
index d80084bf01f..a96ab121c94 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-partition-operation.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_PARTITION_OPERATION error class
+displayTitle: INVALID_PARTITION_OPERATION error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,14 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The partition command is invalid.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
+## PARTITION_MANAGEMENT_IS_UNSUPPORTED
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Table `<name>` does not support partition management.
 
+## PARTITION_SCHEMA_IS_EMPTY
 
+Table `<name>` is not partitioned.
diff --git a/docs/sql-error-conditions-invalid-sql-syntax.md 
b/docs/sql-error-conditions-invalid-sql-syntax.md
new file mode 100644
index 00000000000..d11e9117779
--- /dev/null
+++ b/docs/sql-error-conditions-invalid-sql-syntax.md
@@ -0,0 +1,92 @@
+---
+layout: global
+title: INVALID_SQL_SYNTAX error class
+displayTitle: INVALID_SQL_SYNTAX error class
+license: |
+  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.
+---
+
+Invalid SQL syntax.
+
+This error class has the following derived error classes:
+
+## CREATE_TEMP_FUNC_WITH_IF_NOT_EXISTS
+
+CREATE TEMPORARY FUNCTION with IF NOT EXISTS is not allowed.
+
+## ANALYZE_TABLE_UNEXPECTED_NOSCAN
+
+ANALYZE TABLE(S) ... COMPUTE STATISTICS ... `<ctx>` must be either NOSCAN or 
empty.
+
+## SHOW_FUNCTIONS_INVALID_SCOPE
+
+SHOW `<scope>` FUNCTIONS not supported.
+
+## CREATE_TEMP_FUNC_WITH_DATABASE
+
+CREATE TEMPORARY FUNCTION with specifying a database(`<database>`) is not 
allowed.
+
+## REPETITIVE_WINDOW_DEFINITION
+
+The definition of window `<windowName>` is repetitive.
+
+## MULTI_PART_NAME
+
+`<statement>` with multiple part function name(`<funcName>`) is not allowed.
+
+## LATERAL_WITHOUT_SUBQUERY_OR_TABLE_VALUED_FUNC
+
+LATERAL can only be used with subquery and table-valued functions.
+
+## OPTION_IS_INVALID
+
+option or property key `<key>` is invalid; only `<supported>` are supported
+
+## INVALID_WINDOW_REFERENCE
+
+Window reference `<windowName>` is not a window specification.
+
+## CREATE_FUNC_WITH_IF_NOT_EXISTS_AND_REPLACE
+
+CREATE FUNCTION with both IF NOT EXISTS and REPLACE is not allowed.
+
+## EMPTY_PARTITION_VALUE
+
+Partition key `<partKey>` must set value.
+
+## TRANSFORM_WRONG_NUM_ARGS
+
+The transform`<transform>` requires `<expectedNum>` parameters but the actual 
number is `<actualNum>`.
+
+## SHOW_FUNCTIONS_INVALID_PATTERN
+
+Invalid pattern in SHOW FUNCTIONS: `<pattern>`. It must be a "STRING" literal.
+
+## UNSUPPORTED_FUNC_NAME
+
+Unsupported function name `<funcName>`.
+
+## INVALID_COLUMN_REFERENCE
+
+Expected a column reference for transform `<transform>`: `<expr>`.
+
+## UNRESOLVED_WINDOW_REFERENCE
+
+Cannot resolve window reference `<windowName>`.
+
+## INVALID_TABLE_VALUED_FUNC_NAME
+
+Table valued function cannot specify database name: `<funcName>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-time-travel-timestamp-expr.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-time-travel-timestamp-expr.md
index d80084bf01f..edef9551a0e 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-time-travel-timestamp-expr.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_TIME_TRAVEL_TIMESTAMP_EXPR error class
+displayTitle: INVALID_TIME_TRAVEL_TIMESTAMP_EXPR error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,18 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The time travel timestamp expression `<expr>` is invalid.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
+## INPUT
 
-`<value>`.
+Cannot be casted to the "TIMESTAMP" type.
 
-## ZERO_INDEX
+## NON_DETERMINISTIC
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Must be deterministic.
 
+## UNEVALUABLE
 
+Must be evaluable.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-invalid-write-distribution.md
similarity index 63%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-invalid-write-distribution.md
index d80084bf01f..0dccd8b9714 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-invalid-write-distribution.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: INVALID_WRITE_DISTRIBUTION error class
+displayTitle: INVALID_WRITE_DISTRIBUTION error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,18 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The requested write distribution is invalid.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
+## PARTITION_NUM_AND_SIZE
 
-`<value>`.
+The partition number and advisory partition size can't be specified at the 
same time.
 
-## ZERO_INDEX
+## PARTITION_NUM_WITH_UNSPECIFIED_DISTRIBUTION
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The number of partitions can't be specified with unspecified distribution.
 
+## PARTITION_SIZE_WITH_UNSPECIFIED_DISTRIBUTION
 
+The advisory partition size can't be specified with unspecified distribution.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-malformed-record-in-parsing.md
similarity index 70%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-malformed-record-in-parsing.md
index d80084bf01f..77d21553258 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-malformed-record-in-parsing.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: MALFORMED_RECORD_IN_PARSING error class
+displayTitle: MALFORMED_RECORD_IN_PARSING error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -21,24 +21,14 @@ license: |
 
 [SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Malformed records are detected in record parsing: `<badRecord>`.
+Parse Mode: `<failFastMode>`. To process malformed records as null result, try 
setting the option 'mode' as 'PERMISSIVE'.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## CANNOT_PARSE_JSON_ARRAYS_AS_STRUCTS
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Parsing JSON arrays as structs is forbidden.
 
+## WITHOUT_SUGGESTION
 
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-missing-attributes.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-missing-attributes.md
index d80084bf01f..22e26419f6f 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-missing-attributes.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: MISSING_ATTRIBUTES error class
+displayTitle: MISSING_ATTRIBUTES error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,16 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+SQLSTATE: none assigned
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Resolved attribute(s) `<missingAttributes>` missing from `<input>` in operator 
`<operator>`.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## RESOLVED_ATTRIBUTE_APPEAR_IN_OPERATION
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Attribute(s) with the same name appear in the operation: `<operation>`.
+Please check if the right attribute(s) are used.
 
+## RESOLVED_ATTRIBUTE_MISSING_FROM_INPUT
 
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-not-a-constant-string-error-class.md
similarity index 60%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-not-a-constant-string-error-class.md
index d80084bf01f..d83a07b8d6e 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-not-a-constant-string-error-class.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: NOT_A_CONSTANT_STRING error class
+displayTitle: NOT_A_CONSTANT_STRING error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,20 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+[SQLSTATE: 
42601](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+The expression `<expr>` used for the routine or clause `<name>` must be a 
constant STRING which is NOT NULL.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## NOT_CONSTANT
 
-detail message: `<detailMessage>`
+To be considered constant the expression must not depend on any columns, 
contain a subquery, or invoke a non deterministic function such as rand().
 
-## AES_KEY_LENGTH
+## NULL
 
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The expression evaluates to NULL.
 
+## WRONG_TYPE
 
+The data type of the expression is `<dataType>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-not-allowed-in-from.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-not-allowed-in-from.md
index d80084bf01f..a7b32a0b844 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-not-allowed-in-from.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: NOT_ALLOWED_IN_FROM error class
+displayTitle: NOT_ALLOWED_IN_FROM error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,18 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Not allowed in the FROM clause:
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
+## LATERAL_WITH_PIVOT
 
-`<value>`.
+LATERAL together with PIVOT.
 
-## ZERO_INDEX
+## LATERAL_WITH_UNPIVOT
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+LATERAL together with UNPIVOT.
 
+## UNPIVOT_WITH_PIVOT
 
+UNPIVOT together with PIVOT.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-not-supported-in-jdbc-catalog.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-not-supported-in-jdbc-catalog.md
index d80084bf01f..3d93592549f 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-not-supported-in-jdbc-catalog.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: NOT_SUPPORTED_IN_JDBC_CATALOG error class
+displayTitle: NOT_SUPPORTED_IN_JDBC_CATALOG error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,16 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+[SQLSTATE: 46110](sql-error-conditions-sqlstates.html#class-46-java-ddl-1)
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Not supported command in JDBC catalog:
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## COMMAND
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+`<cmd>`
 
+## COMMAND_WITH_PROPERTY
 
+`<cmd>` with property `<property>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-unsupported-add-file.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-unsupported-add-file.md
index d80084bf01f..e7e6217e476 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-unsupported-add-file.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: UNSUPPORTED_ADD_FILE error class
+displayTitle: UNSUPPORTED_ADD_FILE error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,16 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+SQLSTATE: none assigned
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Don't support add file.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## DIRECTORY
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The file `<path>` is a directory, consider to set 
"spark.sql.legacy.addSingleFileInAddFile" to "false".
 
+## LOCAL_DIRECTORY
 
+The local directory `<path>` is not supported in a non-local master mode.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-unsupported-default-value.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-unsupported-default-value.md
index d80084bf01f..17a15d7091b 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-unsupported-default-value.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: UNSUPPORTED_DEFAULT_VALUE error class
+displayTitle: UNSUPPORTED_DEFAULT_VALUE error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,14 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
-
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+DEFAULT column values is not supported.
 
 This error class has the following derived error classes:
 
-## AES_KEY
-
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
+## WITHOUT_SUGGESTION
 
-expects `%1$`, `%2$` and so on, but got `%0$`.
+AES-`<mode>` with the padding `<padding>` by the `<functionName>` function.
 
+## WITH_SUGGESTION
 
+Enable it by setting "spark.sql.defaultColumn.enabled" to "true".
diff --git a/docs/sql-error-conditions-unsupported-feature-error-class.md 
b/docs/sql-error-conditions-unsupported-feature-error-class.md
index 78bf301c49d..232338bb12b 100644
--- a/docs/sql-error-conditions-unsupported-feature-error-class.md
+++ b/docs/sql-error-conditions-unsupported-feature-error-class.md
@@ -29,6 +29,14 @@ This error class has the following derived error classes:
 
 AES-`<mode>` with the padding `<padding>` by the `<functionName>` function.
 
+## AES_MODE_AAD
+
+`<functionName>` with AES-`<mode>` does not support additional authenticate 
data (AAD).
+
+## AES_MODE_IV
+
+`<functionName>` with AES-`<mode>` does not support initialization vectors 
(IVs).
+
 ## ANALYZE_UNCACHED_TEMP_VIEW
 
 The ANALYZE TABLE FOR COLUMNS command can operate on temporary views that have 
been cached already. Consider to cache the view `<viewName>`.
@@ -49,10 +57,18 @@ Catalog `<catalogName>` does not support `<operation>`.
 
 Combination of ORDER BY/SORT BY/DISTRIBUTE BY/CLUSTER BY.
 
+## COMMENT_NAMESPACE
+
+Attach a comment to the namespace `<namespace>`.
+
 ## DESC_TABLE_COLUMN_PARTITION
 
 DESC TABLE COLUMN for a specific partition.
 
+## DROP_NAMESPACE
+
+Drop the namespace `<namespace>`.
+
 ## INSERT_PARTITION_SPEC_IF_NOT_EXISTS
 
 INSERT INTO `<tableName>` with IF NOT EXISTS in the PARTITION spec.
@@ -93,6 +109,14 @@ Unable to convert `<orcType>` of Orc to data type 
`<toType>`.
 
 Pandas user defined aggregate function in the PIVOT clause.
 
+## PARAMETER_MARKER_IN_UNEXPECTED_STATEMENT
+
+Parameter markers are not allowed in `<statement>`.
+
+## PARTITION_WITH_NESTED_COLUMN_IS_UNSUPPORTED
+
+Invalid partitioning: `<cols>` is missing or is in a map or array.
+
 ## PIVOT_AFTER_GROUP_BY
 
 PIVOT clause following a GROUP BY clause. Consider pushing the GROUP BY into a 
subquery.
@@ -105,10 +129,18 @@ Pivoting by the value '`<value>`' of the column data type 
`<type>`.
 
 Python UDF in the ON clause of a `<joinType>` JOIN. In case of an INNNER JOIN 
consider rewriting to a CROSS JOIN with a WHERE clause.
 
+## REMOVE_NAMESPACE_COMMENT
+
+Remove a comment from the namespace `<namespace>`.
+
 ## SET_NAMESPACE_PROPERTY
 
 `<property>` is a reserved namespace property, `<msg>`.
 
+## SET_OPERATION_ON_MAP_TYPE
+
+Cannot have MAP type columns in DataFrame which calls set operations 
(INTERSECT, EXCEPT, etc.), but the type of column `<colName>` is `<dataType>`.
+
 ## SET_PROPERTIES_AND_DBPROPERTIES
 
 set PROPERTIES and DBPROPERTIES at the same time.
@@ -121,6 +153,10 @@ set PROPERTIES and DBPROPERTIES at the same time.
 
 Table `<tableName>` does not support `<operation>`. Please check the current 
catalog and namespace to make sure the qualified table name is expected, and 
also check the catalog implementation which is configured by 
"spark.sql.catalog".
 
+## TIME_TRAVEL
+
+Time travel on the relation: `<relationId>`.
+
 ## TOO_MANY_TYPE_ARGUMENTS_FOR_UDF_CLASS
 
 UDF class with `<num>` type arguments.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-unsupported-insert.md
similarity index 65%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-unsupported-insert.md
index d80084bf01f..98eed0a5b2c 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-unsupported-insert.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: UNSUPPORTED_INSERT error class
+displayTitle: UNSUPPORTED_INSERT error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,24 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+SQLSTATE: none assigned
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Can't insert into the target.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## NOT_ALLOWED
 
-detail message: `<detailMessage>`
+The target relation `<relationId>` does not allow insertion.
 
-## AES_KEY_LENGTH
+## NOT_PARTITIONED
 
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
+The target relation `<relationId>` is not partitioned.
 
-## PATTERN
+## RDD_BASED
 
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+An RDD-based table is not allowed.
 
+## READ_FROM
 
+The target relation `<relationId>` is also being read from.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-unsupported-merge-condition.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-unsupported-merge-condition.md
index d80084bf01f..9b507f6e855 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-unsupported-merge-condition.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: UNSUPPORTED_MERGE_CONDITION error class
+displayTitle: UNSUPPORTED_MERGE_CONDITION error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,20 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+SQLSTATE: none assigned
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+MERGE operation contains unsupported `<condName>` condition.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## AGGREGATE
 
-detail message: `<detailMessage>`
+Aggregates are not allowed: `<cond>`.
 
-## AES_KEY_LENGTH
+## NON_DETERMINISTIC
 
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+Non-deterministic expressions are not allowed: `<cond>`.
 
+## SUBQUERY
 
+Subqueries are not allowed: `<cond>`.
diff --git a/docs/sql-error-conditions-invalid-parameter-value-error-class.md 
b/docs/sql-error-conditions-unsupported-overwrite.md
similarity index 64%
copy from docs/sql-error-conditions-invalid-parameter-value-error-class.md
copy to docs/sql-error-conditions-unsupported-overwrite.md
index d80084bf01f..2f8226ea358 100644
--- a/docs/sql-error-conditions-invalid-parameter-value-error-class.md
+++ b/docs/sql-error-conditions-unsupported-overwrite.md
@@ -1,7 +1,7 @@
 ---
 layout: global
-title: INVALID_PARAMETER_VALUE error class
-displayTitle: INVALID_PARAMETER_VALUE error class
+title: UNSUPPORTED_OVERWRITE error class
+displayTitle: UNSUPPORTED_OVERWRITE error class
 license: |
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
@@ -19,26 +19,16 @@ license: |
   limitations under the License.
 ---
 
-[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
+SQLSTATE: none assigned
 
-The value of parameter(s) `<parameter>` in `<functionName>` is invalid:
+Can't overwrite the target that is also being read from.
 
 This error class has the following derived error classes:
 
-## AES_KEY
+## PATH
 
-detail message: `<detailMessage>`
-
-## AES_KEY_LENGTH
-
-expects a binary value with 16, 24 or 32 bytes, but got `<actualLength>` bytes.
-
-## PATTERN
-
-`<value>`.
-
-## ZERO_INDEX
-
-expects `%1$`, `%2$` and so on, but got `%0$`.
+The target path is `<path>`.
 
+## TABLE
 
+The target table is `<table>`.
diff --git a/docs/sql-error-conditions.md b/docs/sql-error-conditions.md
index 13068729539..47836e9cc05 100644
--- a/docs/sql-error-conditions.md
+++ b/docs/sql-error-conditions.md
@@ -23,6 +23,32 @@ This is a list of common, named error conditions returned by 
Spark SQL.
 
 Also see [SQLSTATE Codes](sql-error-conditions-sqlstates.html).
 
+### AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
+
+SQLSTATE: none assigned
+
+Non-deterministic expression `<sqlExpr>` should not appear in the arguments of 
an aggregate function.
+
+### ALL_PARTITION_COLUMNS_NOT_ALLOWED
+
+SQLSTATE: none assigned
+
+Cannot use all columns for partition columns.
+
+### ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE
+
+[SQLSTATE: 
42710](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+ALTER TABLE `<type>` column `<columnName>` specifies descriptor 
"`<optionName>`" more than once, which is invalid.
+
+### AMBIGUOUS_ALIAS_IN_NESTED_CTE
+
+SQLSTATE: none assigned
+
+Name <name> is ambiguous in nested CTE.
+Please set <config> to "CORRECTED" so that name defined in inner CTE takes 
precedence. If set it to "LEGACY", outer CTE definitions will take precedence.
+See '<docroot>/sql-migration-guide.html#query-engine'.
+
 ### AMBIGUOUS_COLUMN_OR_FIELD
 
 [SQLSTATE: 
42702](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -53,6 +79,38 @@ Ambiguous reference to the field `<field>`. It appears 
`<count>` times in the sc
 
 `<message>`.`<alternative>` If necessary set `<config>` to "false" to bypass 
this error.
 
+### [AS_OF_JOIN](sql-error-conditions-invalid-as-of-join.html)
+
+SQLSTATE: none assigned
+
+Invalid as-of join.
+
+For more details see [AS_OF_JOIN](sql-error-conditions-invalid-as-of-join.html)
+
+### AVRO_INCORRECT_TYPE
+
+SQLSTATE: none assigned
+
+Cannot convert Avro `<avroPath>` to SQL `<sqlPath>` because the original 
encoded data type is `<avroType>`, however you're trying to read the field as 
`<sqlType>`, which would lead to an incorrect answer. To allow reading this 
field, enable the SQL configuration: `<key>`.
+
+### AVRO_LOWER_PRECISION
+
+SQLSTATE: none assigned
+
+Cannot convert Avro `<avroPath>` to SQL `<sqlPath>` because the original 
encoded data type is `<avroType>`, however you're trying to read the field as 
`<sqlType>`, which leads to data being read as null. Please provide a wider 
decimal type to get the correct result. To allow reading null to this field, 
enable the SQL configuration: `<key>`.
+
+### BATCH_METADATA_NOT_FOUND
+
+[SQLSTATE: 
42K03](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+Unable to find batch `<batchMetadataFile>`.
+
+### BINARY_ARITHMETIC_OVERFLOW
+
+[SQLSTATE: 22003](sql-error-conditions-sqlstates.html#class-22-data-exception)
+
+`<value1>` `<symbol>` `<value2>` caused overflow.
+
 ### CANNOT_CAST_DATATYPE
 
 [SQLSTATE: 
42846](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -107,6 +165,16 @@ Could not load Protobuf class with name 
`<protobufClassName>`. `<explanation>`.
 
 Failed to merge incompatible data types `<left>` and `<right>`.
 
+### CANNOT_MERGE_SCHEMAS
+
+[SQLSTATE: 
42KD9](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+Failed merging schemas:
+Initial schema:
+`<left>`
+Schema that cannot be merged with the initial schema:
+`<right>`.
+
 ### CANNOT_MODIFY_CONFIG
 
 [SQLSTATE: 46110](sql-error-conditions-sqlstates.html#class-46-java-ddl-1)
@@ -119,6 +187,12 @@ See also 
'`<docroot>`/sql-migration-guide.html#ddl-statements'.
 
 [SQLSTATE: 22018](sql-error-conditions-sqlstates.html#class-22-data-exception)
 
+### CANNOT_PARSE_INTERVAL
+
+SQLSTATE: none assigned
+
+Unable to parse `<intervalString>`. Please ensure that the value provided is 
in a valid format for defining an interval. You can reference the documentation 
for the correct format. If the issue persists, please double check that the 
input value is not null or empty and try again.
+
 Cannot parse decimal.
 
 ### CANNOT_PARSE_JSON_FIELD
@@ -145,6 +219,18 @@ SQLSTATE: none assigned
 
 Could not read footer for file: `<file>`.
 
+### CANNOT_RENAME_ACROSS_SCHEMA
+
+[SQLSTATE: 
0AKD0](sql-error-conditions-sqlstates.html#class-0A-feature-not-supported)
+
+Renaming a `<type>` across schemas is not allowed.
+
+### CANNOT_RESOLVE_STAR_EXPAND
+
+SQLSTATE: none assigned
+
+Cannot resolve `<targetString>`.* given input columns `<columns>`. Please 
check that the specified table or struct exists and is accessible in the input 
columns.
+
 ### CANNOT_RECOGNIZE_HIVE_TYPE
 
 [SQLSTATE: 
429BB](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -183,12 +269,36 @@ The value `<value>` of the type `<sourceType>` cannot be 
cast to `<targetType>`
 
 Fail to insert a value of `<sourceType>` type into the `<targetType>` type 
column `<columnName>` due to an overflow. Use `try_cast` on the input value to 
tolerate overflow and return NULL instead.
 
+### CODEC_NOT_AVAILABLE
+
+SQLSTATE: none assigned
+
+The codec `<codecName>` is not available. Consider to set the config 
`<configKey>` to `<configVal>`.
+
+### CODEC_SHORT_NAME_NOT_FOUND
+
+SQLSTATE: none assigned
+
+Cannot find a short name for the codec `<codecName>`.
+
+### COLUMN_ALIASES_IS_NOT_ALLOWED
+
+SQLSTATE: none assigned
+
+Columns aliases are not allowed in `<op>`.
+
 ### COLUMN_ALREADY_EXISTS
 
 [SQLSTATE: 
42711](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
 The column `<columnName>` already exists. Consider to choose another name or 
rename the existing column.
 
+### COLUMN_NOT_DEFINED_IN_TABLE
+
+SQLSTATE: none assigned
+
+`<colType>` column `<colName>` is not defined in table `<tableName>`, defined 
table columns are: `<tableCols>`.
+
 ### COLUMN_NOT_FOUND
 
 [SQLSTATE: 
42703](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -207,6 +317,14 @@ SQLSTATE: none assigned
 
 Another instance of this query was just started by a concurrent session.
 
+### CONCURRENT_STREAM_LOG_UPDATE
+
+<!-- TODO Add 40000 link -->
+SQLSTATE: 40000
+
+Concurrent update to the log. Multiple streaming jobs detected for `<batchId>`.
+Please make sure only one streaming job runs on a specific checkpoint location 
at a time.
+
 ### [CONNECT](sql-error-conditions-connect-error-class.html)
 
 SQLSTATE: none assigned
@@ -221,11 +339,17 @@ Generic Spark Connect error.
 
 The value `<str>` (`<fmt>`) cannot be converted to `<targetType>` because it 
is malformed. Correct the value as per the syntax, or change its format. Use 
`<suggestion>` to tolerate malformed input and return NULL instead.
 
-### CREATE_TABLE_COLUMN_OPTION_DUPLICATE
+### CREATE_PERMANENT_VIEW_WITHOUT_ALIAS
+
+SQLSTATE: none assigned
+
+Not allowed to create the permanent view `<name>` without explicitly assigning 
an alias for the expression `<attr>`.
+
+### CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE
 
 [SQLSTATE: 
42710](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
-CREATE TABLE column `<columnName>` specifies option "`<optionName>`" more than 
once, which is invalid.
+CREATE TABLE column `<columnName>` specifies descriptor "`<optionName>`" more 
than once, which is invalid.
 
 ### 
[DATATYPE_MISMATCH](sql-error-conditions-datatype-mismatch-error-class.html)
 
@@ -265,18 +389,42 @@ Decimal precision `<precision>` exceeds max precision 
`<maxPrecision>`.
 
 Default database `<defaultDatabase>` does not exist, please create it first or 
change default database to ``<defaultDatabase>``.
 
+### DISTINCT_WINDOW_FUNCTION_UNSUPPORTED
+
+SQLSTATE: none assigned
+
+Distinct window functions are not supported: `<windowExpr>`.
+
 ### DIVIDE_BY_ZERO
 
 [SQLSTATE: 22012](sql-error-conditions-sqlstates.html#class-22-data-exception)
 
 Division by zero. Use `try_divide` to tolerate divisor being 0 and return NULL 
instead. If necessary set `<config>` to "false" to bypass this error.
 
+### DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT
+
+SQLSTATE: none assigned
+
+Duplicated field names in Arrow Struct are not allowed, got <fieldNames>.
+
 ### DUPLICATED_MAP_KEY
 
 [SQLSTATE: 
23505](sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation)
 
 Duplicate map key `<key>` was found, please check the input data. If you want 
to remove the duplicated keys, you can set `<mapKeyDedupPolicy>` to "LAST_WIN" 
so that the key inserted at last takes precedence.
 
+### DUPLICATED_METRICS_NAME
+
+SQLSTATE: none assigned
+
+The metric name is not unique: `<metricName>`. The same name cannot be used 
for metrics with different results. However multiple instances of metrics with 
with same result and name are allowed (e.g. self-joins).
+
+### DUPLICATE_CLAUSES
+
+SQLSTATE: none assigned
+
+Found duplicate clauses: `<clauseName>`. Please, remove one of them.
+
 ### DUPLICATE_KEY
 
 [SQLSTATE: 
23505](sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation)
@@ -295,6 +443,24 @@ SQLSTATE: none assigned
 
 Not found an encoder of the type `<typeName>` to Spark SQL internal 
representation. Consider to change the input type to one of supported at 
'`<docroot>`/sql-ref-datatypes.html'.
 
+### EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE
+
+SQLSTATE: none assigned
+
+The event time `<eventName>` has the invalid type `<eventType>`, but expected 
"TIMESTAMP".
+
+### EXCEED_LIMIT_LENGTH
+
+SQLSTATE: none assigned
+
+Exceeds char/varchar type length limitation: `<limit>`.
+
+### EXPRESSION_TYPE_IS_NOT_ORDERABLE
+
+SQLSTATE: none assigned
+
+Column expression `<expr>` cannot be sorted because its type `<exprType>` is 
not orderable.
+
 ### FAILED_EXECUTE_UDF
 
 [SQLSTATE: 
39000](sql-error-conditions-sqlstates.html#class-39-external-routine-invocation-exception)
@@ -307,6 +473,12 @@ Failed to execute user defined function (`<functionName>`: 
(`<signature>`) => `<
 
 Failed preparing of the function `<funcName>` for call. Please, double check 
function's arguments.
 
+### FAILED_PARSE_STRUCT_TYPE
+
+[SQLSTATE: 22018](sql-error-conditions-sqlstates.html#class-22-data-exception)
+
+Failed parsing struct: `<raw>`.
+
 ### FAILED_RENAME_PATH
 
 [SQLSTATE: 
42K04](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -379,6 +551,30 @@ GROUP BY `<index>` refers to an expression `<aggExpr>` 
that contains an aggregat
 
 GROUP BY position `<index>` is not in select list (valid range is [1, 
`<size>`]).
 
+### GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
+
+SQLSTATE: none assigned
+
+The expression `<sqlExpr>` cannot be used as a grouping expression because its 
data type <dataType> is not an orderable data type.
+
+### HLL_INVALID_INPUT_SKETCH_BUFFER
+
+SQLSTATE: none assigned
+
+Invalid call to <function>; only valid HLL sketch buffers are supported as 
inputs (such as those produced by the `hll_sketch_agg` function)."
+
+### HLL_INVALID_LG_K
+
+SQLSTATE: none assigned
+
+Invalid call to <function>; the `lgConfigK` value must be between <min> and 
<max>, inclusive: <value>."
+
+### HLL_UNION_DIFFERENT_LG_K
+
+SQLSTATE: none assigned
+
+Sketches have different `lgConfigK` values: <left> and <right>. Set the 
`allowDifferentLgConfigK` parameter to true to call <function> with different 
`lgConfigK` values."
+
 ### IDENTIFIER_TOO_MANY_NAME_PARTS
 
 [SQLSTATE: 
42601](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -457,12 +653,53 @@ Cannot create the index `<indexName>` on table 
`<tableName>` because it already
 
 Cannot find the index `<indexName>` on table `<tableName>`.
 
+### INSERT_PARTITION_COLUMN_ARITY_MISMATCH
+
+[SQLSTATE: 
21S01](sql-error-conditions-sqlstates.html#class-21-cardinality-violation)
+
+Cannot write to '`<tableName>`', `<reason>`:
+Table columns: `<tableColumns>`.
+Partition columns with static values: `<staticPartCols>`.
+Data columns: `<dataColumns>`.
+
+### 
[INSUFFICIENT_TABLE_PROPERTY](sql-error-conditions-insufficient-table-property.html)
+
+SQLSTATE: none assigned
+
+Can't find table property:
+
+ For more details see 
[INSUFFICIENT_TABLE_PROPERTY](sql-error-conditions-insufficient-table-property.html)
+
 ### INTERNAL_ERROR
 
 [SQLSTATE: XX000](sql-error-conditions-sqlstates.html#class-XX-internal-error)
 
 `<message>`
 
+### INTERNAL_ERROR_BROADCAST
+
+[SQLSTATE: XX000](sql-error-conditions-sqlstates.html#class-XX-internal-error)
+
+`<message>`
+
+### INTERNAL_ERROR_EXECUTOR
+
+[SQLSTATE: XX000](sql-error-conditions-sqlstates.html#class-XX-internal-error)
+
+`<message>`
+
+### INTERNAL_ERROR_MEMORY
+
+[SQLSTATE: XX000](sql-error-conditions-sqlstates.html#class-XX-internal-error)
+
+`<message>`
+
+### INTERNAL_ERROR_NETWORK
+
+[SQLSTATE: XX000](sql-error-conditions-sqlstates.html#class-XX-internal-error)
+
+`<message>`
+
 ### INTERVAL_ARITHMETIC_OVERFLOW
 
 [SQLSTATE: 22015](sql-error-conditions-sqlstates.html#class-22-data-exception)
@@ -487,6 +724,14 @@ The index `<indexValue>` is out of bounds. The array has 
`<arraySize>` elements.
 
 The index `<indexValue>` is out of bounds. The array has `<arraySize>` 
elements. Use `try_element_at` to tolerate accessing element at invalid index 
and return NULL instead. If necessary set `<ansiConfig>` to "false" to bypass 
this error.
 
+### [INVALID_BOUNDARY](sql-error-conditions-invalid-boundary.html)
+
+SQLSTATE: none assigned
+
+The boundary `<boundary>` is invalid: `<invalidValue>`.
+
+ For more details see 
[INVALID_BOUNDARY](sql-error-conditions-invalid-boundary.html)
+
 ### INVALID_BUCKET_FILE
 
 SQLSTATE: none assigned
@@ -511,12 +756,46 @@ The datasource `<datasource>` cannot save the column 
`<columnName>` because its
 
 Column or field `<name>` is of type `<type>` while it's required to be 
`<expectedType>`.
 
+### [INVALID_DEFAULT_VALUE](sql-error-conditions-invalid-default-value.html)
+
+SQLSTATE: none assigned
+
+Failed to execute `<statement>` command because the destination table column 
`<colName>` has a DEFAULT value `<defaultValue>`,
+    
+ For more details see 
[INVALID_DEFAULT_VALUE](sql-error-conditions-invalid-default-value.html)
+
+### INVALID_DRIVER_MEMORY
+
+<!-- TODO Add F0000 link -->
+SQLSTATE: F0000
+
+System memory `<systemMemory>` must be at least `<minSystemMemory>`. Please 
increase heap size using the --driver-memory option or "`<config>`" in Spark 
configuration.
+
 ### INVALID_EMPTY_LOCATION
 
 [SQLSTATE: 
42K05](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
 The location name cannot be empty string, but ``<location>`` was given.
 
+### INVALID_ESC
+
+SQLSTATE: none assigned
+
+Found an invalid escape string: `<invalidEscape>`. The escape string must 
contain only one character.
+
+### INVALID_ESCAPE_CHAR
+
+SQLSTATE: none assigned
+
+`EscapeChar` should be a string literal of length one, but got `<sqlExpr>`.
+
+### INVALID_EXECUTOR_MEMORY
+
+<!-- TODO Add F0000 link -->
+SQLSTATE: F0000
+
+Executor memory `<executorMemory>` must be at least `<minSystemMemory>`. 
Please increase executor memory using the --executor-memory option or 
"`<config>`" in Spark configuration."
+
 ### INVALID_EXTRACT_BASE_FIELD_TYPE
 
 [SQLSTATE: 
42000](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -555,6 +834,12 @@ The format is invalid: `<format>`.
 
 The fraction of sec must be zero. Valid range is [0, 60]. If necessary set 
`<ansiConfig>` to "false" to bypass this error.
 
+### INVALID_HIVE_COLUMN_NAME
+
+SQLSTATE: none assigned
+
+Cannot create the table `<tableName>` having the nested column `<columnName>` 
whose name contains invalid characters `<invalidChars>` in Hive metastore.
+
 ### INVALID_IDENTIFIER
 
 [SQLSTATE: 
42602](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -579,12 +864,40 @@ Cannot convert JSON root field to target Spark type.
 
 Input schema `<jsonSchema>` can only contain STRING as a key type for a MAP.
 
+### 
[INVALID_LAMBDA_FUNCTION_CALL](sql-error-conditions-invalid-lamdba-function-call.html)
+
+SQLSTATE: none assigned
+
+Invalid lambda function call.
+
+For more details see 
[INVALID_LAMBDA_FUNCTION_CALL](sql-error-conditions-invalid-lamdba-function-call.html)
+
 ### INVALID_LATERAL_JOIN_TYPE
 
 [SQLSTATE: 
42613](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
 The `<joinType>` JOIN with LATERAL correlation is not allowed because an OUTER 
subquery cannot correlate to its join partner. Remove the LATERAL correlation 
or use an INNER JOIN, or LEFT OUTER JOIN instead.
 
+### 
[INVALID_LIMIT_LIKE_EXPRESSION](sql-error-conditions-invalid-limit-like-expression.html)
+
+SQLSTATE: none assigned
+
+The limit like expression `<expr>` is invalid.
+
+For more details see 
[INVALID_LIMIT_LIKE_EXPRESSION](sql-error-conditions-invalid-limit-like-expression.html)
+
+### INVALID_NON_DETERMINISTIC_EXPRESSIONS
+
+SQLSTATE: none assigned
+
+The operator expects a deterministic expression, but the actual expression is 
`<sqlExprs>`.
+
+### INVALID_NUMERIC_LITERAL_RANGE
+
+SQLSTATE: none assigned
+
+Numeric literal `<rawStrippedQualifier>` is outside the valid range for 
`<typeName>` with minimum value of `<minValue>` and maximum value of 
`<maxValue>`. Please adjust the value accordingly.
+
 ### [INVALID_OPTIONS](sql-error-conditions-invalid-options-error-class.html)
 
 [SQLSTATE: 
42K06](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -607,6 +920,14 @@ The value of parameter(s) `<parameter>` in 
`<functionName>` is invalid:
 
  For more details see 
[INVALID_PARAMETER_VALUE](sql-error-conditions-invalid-parameter-value-error-class.html)
 
+### 
[INVALID_PARTITION_OPERATION](sql-error-conditions-invalid-partition-operation.html)
+
+SQLSTATE: none assigned
+
+The partition command is invalid.
+
+For more details see 
[INVALID_PARTITION_OPERATION](sql-error-conditions-invalid-partition-operation.html)
+
 ### INVALID_PROPERTY_KEY
 
 [SQLSTATE: 
42602](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -639,7 +960,7 @@ SQLSTATE: none assigned
 
 The argument `<name>` of `sql()` is invalid. Consider to replace it by a SQL 
literal.
 
-### INVALID_SQL_SYNTAX
+### [INVALID_SQL_SYNTAX](sql-error-conditions-invalid-sql-syntax.html)
 
 [SQLSTATE: 
42000](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
@@ -659,12 +980,44 @@ SQLSTATE: none assigned
 
 Cannot create the persistent object `<objName>` of the type `<obj>` because it 
references to the temporary object `<tempObjName>` of the type `<tempObj>`. 
Please make the temporary object `<tempObjName>` persistent, or make the 
persistent object `<objName>` temporary.
 
+### 
[INVALID_TIME_TRAVEL_TIMESTAMP_EXPR](sql-error-conditions-invalid-time-travel-timestamp-expr.html)
+
+SQLSTATE: none assigned
+
+The time travel timestamp expression `<expr>` is invalid.
+
+ For more details see 
[INVALID_TIME_TRAVEL_TIMESTAMP_EXPR](sql-error-conditions-invalid-time-travel-timestamp-expr.html)
+
 ### INVALID_TYPED_LITERAL
 
 [SQLSTATE: 
42604](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
 The value of the typed literal `<valueType>` is invalid: `<value>`.
 
+### INVALID_UDF_IMPLEMENTATION
+
+SQLSTATE: none assigned
+
+Function <funcName> does not implement ScalarFunction or AggregateFunction.
+
+### INVALID_URL
+
+SQLSTATE: none assigned
+
+The url is invalid: `<url>`. If necessary set `<ansiConfig>` to "false" to 
bypass this error.
+
+### INVALID_USAGE_OF_STAR_OR_REGEX
+
+[SQLSTATE: 
42000](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+Invalid usage of `<elem>` in `<prettyName>`.
+
+### INVALID_VIEW_TEXT
+
+SQLSTATE: none assigned
+
+The view `<viewName>` cannot be displayed due to invalid view text: 
`<viewText>`. This may be caused by an unauthorized modification of the view or 
an incorrect query syntax. Please check your query syntax and verify that the 
view has not been tampered with.
+
 ### INVALID_WHERE_CONDITION
 
 [SQLSTATE: 
42903](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -673,6 +1026,32 @@ The WHERE condition `<condition>` contains invalid 
expressions: `<expressionList
 
 Rewrite the query to avoid window functions, aggregate functions, and 
generator functions in the WHERE clause.
 
+### INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC
+
+SQLSTATE: none assigned
+
+Cannot specify ORDER BY or a window frame for `<aggFunc>`.
+
+### 
[INVALID_WRITE_DISTRIBUTION](sql-error-conditions-invalid-write-distribution.html)
+
+SQLSTATE: none assigned
+
+The requested write distribution is invalid.
+
+ For more details see 
[INVALID_WRITE_DISTRIBUTION](sql-error-conditions-invalid-write-distribution.html)
+
+### JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE
+
+SQLSTATE: none assigned
+
+The join condition `<joinCondition>` has the invalid type `<conditionType>`, 
expected "BOOLEAN".
+
+### LOCAL_MUST_WITH_SCHEMA_FILE
+
+SQLSTATE: none assigned
+
+LOCAL must be used together with the schema of `file`, but got: 
`<actualSchema>`.
+
 ### LOCATION_ALREADY_EXISTS
 
 [SQLSTATE: 
42710](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -691,14 +1070,22 @@ SQLSTATE: none assigned
 
 Malformed Protobuf messages are detected in message deserialization. Parse 
Mode: `<failFastMode>`. To process malformed protobuf message as null result, 
try setting the option 'mode' as 'PERMISSIVE'.
 
-### MALFORMED_RECORD_IN_PARSING
+### 
[MALFORMED_RECORD_IN_PARSING](sql-error-conditions-malformed-record-in-parsing.html)
 
-SQLSTATE: none assigned
+[SQLSTATE: 22023](sql-error-conditions-sqlstates.html#class-22-data-exception)
 
 Malformed records are detected in record parsing: `<badRecord>`.
-
 Parse Mode: `<failFastMode>`. To process malformed records as null result, try 
setting the option 'mode' as 'PERMISSIVE'.
 
+ For more details see 
[MALFORMED_RECORD_IN_PARSING](sql-error-conditions-malformed-record-in-parsing.html)
+
+### MERGE_CARDINALITY_VIOLATION
+
+[SQLSTATE: 
23K01](sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation)
+
+The ON search condition of the MERGE statement matched a single row from the 
target table with multiple rows of the source table.
+This could result in the target row being operated on more than once with an 
update or delete operation and is not allowed.
+
 ### MISSING_AGGREGATION
 
 [SQLSTATE: 
42803](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -707,18 +1094,38 @@ The non-aggregating expression `<expression>` is based 
on columns which are not
 
 Add the columns or the expression to the GROUP BY, aggregate the expression, 
or use `<expressionAnyValue>` if you do not care which of the values within a 
group is returned.
 
+### [MISSING_ATTRIBUTES](sql-error-conditions-missing-attributes.html)
+
+SQLSTATE: none assigned
+
+Resolved attribute(s) `<missingAttributes>` missing from `<input>` in operator 
`<operator>`.
+
+ For more details see 
[MISSING_ATTRIBUTES](sql-error-conditions-missing-attributes.html)
+
 ### MISSING_GROUP_BY
 
 [SQLSTATE: 
42803](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
 
 The query does not include a GROUP BY clause. Add GROUP BY or turn it into the 
window functions using OVER clauses.
 
+### MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION
+
+SQLSTATE: none assigned
+
+The expression `<expr>` does not support more than one source.
+
 ### MULTI_UDF_INTERFACE_ERROR
 
 SQLSTATE: none assigned
 
 Not allowed to implement multiple UDF interfaces, UDF class `<className>`.
 
+### NAMED_ARGUMENTS_SUPPORT_DISABLED
+
+SQLSTATE: none assigned
+
+Cannot call function `<functionName>` because named argument references are 
not enabled here. In this case, the named argument reference was `<argument>`. 
Set "spark.sql.allowNamedFunctionArguments" to "true" to turn on feature.
+
 ### NESTED_AGGREGATE_FUNCTION
 
 [SQLSTATE: 
42607](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -755,6 +1162,28 @@ Literal expressions required for pivot values, found 
`<expression>`.
 
 PARTITION clause cannot contain the non-partition column: `<columnName>`.
 
+### NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING
+
+SQLSTATE: none assigned
+
+Window function is not supported in `<windowFunc>` (as column `<columnName>`) 
on streaming DataFrames/Datasets. Structured Streaming only supports 
time-window aggregation using the WINDOW function. (window specification: 
`<windowSpec>`)
+
+### [NOT_ALLOWED_IN_FROM](sql-error-conditions-not-allowed-in-from.html)
+
+SQLSTATE: none assigned
+
+Not allowed in the FROM clause:
+
+ For more details see 
[NOT_ALLOWED_IN_FROM](sql-error-conditions-not-allowed-in-from.html)
+
+### 
[NOT_A_CONSTANT_STRING](sql-error-conditions-not-a-constant-string-error-class.html)
+
+[SQLSTATE: 
42601](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+The expression `<expr>` used for the routine or clause `<name>` must be a 
constant STRING which is NOT NULL.
+
+For more details see 
[NOT_A_CONSTANT_STRING](sql-error-conditions-not-a-constant-string-error-class.html)
+
 ### NOT_A_PARTITIONED_TABLE
 
 SQLSTATE: none assigned
@@ -769,6 +1198,38 @@ Assigning a NULL is not allowed here.
 
  For more details see 
[NOT_NULL_CONSTRAINT_VIOLATION](sql-error-conditions-not-null-constraint-violation-error-class.html)
 
+### NOT_SUPPORTED_CHANGE_COLUMN
+
+SQLSTATE: none assigned
+
+ALTER TABLE ALTER/CHANGE COLUMN is not supported for changing `<table>`'s 
column `<originName>` with type `<originType>` to `<newName>` with type 
`<newType>`.
+
+### NOT_SUPPORTED_COMMAND_FOR_V2_TABLE
+
+[SQLSTATE: 46110](sql-error-conditions-sqlstates.html#class-46-java-ddl-1)
+
+`<cmd>` is not supported for v2 tables.
+
+### NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT
+
+SQLSTATE: none assigned
+
+`<cmd>` is not supported, if you want to enable it, please set 
"spark.sql.catalogImplementation" to "hive".
+
+### 
[NOT_SUPPORTED_IN_JDBC_CATALOG](sql-error-conditions-not-supported-in-jdbc-catalog.html)
+
+SQLSTATE: none assigned
+
+Not supported command in JDBC catalog:
+
+ For more details see 
[NOT_SUPPORTED_IN_JDBC_CATALOG](sql-error-conditions-not-supported-in-jdbc-catalog.html)
+
+### NO_DEFAULT_COLUMN_VALUE_AVAILABLE
+
+[SQLSTATE: 
42608](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
+
+Can't determine the default value for `<colName>` since it is not nullable and 
it has no default value.
+
 ### NO_HANDLER_FOR_UDAF
 
 SQLSTATE: none assigned
@@ -823,6 +1284,12 @@ The value `<value>` cannot be interpreted as a numeric 
since it has more than 38
 
 `<operator>` can only be performed on inputs with the same number of columns, 
but the first input has `<firstNumColumns>` columns and the 
`<invalidOrdinalNum>` input has `<invalidNumColumns>` columns.
 
+### NUM_TABLE_VALUE_ALIASES_MISMATCH
+
+SQLSTATE: none assigned
+
+Number of given aliases does not match number of output columns. Function 
name: `<funcName>`; number of aliases: `<aliasesNum>`; number of output 
columns: `<outColsNum>`.
+
 ### ORDER_BY_POS_OUT_OF_RANGE
 
 [SQLSTATE: 
42805](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -937,6 +1404,18 @@ SQLSTATE: none assigned
 
 Found recursive reference in Protobuf schema, which can not be processed by 
Spark by default: `<fieldDescriptor>`. try setting the option 
`recursive.fields.max.depth` 0 to 10. Going beyond 10 levels of recursion is 
not allowed.
 
+### RECURSIVE_VIEW
+
+SQLSTATE: none assigned
+
+Recursive view `<viewIdent>` detected (cycle: `<newPath>`).
+
+### REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION
+
+SQLSTATE: none assigned
+
+References to DEFAULT column values are not allowed within the PARTITION 
clause.
+
 ### RENAME_SRC_PATH_NOT_FOUND
 
 [SQLSTATE: 
42K03](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -973,6 +1452,12 @@ If you did not qualify the name with a schema and 
catalog, verify the current_sc
 
 To tolerate the error on drop use DROP FUNCTION IF EXISTS.
 
+### SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION
+
+SQLSTATE: none assigned
+
+The correlated scalar subquery '`<sqlExpr>`' is neither present in GROUP BY, 
nor in an aggregate function. Add it to GROUP BY using ordinal position or wrap 
it in `first()` (or `first_value`) if you don't care which value you get.
+
 ### SCALAR_SUBQUERY_TOO_MANY_ROWS
 
 [SQLSTATE: 
21000](sql-error-conditions-sqlstates.html#class-21-cardinality-violation)
@@ -1011,12 +1496,36 @@ To tolerate the error on drop use DROP SCHEMA IF EXISTS.
 
 The second argument of `<functionName>` function needs to be an integer.
 
+### SEED_EXPRESSION_IS_UNFOLDABLE
+
+SQLSTATE: none assigned
+
+The seed expression `<seedExpr>` of the expression `<exprWithSeed>` must be 
foldable.
+
 ### SORT_BY_WITHOUT_BUCKETING
 
 SQLSTATE: none assigned
 
 sortBy must be used together with bucketBy.
 
+### SPECIFY_BUCKETING_IS_NOT_ALLOWED
+
+SQLSTATE: none assigned
+
+Cannot specify bucketing information if the table schema is not specified when 
creating and will be inferred at runtime.
+
+### SPECIFY_PARTITION_IS_NOT_ALLOWED
+
+SQLSTATE: none assigned
+
+It is not allowed to specify partition columns when the table schema is not 
defined. When the table schema is not provided, schema and partition columns 
will be inferred.
+
+### SQL_CONF_NOT_FOUND
+
+SQLSTATE: none assigned
+
+The SQL config `<sqlConf>` cannot be found. Please verify that the config 
exists.
+
 ### STAR_GROUP_BY_POS
 
 [SQLSTATE: 
0A000](sql-error-conditions-sqlstates.html#class-0A-feature-not-supported)
@@ -1035,6 +1544,12 @@ SQLSTATE: none assigned
 
 Query [id = `<id>`, runId = `<runId>`] terminated with exception: `<message>`
 
+### SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT
+
+SQLSTATE: none assigned
+
+The sum of the LIMIT clause and the OFFSET clause must not be greater than the 
maximum 32-bit integer value (2,147,483,647) but found limit = `<limit>`, 
offset = `<offset>`.
+
 ### TABLE_OR_VIEW_ALREADY_EXISTS
 
 [SQLSTATE: 
42P07](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -1079,6 +1594,12 @@ CREATE TEMPORARY VIEW or the corresponding Dataset APIs 
only accept single-part
 
 Cannot initialize array with `<numElements>` elements of size `<size>`.
 
+### UDTF_ALIAS_NUMBER_MISMATCH
+
+SQLSTATE: none assigned
+
+The number of aliases supplied in the AS clause does not match the number of 
columns output by the UDTF. Expected `<aliasesSize>` aliases, but got 
`<aliasesNames>`. Please ensure that the number of aliases provided matches the 
number of columns output by the UDTF.
+
 ### UNABLE_TO_ACQUIRE_MEMORY
 
 [SQLSTATE: 
53200](sql-error-conditions-sqlstates.html#class-53-insufficient-resources)
@@ -1151,6 +1672,12 @@ All unpivot value columns must have the same size as 
there are value column name
 
 Unrecognized SQL type - name: `<typeName>`, id: `<jdbcType>`.
 
+### UNRESOLVABLE_TABLE_VALUED_FUNCTION
+
+SQLSTATE: none assigned
+
+Could not resolve `<name>` to a table-valued function. Please make sure that 
<name> is defined as a table-valued function and that all required parameters 
are provided correctly. If `<name>` is not defined, please create the 
table-valued function before using it. For more information about defining 
table-valued functions, please refer to the Apache Spark documentation.
+
 ### UNRESOLVED_ALL_IN_GROUP_BY
 
 [SQLSTATE: 
42803](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
@@ -1193,12 +1720,32 @@ Cannot resolve function `<routineName>` on search path 
`<searchPath>`.
 
 USING column `<colName>` cannot be resolved on the `<side>` side of the join. 
The `<side>`-side columns: [`<suggestion>`].
 
+### UNSET_NONEXISTENT_PROPERTIES
+
+SQLSTATE: none assigned
+
+Attempted to unset non-existent properties [`<properties>`] in table `<table>`.
+
+### [UNSUPPORTED_ADD_FILE](sql-error-conditions-unsupported-add-file.html)
+
+SQLSTATE: none assigned
+
+Don't support add file.
+
+ For more details see 
[UNSUPPORTED_ADD_FILE](sql-error-conditions-unsupported-add-file.html)
+
 ### UNSUPPORTED_ARROWTYPE
 
 [SQLSTATE: 
0A000](sql-error-conditions-sqlstates.html#class-0A-feature-not-supported)
 
 Unsupported arrow type `<typeName>`.
 
+### UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING
+
+SQLSTATE: none assigned
+
+The char/varchar type can't be used in the table schema. If you want Spark 
treat them as string type as same as Spark 3.0 and earlier, please set 
"spark.sql.legacy.charVarcharAsString" to "true".
+
 ### UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY
 
 SQLSTATE: none assigned
@@ -1211,6 +1758,20 @@ Unsupported data source type for direct query on files: 
`<dataSourceType>`
 
 Unsupported data type `<typeName>`.
 
+### UNSUPPORTED_DATA_SOURCE_FOR_DIRECT_QUERY
+
+SQLSTATE: none assigned
+
+The direct query on files does not support the data source type: 
`<className>`. Please try a different data source type or consider using a 
different query method.
+
+### 
[UNSUPPORTED_DEFAULT_VALUE](sql-error-conditions-unsupported-default-value.html)
+
+SQLSTATE: none assigned
+
+DEFAULT column values is not supported.
+
+ For more details see 
[UNSUPPORTED_DEFAULT_VALUE](sql-error-conditions-unsupported-default-value.html)
+
 ### 
[UNSUPPORTED_DESERIALIZER](sql-error-conditions-unsupported-deserializer-error-class.html)
 
 [SQLSTATE: 
0A000](sql-error-conditions-sqlstates.html#class-0A-feature-not-supported)
@@ -1261,6 +1822,30 @@ SQLSTATE: none assigned
 
 grouping()/grouping_id() can only be used with GroupingSets/Cube/Rollup.
 
+### [UNSUPPORTED_INSERT](sql-error-conditions-unsupported-insert.html)
+
+SQLSTATE: none assigned
+
+Can't insert into the target.
+
+ For more details see 
[UNSUPPORTED_INSERT](sql-error-conditions-unsupported-insert.html)
+
+### 
[UNSUPPORTED_MERGE_CONDITION](sql-error-conditions-unsupported-merge-condition.html)
+
+SQLSTATE: none assigned
+
+MERGE operation contains unsupported `<condName>` condition.
+
+ For more details see 
[UNSUPPORTED_MERGE_CONDITION](sql-error-conditions-unsupported-merge-condition.html)
+
+### [UNSUPPORTED_OVERWRITE](sql-error-conditions-unsupported-overwrite.html)
+
+SQLSTATE: none assigned
+
+Can't overwrite the target that is also being read from.
+
+ For more details see 
[UNSUPPORTED_OVERWRITE](sql-error-conditions-unsupported-overwrite.html)
+
 ### 
[UNSUPPORTED_SAVE_MODE](sql-error-conditions-unsupported-save-mode-error-class.html)
 
 SQLSTATE: none assigned
@@ -1313,6 +1898,18 @@ If you did not qualify the name with a schema, verify 
the current_schema() outpu
 
 To tolerate the error on drop use DROP VIEW IF EXISTS.
 
+### WINDOW_FUNCTION_AND_FRAME_MISMATCH
+
+SQLSTATE: none assigned
+
+`<funcName>` function can only be evaluated in an ordered row-based window 
frame with a single offset: `<windowExpr>`.
+
+### WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE
+
+SQLSTATE: none assigned
+
+Window function `<funcName>` requires an OVER clause.
+
 ### WRITE_STREAM_NOT_ALLOWED
 
 SQLSTATE: none assigned


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org

Reply via email to