Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A69CC10F27 for ; Wed, 18 Feb 2015 01:37:42 +0000 (UTC) Received: (qmail 16011 invoked by uid 500); 18 Feb 2015 01:37:36 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 15938 invoked by uid 500); 18 Feb 2015 01:37:36 -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 15926 invoked by uid 99); 18 Feb 2015 01:37:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Feb 2015 01:37:36 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of hensantos@gmail.com designates 209.85.216.42 as permitted sender) Received: from [209.85.216.42] (HELO mail-qa0-f42.google.com) (209.85.216.42) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Feb 2015 01:37:11 +0000 Received: by mail-qa0-f42.google.com with SMTP id w8so28692656qac.1 for ; Tue, 17 Feb 2015 17:37:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-type:message-id:mime-version:subject:date:references :to:in-reply-to; bh=QWSa6u1wlT8hsvcWlRUGY1Y8A3zgmyzk0rD+voanJ60=; b=LuB1aj0upYGW1faMo7XWq+o/jtk+3IpH69urGNPZ43sNNEzDJ5yPKiQ3HYWBVRGa6C 5gzPCx4XP3DBBsyziYMLde19eIEWzYh4Q3Y4JrKLtMz9gKOryrb/3Q5R2k8zu3DOGIhf o5rROsXcrVTs7jx52SxUe5kRlNCuaQ4Iths3oxt1z+xhkThII8jcG8w/Utv15BLg0qH/ Sd7ZYW0efTATHe5Cn1pUxrEkQsPgnysminu+LY9+PB1Iinf4JxnQOcO/IJPxKKUgTCTo y2FLRPmFDUwJOrAzhW4x+UjgiJB6CNrMsF6cfGj0DHwCOby5Nh3y8JgZvUs8xiFDrFyP LKwg== X-Received: by 10.140.92.161 with SMTP id b30mr2990999qge.59.1424223429608; Tue, 17 Feb 2015 17:37:09 -0800 (PST) Received: from [192.168.1.106] (radical-red-26.dynamic2.rpi.edu. [128.113.106.87]) by mx.google.com with ESMTPSA id w105sm16947626qgw.25.2015.02.17.17.37.08 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 17 Feb 2015 17:37:08 -0800 (PST) From: Henrique Oliveira Content-Type: multipart/alternative; boundary="Apple-Mail=_F18535CD-06EE-4008-895B-2F038D3F8A27" Message-Id: <800F2374-8471-46C2-A11B-0B8F60CBF88E@gmail.com> Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2070.6\)) Subject: Re: CSV entry as multiple documents Date: Tue, 17 Feb 2015 20:37:07 -0500 References: <9C00AC13-3AA3-4838-B448-79018D4BA606@gmail.com> To: solr-user@lucene.apache.org In-Reply-To: X-Mailer: Apple Mail (2.2070.6) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_F18535CD-06EE-4008-895B-2F038D3F8A27 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Yes, Alexandre is right about my question. To make it clear, a CSV that = look like: t1,v1,v2,v2 2015-01-01T01:59:00Z,0.3,0.5,0.7 2015-01-01T02:00:00Z,0.4,0.5,0.8 would be the same of indexing t1,v 2015-01-01T01:59:00Z,0.3 2015-01-01T01:59:00Z,0.5 2015-01-01T01:59:00Z,0.7 2015-01-01T02:00:00Z,0.4 2015-01-01T02:00:00Z,0.5 2015-01-01T02:00:00Z,0.8 I don=E2=80=99t know if multiValued field would do the trick. Do you = have more info on that split command? Henrique > On Feb 17, 2015, at 7:57 PM, Alexandre Rafalovitch = wrote: >=20 > I think the question asked was a bit different. It was about having > one row/document split into multiple with some fields replicated and > some mapped. >=20 > JSON (single-document format) has a split command which might be > similar to what's being asked. CSV has a split command as well, but I > think it is more about creating a multiValued field. >=20 > Or did I miss a different parameter? >=20 > Regards, > Alex. > ---- > Sign up for my Solr resources newsletter at http://www.solr-start.com/ >=20 >=20 > On 17 February 2015 at 19:41, Anshum Gupta = wrote: >> Hi Henrique, >>=20 >> Solr supports posting a csv with multiple rows. Have a look at the >> documentation in the ref. guide here: >> = https://cwiki.apache.org/confluence/display/solr/Uploading+Data+with+Index= +Handlers#UploadingDatawithIndexHandlers-CSVFormattedIndexUpdates >>=20 >>=20 >>=20 >> On Tue, Feb 17, 2015 at 2:44 PM, Henrique Oliveira = >> wrote: >>=20 >>> Hi all, >>>=20 >>> I was wondering if there is a way to tell Solr to treat a CSV entry = as >>> multiple documents instead of one document. For instance, suppose = that a >>> CSV file has 4 fields and a single entry: >>> t1,v1,v2,v3 >>> 2015-01-01T01:00:59Z,0.3,0.5,0.7 >>>=20 >>> I want Solr to update its index like it were 3 different documents: >>> t1,v >>> 2015-01-01T01:00:59Z,0.3 >>> 2015-01-01T01:00:59Z,0.5 >>> 2015-01-01T01:00:59Z,0.7 >>>=20 >>> Is that possible, or do I have to create a different CSV for it? >>>=20 >>> Many thanks, >>> Henrique. >>=20 >>=20 >>=20 >>=20 >> -- >> Anshum Gupta >> http://about.me/anshumgupta --Apple-Mail=_F18535CD-06EE-4008-895B-2F038D3F8A27--