Well didn't take as long as I thought: https://issues.apache.org/jira/browse/CALCITE-1306
Once Calcite 1.13 is released we should upgrade and get support for this again. Kevin Risden On Tue, May 16, 2017 at 7:23 PM, Kevin Risden <compuwizard...@gmail.com> wrote: > Yea this came up on the calcite mailing list. Not sure if aliases in the > having clause were going to be added. I'll have to see if I can find that > discussion or JIRA. > > Kevin Risden > > On May 16, 2017 18:54, "Joel Bernstein" <joels...@gmail.com> wrote: > >> Yeah, Calcite doesn't support field aliases in the having clause. The >> query >> should work if you use count(*). We could consider this a regression, but >> I >> think this will be a won't fix. >> >> Joel Bernstein >> http://joelsolr.blogspot.com/ >> >> On Tue, May 16, 2017 at 12:51 PM, Timothy Potter <thelabd...@gmail.com> >> wrote: >> >> > This SQL used to work pre-calcite: >> > >> > SELECT movie_id, COUNT(*) as num_ratings, avg(rating) as aggAvg FROM >> > ratings GROUP BY movie_id HAVING num_ratings > 100 ORDER BY aggAvg ASC >> > LIMIT 10 >> > >> > Now I get: >> > Caused by: java.io.IOException: --> >> > http://192.168.1.4:8983/solr/ratings_shard2_replica1/:Failed to >> > execute sqlQuery 'SELECT movie_id, COUNT(*) as num_ratings, >> > avg(rating) as aggAvg FROM ratings GROUP BY movie_id HAVING >> > num_ratings > 100 ORDER BY aggAvg ASC LIMIT 10' against JDBC >> > connection 'jdbc:calcitesolr:'. >> > Error while executing SQL "SELECT movie_id, COUNT(*) as num_ratings, >> > avg(rating) as aggAvg FROM ratings GROUP BY movie_id HAVING >> > num_ratings > 100 ORDER BY aggAvg ASC LIMIT 10": From line 1, column >> > 103 to line 1, column 113: Column 'num_ratings' not found in any table >> > at org.apache.solr.client.solrj.io.stream.SolrStream.read( >> > SolrStream.java:235) >> > at com.lucidworks.spark.query.TupleStreamIterator.fetchNextTupl >> e( >> > TupleStreamIterator.java:82) >> > at com.lucidworks.spark.query.TupleStreamIterator.hasNext( >> > TupleStreamIterator.java:47) >> > ... 31 more >> > >> >
