lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-10341) SQL AVG function mis-interprets field type.
Date Tue, 28 Mar 2017 19:31:41 GMT

    [ https://issues.apache.org/jira/browse/SOLR-10341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15945782#comment-15945782
] 

ASF subversion and git services commented on SOLR-10341:
--------------------------------------------------------

Commit 4c979b84e8d5bd3eb4cc34f90834cedbf2a374ed in lucene-solr's branch refs/heads/branch_6_5
from [~joel.bernstein]
[ https://git-wip-us.apache.org/repos/asf?p=lucene-solr.git;h=4c979b8 ]

SOLR-10341: SQL AVG function mis-interprets field type


> 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, SOLR-10341.patch, SOLR-10341.patch
>
>
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message