[
https://issues.apache.org/jira/browse/SOLR-10341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15939281#comment-15939281
]
Timothy Potter commented on SOLR-10341:
---------------------------------------
This is failing for me:
{code}
curl --data-urlencode "stmt=select rating, movie_id, user_id from ratings order
by rating desc LIMIT 100" "http://localhost:8983/solr/ratings/sql";
{"result-set":{"docs":[{"EXCEPTION":"java.lang.Long cannot be cast to
java.lang.String","EOF":true,"RESPONSE_TIME":160}]}}
{code}
rating is a tint as before ...
{code}
2017-03-23 21:47:37.007 INFO (qtp1197365356-15) [c:ratings s:shard1
r:core_node1 x:ratings_shard1_replica1] o.a.s.c.S.Request
[ratings_shard1_replica1] webapp=/solr path=/select
params={q=*:*&distrib=false&fl=rating,movie_id,user_id&sort=rating+desc&rows=100&wt=json&version=2.2}
hits=100000 status=0 QTime=19
2017-03-23 21:47:37.014 ERROR (qtp1197365356-21) [c:ratings s:shard1
r:core_node1 x:ratings_shard1_replica1] o.a.s.c.s.i.s.ExceptionStream
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String
at
org.apache.calcite.avatica.util.AbstractCursor$StringAccessor.getString(AbstractCursor.java:728)
at org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:352)
at
org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:393)
at
org.apache.solr.client.solrj.io.stream.JDBCStream$1.selectValue(JDBCStream.java:240)
at
org.apache.solr.client.solrj.io.stream.JDBCStream.read(JDBCStream.java:341)
at
org.apache.solr.handler.SQLHandler$SqlHandlerStream.read(SQLHandler.java:187)
at
org.apache.solr.client.solrj.io.stream.ExceptionStream.read(ExceptionStream.java:68)
at
org.apache.solr.handler.StreamHandler$TimerStream.read(StreamHandler.java:508)
at
org.apache.solr.client.solrj.io.stream.TupleStream.lambda$writeMap$0(TupleStream.java:82)
at
org.apache.solr.response.JSONWriter.writeIterator(JSONResponseWriter.java:523)
{code}
maybe this is a different issue?
> SQL AVG function mis-interprets field type.
> -------------------------------------------
>
> Key: SOLR-10341
> URL: https://issues.apache.org/jira/browse/SOLR-10341
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Parallel SQL
> Affects Versions: 6.5
> Reporter: Timothy Potter
> Attachments: Screen Shot 2017-03-22 at 8.12.33 AM.png
>
>
> Using movielens data (users, movies, ratings), I tried the following SQL:
> {code}
> curl --data-urlencode "stmt=SELECT solr.title as title, avg(rating) as
> avg_rating FROM ratings INNER JOIN (select movie_id,title from movies where
> _query_='plot_txt_en:love') as solr ON ratings.movie_id = solr.movie_id GROUP
> BY title ORDER BY avg_rating DESC LIMIT 10"
> "http://localhost:8983/solr/movies/sql?aggregationMode=facet";
> {code}
> Solr returns this error:
> {code}
> {"result-set":{"docs":[{"EXCEPTION":"Failed to execute sqlQuery 'SELECT
> solr.title as title, avg(rating) as avg_rating FROM ratings INNER JOIN
> (select movie_id,title from movies where _query_='plot_txt_en:love') as solr
> ON ratings.movie_id = solr.movie_id GROUP BY title ORDER BY avg_rating DESC
> LIMIT 10' against JDBC connection 'jdbc:calcitesolr:'.\nError while executing
> SQL \"SELECT solr.title as title, avg(rating) as avg_rating FROM ratings
> INNER JOIN (select movie_id,title from movies where
> _query_='plot_txt_en:love') as solr ON ratings.movie_id = solr.movie_id GROUP
> BY title ORDER BY avg_rating DESC LIMIT 10\": From line 1, column 29 to line
> 1, column 39: Cannot apply 'AVG' to arguments of type 'AVG(<JAVATYPE(CLASS
> JAVA.LANG.STRING)>)'. Supported form(s):
> 'AVG(<NUMERIC>)'","EOF":true,"RESPONSE_TIME":92}]}}
> {code}
> rating is a TrieInt with docValues enabled.
> {code}
> <field name="rating" type="tint" docValues="true" multiValued="false"
> indexed="true" stored="true"/>
> {code}
> see screenshot
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
