yaooqinn opened a new pull request #26947: [SPARK-30303][SQL] Fix match error 
in percentile function when the percentage is null
URL: https://github.com/apache/spark/pull/26947
 
 
   
   
   ### What changes were proposed in this pull request?
   
   Similar to #26905
   
   ```sql
   spark-sql> select percentile(1, null);
   19/12/19 16:35:04 ERROR SparkSQLDriver: Failed in [select percentile(1, 
null)]
   scala.MatchError: null
   
   
   spark-sql> select percentile(1, array(0.0, null)); -- null is illegal but 
treat as zero
   ``` 
   
   
   ### Why are the changes needed?
   bugfix
   
   
   ### Does this PR introduce any user-facing change?
   
   yes, select percentile(1, null); throws AnalysisException instead.
   
   ### How was this patch tested?
   <!--
   If tests were added, say they were added here. Please make sure to add some 
test cases that check the changes thoroughly including negative and positive 
cases if possible.
   If it was tested in a way different from regular unit tests, please clarify 
how you tested step by step, ideally copy and paste-able, so that other 
reviewers can test and check, and descendants can verify in the future.
   If tests were not added, please describe why they were not added and/or why 
it was difficult to add.
   -->
   add ut

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to