[ https://issues.apache.org/jira/browse/SPARK-51319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yu Xu updated SPARK-51319: -------------------------- Description: Function array_contains(array(1,null), 2) return null and array_contains(array(1,null), 1) return true; In Hive: array_contains(array(1,null), 2) retrun false and array_contains(array(1,null), 1) return true; after offline discussion,this is a bug. If it is nessary,I am willing to submit a pr to fix it. was: Function array_contains(array(1,null), 2) retrun null and array_contains(array(1,null), 1) return true; In Hive: array_contains(array(1,null), 2) retrun false and array_contains(array(1,null), 1) return true; after offline discussion,this is a bug. If it is nessary,I am willing to submit a pr to fix it. > array_contains functions return null when contains value > -------------------------------------------------------- > > Key: SPARK-51319 > URL: https://issues.apache.org/jira/browse/SPARK-51319 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.5.4 > Reporter: Yu Xu > Priority: Major > > Function array_contains(array(1,null), 2) return null and > array_contains(array(1,null), 1) return true; > In Hive: array_contains(array(1,null), 2) retrun false and > array_contains(array(1,null), 1) return true; > after offline discussion,this is a bug. If it is nessary,I am willing to > submit a pr to fix it. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org