lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Risden <compuwizard...@gmail.com>
Subject Re: Possible regression in Parallel SQL in 6.5.1?
Date Wed, 17 May 2017 00:27:07 GMT
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 <compuwizard123@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" <joelsolr@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 <thelabdude@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
>> >
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message