panbingkun commented on code in PR #47460: URL: https://github.com/apache/spark/pull/47460#discussion_r1687725920
########## docs/sql-ref-syntax-ddl-drop-variable.md: ########## @@ -54,10 +54,11 @@ DROP TEMPORARY VARIABLE var1; -- Try to drop temporary variable which is not present DROP TEMPORARY VARIABLE var1; -Error: VARIABLE_NOT_FOUND -The variable `system`.`session`.`var1` cannot be found. +[VARIABLE_NOT_FOUND] The variable `system`.`session`.`var1` cannot be found. Verify the spelling and correctness of the schema and catalog. +If you did not qualify the name with a schema and catalog, verify the current_schema() output, or qualify the name with the correct schema and catalog. +To tolerate the error on drop use DROP VARIABLE IF EXISTS. SQLSTATE: 42883 --- Drop temporart variable if it exists Review Comment: typo `temporart` -> `temporary` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
