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 518880783c7 [MINOR][SQL][DOCS] Fix errors w/ error classes in examples 518880783c7 is described below commit 518880783c79ed6fe0c67d0ae9b92f71c128add6 Author: Max Gekk <max.g...@gmail.com> AuthorDate: Sun Aug 14 11:30:10 2022 +0300 [MINOR][SQL][DOCS] Fix errors w/ error classes in examples ### What changes were proposed in this pull request? In the PR, I propose to update outputs of some examples of errors w/ error classes. ### Why are the changes needed? To align Spark SQL docs w/ actual current state of Spark SQL. ### Does this PR introduce _any_ user-facing change? No. ### How was this patch tested? By rebuilding docs and checking examples manually: ``` $ SKIP_SCALADOC=1 SKIP_PYTHONDOC=1 SKIP_RDOC=1 bundle exec jekyll build ``` Closes #37509 from MaxGekk/fix-doc-wo-error-classes. Authored-by: Max Gekk <max.g...@gmail.com> Signed-off-by: Max Gekk <max.g...@gmail.com> --- docs/sql-ref-ansi-compliance.md | 11 +++++++---- docs/sql-ref-identifier.md | 16 ++++++++++++---- 2 files changed, 19 insertions(+), 8 deletions(-) diff --git a/docs/sql-ref-ansi-compliance.md b/docs/sql-ref-ansi-compliance.md index 85d3920e707..7a8f7dc2ecf 100644 --- a/docs/sql-ref-ansi-compliance.md +++ b/docs/sql-ref-ansi-compliance.md @@ -45,10 +45,13 @@ When `spark.sql.ansi.enabled` is set to `true` and an overflow occurs in numeric ```sql -- `spark.sql.ansi.enabled=true` SELECT 2147483647 + 1; -java.lang.ArithmeticException: integer overflow +org.apache.spark.SparkArithmeticException: [ARITHMETIC_OVERFLOW] integer overflow. Use 'try_add' to tolerate overflow and return NULL instead. If necessary set spark.sql.ansi.enabled to "false" to bypass this error. +== SQL(line 1, position 8) == +SELECT 2147483647 + 1 + ^^^^^^^^^^^^^^ SELECT abs(-2147483648); -java.lang.ArithmeticException: integer overflow +org.apache.spark.SparkArithmeticException: [ARITHMETIC_OVERFLOW] integer overflow. If necessary set spark.sql.ansi.enabled to "false" to bypass this error. -- `spark.sql.ansi.enabled=false` SELECT 2147483647 + 1; @@ -117,7 +120,7 @@ SELECT CAST('a' AS INT) SELECT CAST(2147483648L AS INT); org.apache.spark.SparkArithmeticException: [CAST_OVERFLOW] The value 2147483648L of the type "BIGINT" cannot be cast to "INT" due to an overflow. Use `try_cast` to tolerate overflow and return NULL instead. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error. -SELECT CAST(DATE'2020-01-01' AS INT) +SELECT CAST(DATE'2020-01-01' AS INT); org.apache.spark.sql.AnalysisException: cannot resolve 'CAST(DATE '2020-01-01' AS INT)' due to data type mismatch: cannot cast date to int. To convert values from date to int, you can use function UNIX_DATE instead. @@ -189,7 +192,7 @@ During table insertion, Spark will throw exception on numeric value overflow. CREATE TABLE test(i INT); INSERT INTO test VALUES (2147483648L); -java.lang.ArithmeticException: Casting 2147483648 to int causes overflow +org.apache.spark.SparkArithmeticException: [CAST_OVERFLOW_IN_TABLE_INSERT] Fail to insert a value of "BIGINT" type into the "INT" type column `i` due to an overflow. Use `try_cast` on the input value to tolerate overflow and return NULL instead. ``` ### Type coercion diff --git a/docs/sql-ref-identifier.md b/docs/sql-ref-identifier.md index bba8c67780a..e4d9727c09b 100644 --- a/docs/sql-ref-identifier.md +++ b/docs/sql-ref-identifier.md @@ -57,16 +57,24 @@ An identifier is a string used to identify a database object such as a table, vi ```sql -- This CREATE TABLE fails with ParseException because of the illegal identifier name a.b CREATE TABLE test (a.b int); -org.apache.spark.sql.catalyst.parser.ParseException: -Syntax error at or near '.': extra input '.'(line 1, pos 20) +Error in query: +[PARSE_SYNTAX_ERROR] Syntax error at or near '.': extra input '.'(line 1, pos 20) + +== SQL == +CREATE TABLE test (a.b int) +--------------------^^^ -- This CREATE TABLE works CREATE TABLE test (`a.b` int); -- This CREATE TABLE fails with ParseException because special character ` is not escaped CREATE TABLE test1 (`a`b` int); -org.apache.spark.sql.catalyst.parser.ParseException: -Syntax error at or near '`'(line 1, pos 23) +Error in query: +[PARSE_SYNTAX_ERROR] Syntax error at or near '`'(line 1, pos 24) + +== SQL == +CREATE TABLE test1 (`a`b` int) +------------------------^^^ -- This CREATE TABLE works CREATE TABLE test (`a``b` int); --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org