Return-Path: 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 6BB23200D2F for ; Wed, 1 Nov 2017 22:45:13 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 6A370160BEA; Wed, 1 Nov 2017 21:45:13 +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 B157B1609EC for ; Wed, 1 Nov 2017 22:45:12 +0100 (CET) Received: (qmail 87188 invoked by uid 500); 1 Nov 2017 21:45:10 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 87176 invoked by uid 99); 1 Nov 2017 21:45:10 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Nov 2017 21:45:10 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id A5EFB180739 for ; Wed, 1 Nov 2017 21:45:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.442 X-Spam-Level: *** X-Spam-Status: No, score=3.442 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URI_HEX=1.313] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id aRutfagtMIqJ for ; Wed, 1 Nov 2017 21:45:08 +0000 (UTC) Received: from mail-wm0-f51.google.com (mail-wm0-f51.google.com [74.125.82.51]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id BFCB95F36D for ; Wed, 1 Nov 2017 21:45:07 +0000 (UTC) Received: by mail-wm0-f51.google.com with SMTP id s66so7188826wmf.5 for ; Wed, 01 Nov 2017 14:45:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=WyrdkbnCI44TXtbylBkpUF9m3EhhqMjIJJljzNa6quk=; b=qb3DJsYcAz/AKsiXOB4IRJkIFNxt23taHhL6HUI8kVnNuKkIhbILrlCNG5kyvME7Eb /Vk3RNc6bQlli//qFV0MPk5du5X7NnYDFiQtQ9o0DPwvXsNJWGv8hpLJazOb06ANpKvs IpaVebc3hB69JFwAn7dekErPPO3zpjJvp//ajeklIo0gjrHxjAP61A3boT+g+G1koa3D QRMhA6a9cvvBQSSwyx8bvoJd08Fyzn+PvXZeF2OOuiRrFgqS3S54cZzW1fKKialivco4 Sfhg1ZAwh5uWwdoXHMF9G/DI2HX+xmBJZDMHm/RHR06Ba1cpWuOqfvBQUWjqTD4VpqYS 2AHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=WyrdkbnCI44TXtbylBkpUF9m3EhhqMjIJJljzNa6quk=; b=nfeVgZ9WahmjPvBkV+w+7DNkwBtxdX8ZQYjJY8L50uAK3ha1YmVadx56Wxp8KWSUYn avl3cjvg6OhGyJx8wtR1/m2XF9P8UkjuarxBTErYhNYekldwYa43rYjrz5PCmPOrkP0d KaQ80Al/PhBGxiPzV8TpuCzvHZf8c/tVIxmBec7uu++0rW3/YoQcrws2k/4h5f7SvxPg HYDX6irgJB4SKL35ZGcFqBZ8MTpyPosdMIrDruVBMEzRSHrHPqBAcbAqonlNnXLpOJXk oOYhs3/g9CFi56p9UB5UuStxjG19kKE+/nFbdK0bee1jrT+o5CNXQ8CYM3Bb+69tTOlx 3T+A== X-Gm-Message-State: AMCzsaXhRGpXeSxfj4RNwAswzrFAohO22iFvcEtysXMLq88rBP3WMWTe EUpRh8cKCbbv+gpDvIYQPElS9+Dz5CAhoMN6T9E= X-Google-Smtp-Source: ABhQp+TcMY3Ha0PAfUucKo5OZfnbvYWSQucYUIfHvQ2sQfFE1OBWq5XhQ6n/ZJFAjn/mKe0XOGdz2bsSzavBKkJvPZ4= X-Received: by 10.80.192.27 with SMTP id r27mr1915450edb.138.1509572706433; Wed, 01 Nov 2017 14:45:06 -0700 (PDT) MIME-Version: 1.0 Received: by 10.80.202.2 with HTTP; Wed, 1 Nov 2017 14:45:05 -0700 (PDT) In-Reply-To: References: From: Amrit Sarkar Date: Thu, 2 Nov 2017 03:15:05 +0530 Message-ID: Subject: Re: Streaming Expression - cartesianProduct To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary="94eb2c1cd14aedfea1055cf2c884" archived-at: Wed, 01 Nov 2017 21:45:13 -0000 --94eb2c1cd14aedfea1055cf2c884 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Following Pratik's spot-on comment and not really related to your question, Even the "partitionKeys" parameter needs to be specified the "over" field while using "parallel" streaming. Amrit Sarkar Search Engineer Lucidworks, Inc. 415-589-9269 www.lucidworks.com Twitter http://twitter.com/lucidworks LinkedIn: https://www.linkedin.com/in/sarkaramrit2 On Thu, Nov 2, 2017 at 2:38 AM, Pratik Patel wrote: > Roll up needs documents to be sorted by the "over" field. > Check this for more details > http://lucene.472066.n3.nabble.com/Streaming-Expressions-rollup-function- > returning-results-with-duplicate-tuples-td4342398.html > > On Wed, Nov 1, 2017 at 3:41 PM, Kojo wrote: > > > Wrap cartesianProduct function with fetch function works as expected. > > > > But rollup function over cartesianProduct doesn=C2=B4t aggregate on a r= eturned > > field of the cartesianProduct. > > > > > > The field "id_researcher" bellow is a Multivalued field: > > > > > > > > This one works: > > > > > > fetch(reasercher, > > > > cartesianProduct( > > having( > > cartesianProduct( > > search(schoolarship,zkHost=3D"localhost:9983",qt=3D"/export= ", > > q=3D"*:*", > > fl=3D"process, area, id_reasercher",sort=3D"process asc"), > > area > > ), > > eq(area, val(Anything))), > > id_reasercher), > > fl=3D"name, django_id", > > on=3D"id_reasercher=3Ddjango_id" > > ) > > > > > > This one doesn=C2=B4t works: > > > > rollup( > > > > cartesianProduct( > > having( > > cartesianProduct( > > search(schoolarship,zkHost=3D"localhost:9983",qt=3D"/export= ", > > q=3D"*:*", > > fl=3D"process, area, id_researcher, status",sort=3D"process asc"), > > area > > ), > > eq(area, val(Anything))), > > id_researcher), > > over=3Did_researcher,count(*) > > ) > > > > If I aggregate over a non MultiValued field, it works. > > > > > > Is that correct, rollup doesn=C2=B4t work on a cartesianProduct? > > > --94eb2c1cd14aedfea1055cf2c884--