[ https://issues.apache.org/jira/browse/SPARK-26270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marco Gaido resolved SPARK-26270. --------------------------------- Resolution: Invalid > Having clause does not work with explode anymore > ------------------------------------------------ > > Key: SPARK-26270 > URL: https://issues.apache.org/jira/browse/SPARK-26270 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.0 > Reporter: Olli Kuonanoja > Priority: Major > > Hi, > In Spark 2.3.0 it was possible to execute queries like > {code:sql} > select explode(col1) as v from values array(1,2) having v>1 > {code} > but in 2.4.0 it leads to > {noformat} > org.apache.spark.sql.AnalysisException: Generators are not supported outside > the SELECT clause, but got: 'Aggregate [explode(col1#1) AS v#0]; > {noformat} > Before looking into a fix I'm trying to understand if this has been changed > on purpose and if there is an alternate construct available. Could not find > any pre-existing tests for the explode-having combination. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org