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 26d3eca0a8d3 [SPARK-46009][SQL][DOCS][FOLLOWUP] Change the error code
for invalid inverse distribution function
26d3eca0a8d3 is described below
commit 26d3eca0a8d3303d0bb9450feb6575ed145bbd7e
Author: beliefer <[email protected]>
AuthorDate: Sun Jan 21 23:32:28 2024 +0300
[SPARK-46009][SQL][DOCS][FOLLOWUP] Change the error code for invalid
inverse distribution function
### What changes were proposed in this pull request?
This PR follows up https://github.com/apache/spark/pull/43910 and propose
to change the error code for invalid inverse distribution function.
### Why are the changes needed?
Based on the discussion at
https://github.com/apache/spark/pull/43910#discussion_r1460131124
### Does this PR introduce _any_ user-facing change?
'No'.
### How was this patch tested?
GA tests.
### Was this patch authored or co-authored using generative AI tooling?
'No'.
Closes #44811 from beliefer/SPARK-46009_followup.
Authored-by: beliefer <[email protected]>
Signed-off-by: Max Gekk <[email protected]>
---
common/utils/src/main/resources/error/README.md | 2 +-
common/utils/src/main/resources/error/error-classes.json | 2 +-
...itions-invalid-inverse-distribution-function-error-class.md | 2 +-
docs/sql-error-conditions.md | 2 +-
.../src/test/resources/sql-tests/analyzer-results/mode.sql.out | 8 ++++----
.../resources/sql-tests/analyzer-results/percentiles.sql.out | 10 +++++-----
sql/core/src/test/resources/sql-tests/results/mode.sql.out | 8 ++++----
.../src/test/resources/sql-tests/results/percentiles.sql.out | 10 +++++-----
8 files changed, 22 insertions(+), 22 deletions(-)
diff --git a/common/utils/src/main/resources/error/README.md
b/common/utils/src/main/resources/error/README.md
index b062c7739072..17e5a88cd884 100644
--- a/common/utils/src/main/resources/error/README.md
+++ b/common/utils/src/main/resources/error/README.md
@@ -881,6 +881,7 @@ The following SQLSTATEs are collated from:
|42K0H |42 |Syntax error or Access Rule violation |K0H |A
cyclic invocation has been detected. |Spark |N
|Spark
|
|42K0I |42 |Syntax error or Access Rule violation |K0I
|SQL Config not found. |Spark |N
|Spark
|
|42K0J |42 |Syntax error or Access Rule violation |K0J
|Property not found. |Spark |N
|Spark
|
+|42K0K |IM |Syntax error or Access Rule violation |K0K
|Invalid inverse distribution function |Spark |N
|Spark
|
|42KD0 |42 |Syntax error or Access Rule violation |KD0
|Ambiguous name reference. |Databricks |N
|Databricks
|
|42KD1 |42 |Syntax error or Access Rule violation |KD1
|Operation not supported in READ ONLY session mode. |Databricks |N
|Databricks
|
|42KD2 |42 |Syntax error or Access Rule violation |KD2
|The source and target table names of a SYNC operaton must be the
same.|Databricks |N |Databricks
|
@@ -1310,7 +1311,6 @@ The following SQLSTATEs are collated from:
|HZ320 |HZ |RDA-specific condition |320
|version not supported |RDA/SQL |Y
|RDA/SQL
|
|HZ321 |HZ |RDA-specific condition |321
|TCP/IP error |RDA/SQL |Y
|RDA/SQL
|
|HZ322 |HZ |RDA-specific condition |322
|TLS alert |RDA/SQL |Y
|RDA/SQL
|
-|ID001 |IM |Invalid inverse distribution function |001
|Invalid inverse distribution function |SQL/Foundation |N
|SQL/Foundation PostgreSQL Oracle Snowflake Redshift H2
|
|IM001 |IM |ODBC driver |001
|Driver does not support this function |SQL Server |N
|SQL Server
|
|IM002 |IM |ODBC driver |002
|Data source name not found and no default driver specified |SQL Server |N
|SQL Server
|
|IM003 |IM |ODBC driver |003
|Specified driver could not be loaded |SQL Server |N
|SQL Server
|
diff --git a/common/utils/src/main/resources/error/error-classes.json
b/common/utils/src/main/resources/error/error-classes.json
index 072081f48448..8f4e04ba5456 100644
--- a/common/utils/src/main/resources/error/error-classes.json
+++ b/common/utils/src/main/resources/error/error-classes.json
@@ -2009,7 +2009,7 @@
]
}
},
- "sqlState" : "ID001"
+ "sqlState" : "42K0K"
},
"INVALID_JSON_ROOT_FIELD" : {
"message" : [
diff --git
a/docs/sql-error-conditions-invalid-inverse-distribution-function-error-class.md
b/docs/sql-error-conditions-invalid-inverse-distribution-function-error-class.md
index d2091c72f43c..4a2cf3faaaf1 100644
---
a/docs/sql-error-conditions-invalid-inverse-distribution-function-error-class.md
+++
b/docs/sql-error-conditions-invalid-inverse-distribution-function-error-class.md
@@ -19,7 +19,7 @@ license: |
limitations under the License.
---
-SQLSTATE: ID001
+[SQLSTATE:
42K0K](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
Invalid inverse distribution function `<funcName>`.
diff --git a/docs/sql-error-conditions.md b/docs/sql-error-conditions.md
index 133cfbacb5fa..fa3bd5826214 100644
--- a/docs/sql-error-conditions.md
+++ b/docs/sql-error-conditions.md
@@ -1177,7 +1177,7 @@ For more details see
[INVALID_INLINE_TABLE](sql-error-conditions-invalid-inline-
###
[INVALID_INVERSE_DISTRIBUTION_FUNCTION](sql-error-conditions-invalid-inverse-distribution-function-error-class.html)
-SQLSTATE: ID001
+[SQLSTATE:
42K0K](sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation)
Invalid inverse distribution function `<funcName>`.
diff --git
a/sql/core/src/test/resources/sql-tests/analyzer-results/mode.sql.out
b/sql/core/src/test/resources/sql-tests/analyzer-results/mode.sql.out
index 6fa1dcb4b75d..a0a0c81ef027 100644
--- a/sql/core/src/test/resources/sql-tests/analyzer-results/mode.sql.out
+++ b/sql/core/src/test/resources/sql-tests/analyzer-results/mode.sql.out
@@ -75,7 +75,7 @@ SELECT department, mode(DISTINCT salary) FROM basic_pays
GROUP BY department ORD
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -380,7 +380,7 @@ FROM basic_pays
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -402,7 +402,7 @@ FROM basic_pays
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -424,7 +424,7 @@ FROM basic_pays
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WRONG_NUM_ORDERINGS",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"actualNum" : "1",
"expectedNum" : "0",
diff --git
a/sql/core/src/test/resources/sql-tests/analyzer-results/percentiles.sql.out
b/sql/core/src/test/resources/sql-tests/analyzer-results/percentiles.sql.out
index b5da559901c2..e763ed48b136 100644
--- a/sql/core/src/test/resources/sql-tests/analyzer-results/percentiles.sql.out
+++ b/sql/core/src/test/resources/sql-tests/analyzer-results/percentiles.sql.out
@@ -249,7 +249,7 @@ FROM aggr
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -271,7 +271,7 @@ FROM aggr
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -343,7 +343,7 @@ FROM aggr
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -365,7 +365,7 @@ FROM aggr
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -387,7 +387,7 @@ FROM aggr
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WRONG_NUM_ORDERINGS",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"actualNum" : "2",
"expectedNum" : "1",
diff --git a/sql/core/src/test/resources/sql-tests/results/mode.sql.out
b/sql/core/src/test/resources/sql-tests/results/mode.sql.out
index 763e8d8c1909..6ae7b2d29e9d 100644
--- a/sql/core/src/test/resources/sql-tests/results/mode.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/mode.sql.out
@@ -52,7 +52,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -380,7 +380,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -404,7 +404,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`mode`"
},
@@ -428,7 +428,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WRONG_NUM_ORDERINGS",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"actualNum" : "1",
"expectedNum" : "0",
diff --git a/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out
b/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out
index fc951308563f..cd95eee186e1 100644
--- a/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out
@@ -223,7 +223,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -247,7 +247,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.DISTINCT_UNSUPPORTED",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -325,7 +325,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -349,7 +349,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WITHIN_GROUP_MISSING",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"funcName" : "`percentile_cont`"
},
@@ -373,7 +373,7 @@ struct<>
org.apache.spark.sql.AnalysisException
{
"errorClass" : "INVALID_INVERSE_DISTRIBUTION_FUNCTION.WRONG_NUM_ORDERINGS",
- "sqlState" : "ID001",
+ "sqlState" : "42K0K",
"messageParameters" : {
"actualNum" : "2",
"expectedNum" : "1",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
