[GitHub] [spark] panbingkun commented on pull request #36209: [SPARK-38750][SQL][TESTS] Test the error class: SECOND_FUNCTION_ARGUMENT_NOT_INTEGER

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

panbingkun commented on PR #36209:
URL: https://github.com/apache/spark/pull/36209#issuecomment-1100775306

   > For some reasons, this causes the failure in the master though I ran it successfully:
   > 
   > ```
   > [info] - SECOND_FUNCTION_ARGUMENT_NOT_INTEGER: the second argument of 'date_add' function needs to be an integer *** FAILED *** (22 milliseconds)
   > [info]   Expected exception org.apache.spark.sql.AnalysisException to be thrown, but java.lang.NumberFormatException was thrown (QueryCompilationErrorsSuite.scala:316)
   > [info]   org.scalatest.exceptions.TestFailedException:
   > [info]   at org.scalatest.Assertions.newAssertionFailedException(Assertions.scala:472)
   > ```
   
   I also ran it successfully, message as follow:
   [info] - CANNOT_UP_CAST_DATATYPE: invalid upcast data type (4 seconds, 827 milliseconds)
   [info] - UNSUPPORTED_GROUPING_EXPRESSION: filter with grouping/grouping_Id expression (990 milliseconds)
   [info] - UNSUPPORTED_GROUPING_EXPRESSION: Sort with grouping/grouping_Id expression (288 milliseconds)
   [info] - ILLEGAL_SUBSTRING: the argument_index of string format is invalid (50 milliseconds)
   [info] - INVALID_PANDAS_UDF_PLACEMENT: Using aggregate function with grouped aggregate pandas UDF (2 seconds, 662 milliseconds)
   [info] - UNSUPPORTED_FEATURE: Using Python UDF with unsupported join condition (883 milliseconds)
   [info] - UNSUPPORTED_FEATURE: Using pandas UDF aggregate expression with pivot (4 seconds, 460 milliseconds)
   [info] - NO_HANDLER_FOR_UDAF: No handler for UDAF error (115 milliseconds)
   [info] - UNTYPED_SCALA_UDF: use untyped Scala UDF should fail by default (2 milliseconds)
   [info] - NO_UDF_INTERFACE_ERROR: java udf class does not implement any udf interface (5 milliseconds)
   [info] - MULTI_UDF_INTERFACE_ERROR: java udf implement multi UDF interface (8 milliseconds)
   [info] - UNSUPPORTED_FEATURE: java udf with too many type arguments (8 milliseconds)
   [info] - GROUPING_COLUMN_MISMATCH: not found the grouping column (426 milliseconds)
   [info] - GROUPING_ID_COLUMN_MISMATCH: columns of grouping_id does not match (16 milliseconds)
   07:58:27.375 WARN org.apache.spark.sql.catalyst.util.package: Truncated the string representation of a plan since it was too large. This behavior can be adjusted by setting 'spark.sql.debug.maxToStringFields'.
   [info] - GROUPING_SIZE_LIMIT_EXCEEDED: max size of grouping set (941 milliseconds)
   ***[info] - SECOND_FUNCTION_ARGUMENT_NOT_INTEGER: the second argument of 'date_add' function needs to be an integer (55 milliseconds)***
   07:58:28.787 WARN org.apache.spark.sql.errors.QueryCompilationErrorsSuite:
   
   ===== POSSIBLE THREAD LEAK IN SUITE o.a.s.sql.errors.QueryCompilationErrorsSuite, threads: QueryStageCreator-0 (daemon=true), QueryStageCreator-1 (daemon=true), rpc-boss-3-1 (daemon=true), shuffle-boss-6-1 (daemon=true) =====
   [info] Run completed in 21 seconds, 644 milliseconds.
   [info] Total number of tests run: 16
   [info] Suites: completed 1, aborted 0
   [info] Tests: succeeded 16, failed 0, canceled 0, ignored 0, pending 0
   ***[info] All tests passed.***
   [success] Total time: 361 s (06:01), completed Apr 17, 2022 7:58:30 AM
   
   ***It's very strange！***


-- 
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