Return-Path: <dev-return-248774-archive-asf-public=cust-asf.ponee.io@lucene.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 03250200B21
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Thu, 26 May 2016 15:48:15 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 0092F160A2C; Thu, 26 May 2016 13:48:15 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 21245160A18
	for <archive-asf-public@cust-asf.ponee.io>; Thu, 26 May 2016 15:48:13 +0200 (CEST)
Received: (qmail 76945 invoked by uid 500); 26 May 2016 13:48:13 -0000
Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@lucene.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@lucene.apache.org>
List-Post: <mailto:dev@lucene.apache.org>
List-Id: <dev.lucene.apache.org>
Reply-To: dev@lucene.apache.org
Delivered-To: mailing list dev@lucene.apache.org
Received: (qmail 76887 invoked by uid 99); 26 May 2016 13:48:13 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 May 2016 13:48:13 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id DFAF32C1F5C
	for <dev@lucene.apache.org>; Thu, 26 May 2016 13:48:12 +0000 (UTC)
Date: Thu, 26 May 2016 13:48:12 +0000 (UTC)
From: "Minoru Osuka (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Message-ID: <JIRA.12971757.1463813850000.303122.1464270492913@Atlassian.JIRA>
In-Reply-To: <JIRA.12971757.1463813850000@Atlassian.JIRA>
References: <JIRA.12971757.1463813850000@Atlassian.JIRA> <JIRA.12971757.1463813850527@arcas>
Subject: [jira] [Commented] (SOLR-9141) ClassCastException occurs in /sql
 handler with GROUP BY aggregationMode=facet and single shard
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Thu, 26 May 2016 13:48:15 -0000


    [ https://issues.apache.org/jira/browse/SOLR-9141?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D15302=
079#comment-15302079 ]=20

Minoru Osuka commented on SOLR-9141:
------------------------------------

=E2=80=8B[~joel.bernstein], +1. ((Number)bucket.get("count")).longValue(); =
seems faster than my patch (on my Macbook).

{noformat}
package test;

import java.util.ArrayList;
import java.util.List;

public class CastTest {
=09public static void main(String[] args) {
=09=09List<Object> objList =3D new ArrayList<Object>();
=09=09for (int i =3D 0; i < 10000; i++) {
=09=09=09objList.add(new Integer(i));
=09=09}

=09=09long start =3D System.nanoTime();
=09=09for (Object obj : objList) {
=09=09=09long l =3D new Long(obj.toString()).longValue();
=09=09}
=09=09long end =3D System.nanoTime();
=09=09System.out.println(String.format("new Long(obj.toString()).longValue(=
); : %1$,10d ns", (end - start)));

=09=09start =3D System.nanoTime();
=09=09for (Object obj : objList) {
=09=09=09long l =3D ((Number)obj).longValue();
=09=09}
=09=09end =3D System.nanoTime();
=09=09System.out.println(String.format("((Number)obj).longValue();         =
   : %1$,10d ns", (end - start)));
=09}
}
{noformat}

{noformat}
new Long(obj.toString()).longValue(); : 11,301,332 ns
((Number)obj).longValue();            :    831,366 ns
{noformat}


> ClassCastException occurs in /sql handler with GROUP BY aggregationMode=
=3Dfacet and single shard
> -------------------------------------------------------------------------=
---------------------
>
>                 Key: SOLR-9141
>                 URL: https://issues.apache.org/jira/browse/SOLR-9141
>             Project: Solr
>          Issue Type: Bug
>          Components: Parallell SQL
>    Affects Versions: 6.0
>            Reporter: Minoru Osuka
>            Assignee: Joel Bernstein
>         Attachments: SOLR-9141-test.patch, SOLR-9141-test.patch, SOLR-914=
1.patch
>
>
> ClassCastException occurs in /sql request handler using -ORDER BY- GROUP =
BY clause.
> {noformat}
> $ curl --data-urlencode "stmt=3Dselect count(*) from access_log" "http://=
localhost:8983/solr/access_log/sql?aggregationMode=3Dfacet"
> {"result-set":{"docs":[
> {"count(*)":1309},
> {"EOF":true,"RESPONSE_TIME":239}]}}
> $ curl --data-urlencode 'stmt=3Dselect response, count(*) as count from a=
ccess_log group by response' "http://localhost:8983/solr/access_log/sql?agg=
regationMode=3Dfacet"
> {"result-set":{"docs":[
> {"EXCEPTION":"java.lang.ClassCastException: java.lang.Integer cannot be c=
ast to java.lang.Long","EOF":true,"RESPONSE_TIME":53}]}}
> {noformat}
> See following error messages:
> {noformat}
> 2016-05-19 10:18:06.477 ERROR (qtp1791930789-21) [c:access_log s:shard1 r=
:core_node1 x:access_log_shard1_replica1] o.a.s.c.s.i.s.ExceptionStream jav=
a.io.IOException: java.lang.ClassCastException: java.lang.Integer cannot be=
 cast to java.lang.Long
>     at org.apache.solr.client.solrj.io.stream.FacetStream.open(FacetStrea=
m.java:300)
>     at org.apache.solr.handler.SQLHandler$LimitStream.open(SQLHandler.jav=
a:1265)
>     at org.apache.solr.client.solrj.io.stream.SelectStream.open(SelectStr=
eam.java:153)
>     at org.apache.solr.handler.SQLHandler$MetadataStream.open(SQLHandler.=
java:1511)
>     at org.apache.solr.client.solrj.io.stream.ExceptionStream.open(Except=
ionStream.java:47)
>     at org.apache.solr.handler.StreamHandler$TimerStream.open(StreamHandl=
er.java:362)
>     at org.apache.solr.response.TextResponseWriter.writeTupleStream(TextR=
esponseWriter.java:301)
>     at org.apache.solr.response.TextResponseWriter.writeVal(TextResponseW=
riter.java:167)
>     at org.apache.solr.response.JSONWriter.writeNamedListAsMapWithDups(JS=
ONResponseWriter.java:183)
>     at org.apache.solr.response.JSONWriter.writeNamedList(JSONResponseWri=
ter.java:299)
>     at org.apache.solr.response.JSONWriter.writeResponse(JSONResponseWrit=
er.java:95)
>     at org.apache.solr.response.JSONResponseWriter.write(JSONResponseWrit=
er.java:60)
>     at org.apache.solr.response.QueryResponseWriterUtil.writeQueryRespons=
e(QueryResponseWriterUtil.java:65)
>     at org.apache.solr.servlet.HttpSolrCall.writeResponse(HttpSolrCall.ja=
va:725)
>     at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:469)
>     at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFi=
lter.java:229)
>     at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFi=
lter.java:184)
>     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv=
letHandler.java:1676)
>     at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFil=
ter.java:308)
>     at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginF=
ilter.java:262)
>     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv=
letHandler.java:1668)
>     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.j=
ava:581)
>     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandle=
r.java:143)
>     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.=
java:548)
>     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHa=
ndler.java:226)
>     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHa=
ndler.java:1160)
>     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.ja=
va:511)
>     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHan=
dler.java:185)
>     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHan=
dler.java:1092)
>     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandle=
r.java:141)
>     at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(C=
ontextHandlerCollection.java:213)
>     at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerC=
ollection.java:119)
>     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrap=
per.java:134)
>     at org.eclipse.jetty.server.Server.handle(Server.java:518)
>     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
>     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.=
java:244)
>     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abs=
tractConnection.java:273)
>     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
>     at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndP=
oint.java:93)
>     at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produ=
ceAndRun(ExecuteProduceConsume.java:246)
>     at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(E=
xecuteProduceConsume.java:156)
>     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThread=
Pool.java:654)
>     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadP=
ool.java:572)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast=
 to java.lang.Long
>     at org.apache.solr.client.solrj.io.stream.FacetStream.fillTuples(Face=
tStream.java:461)
>     at org.apache.solr.client.solrj.io.stream.FacetStream.getTuples(Facet=
Stream.java:420)
>     at org.apache.solr.client.solrj.io.stream.FacetStream.open(FacetStrea=
m.java:297)
>     ... 43 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org