From solr-user-return-138906-archive-asf-public=cust-asf.ponee.io@lucene.apache.org Thu Feb 8 16:14:16 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 07D64180677 for ; Thu, 8 Feb 2018 16:14:16 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id EC93F160C5D; Thu, 8 Feb 2018 15:14: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 17ACC160C4A for ; Thu, 8 Feb 2018 16:14:14 +0100 (CET) Received: (qmail 78225 invoked by uid 500); 8 Feb 2018 15:14:12 -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 77153 invoked by uid 99); 8 Feb 2018 15:14:11 -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; Thu, 08 Feb 2018 15:14:11 +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 5E5EC180256 for ; Thu, 8 Feb 2018 15:14:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.022 X-Spam-Level: X-Spam-Status: No, score=-0.022 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=wayfair.onmicrosoft.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id MUsPvejdXBX4 for ; Thu, 8 Feb 2018 15:14:08 +0000 (UTC) Received: from NAM01-BN3-obe.outbound.protection.outlook.com (mail-bn3nam01on0110.outbound.protection.outlook.com [104.47.33.110]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id DB2425F11F for ; Thu, 8 Feb 2018 15:14:07 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wayfair.onmicrosoft.com; s=selector1-wayfair-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=2Ks0n2wuJhQKFT5cLVAg/mbf1tWU4ncJP7O4jPDDlsg=; b=WY/4pAbPj5jcq9Fj+fr28bT/SrrWm1UjEblCoUEMlyp1jStVInLF+ai2v37Lch0yatH/MAhzWdm9N9LJq5dvu9q25MmbxJtgAVSIpRBg8Fp9Y4ID9ih2KgQ6gSoZIdBDZCHKT2mxznHEQDQQT6FnFZ1t6Ehv0m6cRE9btTaUn6M= Received: from BN6PR10MB1699.namprd10.prod.outlook.com (10.172.20.17) by BN6PR10MB1298.namprd10.prod.outlook.com (10.173.29.136) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.485.10; Thu, 8 Feb 2018 15:14:00 +0000 Received: from BN6PR10MB1699.namprd10.prod.outlook.com ([10.172.20.17]) by BN6PR10MB1699.namprd10.prod.outlook.com ([10.172.20.17]) with mapi id 15.20.0485.009; Thu, 8 Feb 2018 15:14:00 +0000 From: Brian Yee To: "solr-user@lucene.apache.org" Subject: RE: Payload fields Thread-Topic: Payload fields Thread-Index: AdOgWBpYSS1SeoJMR46gwTz2lPi5agAlw99w Date: Thu, 8 Feb 2018 15:14:00 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=byee@wayfair.com; x-originating-ip: [69.46.227.226] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BN6PR10MB1298;7:M5JqyluviSHF8/vXnZ/x0yIznBNBHtJ/vpWrzk+bi3nu0zQwbbODHXMunzRStt7+S7boS0BxaehwyWk4CvX7CnilCPlcCeQdNHjUbI93abo5B6Jlgm6dqn4EAYxm2VPYjyNftiHGUoDo+3y7DaJssFGDT+eWEoupDkdncL/85KHrl/dvKIgVFlcKDqcvzJiK+nFG9VJceWWjeuV9bIbjIQ3QJu4iupfhCK0q6DIxH0nb1sYQeNrK1/eWuJExvCYR x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: 657b7860-5656-403e-f2e1-08d56f069556 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(4604075)(3008032)(4534165)(4627221)(201703031133081)(201702281549075)(2017052603307)(7153060)(7193020);SRVR:BN6PR10MB1298; x-ms-traffictypediagnostic: BN6PR10MB1298: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(613862345122)(263907834895145); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040501)(2401047)(8121501046)(5005006)(3231101)(2400082)(944501161)(10201501046)(3002001)(93006095)(93001095)(6041288)(20161123560045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123558120)(20161123562045)(20161123564045)(6072148)(201708071742011);SRVR:BN6PR10MB1298;BCL:0;PCL:0;RULEID:;SRVR:BN6PR10MB1298; x-forefront-prvs: 0577AD41D6 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(396003)(376002)(366004)(39380400002)(346002)(39860400002)(13464003)(189003)(199004)(14454004)(8676002)(81156014)(81166006)(3480700004)(8936002)(186003)(97736004)(3846002)(6116002)(25786009)(68736007)(76176011)(55016002)(7696005)(66066001)(3660700001)(6246003)(5640700003)(6436002)(221733001)(305945005)(86362001)(229853002)(59450400001)(7736002)(74316002)(2501003)(3280700002)(102836004)(77096007)(26005)(6506007)(53546011)(2351001)(106356001)(99286004)(2900100001)(316002)(7116003)(5660300001)(53936002)(9686003)(478600001)(105586002)(33656002)(6916009)(2950100002)(2906002);DIR:OUT;SFP:1102;SCL:1;SRVR:BN6PR10MB1298;H:BN6PR10MB1699.namprd10.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: wayfair.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: GOUyg/ozYWWsv0i30Lctd/CDY0niKC8EZFMJNKs6gwrIu6akeKd5vedk6uaVDfzNt1IA0L33WMYekyE5kjJ3kA== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: wayfair.com X-MS-Exchange-CrossTenant-Network-Message-Id: 657b7860-5656-403e-f2e1-08d56f069556 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Feb 2018 15:14:00.7377 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6b5d7b4d-892b-4297-a74b-3cd84e04ed4e X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN6PR10MB1298 I also noticed a weird pattern with the results. This is from doing fl=3DZo= ne01:payload(DeliveryPayload,01) for each zone. Can't figure out why this w= ould happen. "DeliveryPayload": "01|20180210 02|20180211 03|20180212 04|2= 0180213 05|20180214 06|20180215 07|20180216 08|20180217 09|20180218 10|2018= 0219 11|20180220 12|20180221" "Zone01": 20180210, "Zone02": 20180212, "Zone03": 20180212, "Zone04": 20180212, "Zone05": 20180214, "Zone06": 20180216, "Zone07": 20180216, "Zone08": 20180216, "Zone09": 20180218, "Zone10": 20180220, "Zone11": 20180220, "Zone12": 20180220, -----Original Message----- From: Brian Yee [mailto:byee@wayfair.com]=20 Sent: Wednesday, February 7, 2018 4:32 PM To: solr-user@lucene.apache.org Subject: Payload fields Hello, I am trying to use Payload fields to store per-zone delivery dates for prod= ucts. I have an index where my documents are products and for each product = we want to store a date by when we can deliver that product for 1-100 diffe= rent zones. Since the payload() function only supports int and float, I am = representing my dates as 20180210. So my payload field looks like this: 1|20180210 2|20180211 3|20180212 4|20180213 5|20180214 However when I load that data into my index and add "fl=3DZone2:payload(Del= iveryPayload,2)" I get the wrong result in my output. It shows me "Zone2": = 20180212. I don't understand why. The only thing I can think of is that the int is to= o big. Is there a size limit? If I reduce it to a 6 or 7 digit int, things = work as expected. Shouldn't INT handle up to 2B? My schema.xml looks like this: