cloud-fan commented on a change in pull request #33516: URL: https://github.com/apache/spark/pull/33516#discussion_r677403082
########## File path: docs/sql-ref-ansi-compliance.md ########## @@ -66,11 +66,9 @@ SELECT abs(-2147483648); +----------------+ ``` -### Type Conversion +### Cast -Spark SQL has three kinds of type conversions: explicit casting, type coercion, and store assignment casting. When `spark.sql.ansi.enabled` is set to `true`, explicit casting by `CAST` syntax throws a runtime exception for illegal cast patterns defined in the standard, e.g. casts from a string to an integer. -On the other hand, `INSERT INTO` syntax throws an analysis exception when the ANSI mode enabled via `spark.sql.storeAssignmentPolicy=ANSI`. The type conversion of Spark ANSI mode follows the syntax rules of section 6.13 "cast specification" in [ISO/IEC 9075-2:2011 Information technology — Database languages - SQL — Part 2: Foundation (SQL/Foundation)](https://www.iso.org/standard/53682.html), except it specially allows the following Review comment: `The type conversion` -> `Explicit cast` ########## File path: docs/sql-ref-ansi-compliance.md ########## @@ -66,11 +66,9 @@ SELECT abs(-2147483648); +----------------+ ``` -### Type Conversion +### Cast -Spark SQL has three kinds of type conversions: explicit casting, type coercion, and store assignment casting. When `spark.sql.ansi.enabled` is set to `true`, explicit casting by `CAST` syntax throws a runtime exception for illegal cast patterns defined in the standard, e.g. casts from a string to an integer. -On the other hand, `INSERT INTO` syntax throws an analysis exception when the ANSI mode enabled via `spark.sql.storeAssignmentPolicy=ANSI`. The type conversion of Spark ANSI mode follows the syntax rules of section 6.13 "cast specification" in [ISO/IEC 9075-2:2011 Information technology — Database languages - SQL — Part 2: Foundation (SQL/Foundation)](https://www.iso.org/standard/53682.html), except it specially allows the following Review comment: `The type conversion` -> `The explicit cast` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org