[GitHub] [spark] srielau commented on a diff in pull request #38656: [SPARK-41140][SQL] Rename the error class `_LEGACY_ERROR_TEMP_2440` to `INVALID_WHERE_CONDITION`

[GitBox <gi...@apache.org>]

srielau commented on code in PR #38656:
URL: https://github.com/apache/spark/pull/38656#discussion_r1022346987


##########
core/src/main/resources/error/error-classes.json:
##########
@@ -699,6 +699,13 @@
       }
     }
   },
+  "INVALID_WHERE_CONDITION" : {
+    "message" : [
+      "Found the invalid expressions: <invalidExprs>",
+      "in the where condition: [<condition>]",
+      "Please, rewrite your query and avoid using of the expressions because any window, aggregate or generator expressions are not allowed in where/filter clauses."

Review Comment:
   ```suggestion
         "The WHERE condition <condition> contains invalid expressions: <expressionList>."
         "Rewrite the query to avoid window functions, aggregate functions, and generator functions in the WHERE clause."
   ```



-- 
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-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org