Re:Re: [SQL]Analysis failed when combining Window function and GROUP BY in Spark2.x

2017-03-08 Thread StanZhai
k.sql.SparkSession.sql(SparkSession.scala:582)But, there is no exception in Spark 1.6.x. I think the sql select count(distinct(b)) over (partition by a) from tb group by a should be executed. I've no idea about the exception. Is this in line with expectations? Any help is appreciated! Best, St

Re: [SQL]Analysis failed when combining Window function and GROUP BY in Spark2.x

2017-03-08 Thread Herman van Hövell tot Westerflier
no exception in Spark 1.6.x. > > I think the sql select count(distinct(b)) over (partition by a) from tb > group by a should be executed. I've no idea about the exception. Is this > in line with expectations? > > Any help is appreciated! > > Best, > > Stan > > >

[SQL]Analysis failed when combining Window function and GROUP BY in Spark2.x

2017-03-07 Thread StanZhai
n. Is this in line with expectations? Any help is appreciated! Best, Stan -- View this message in context: http://apache-spark-developers-list.1001551.n3.nabble.com/SQL-Analysis-failed-when-combining-Window-function-and-GROUP-BY-in-Spark2-x-tp21131.html Sent from the Apache Spark Developers List mailing list archive at Nabble.com.