Re: Data Import Handler on 6.4.1
Also, upgrade to 6.4.2. There are serious performance problems in 6.4.0 and 6.4.1. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On Mar 15, 2017, at 12:05 PM, Liu, Daphne > wrote: > > For Solr 6.3, I have to move mine to > ../solr-6.3.0/server/solr-webapp/webapp/WEB-INF/lib. If you are using jetty. > > Kind regards, > > Daphne Liu > BI Architect - Matrix SCM > > CEVA Logistics / 10751 Deerwood Park Blvd, Suite 200, Jacksonville, FL 32256 > USA / www.cevalogistics.com T 904.564.1192 / F 904.928.1448 / > daphne@cevalogistics.com > > > -Original Message- > From: Michael Tobias [mailto:mtob...@btinternet.com] > Sent: Wednesday, March 15, 2017 2:36 PM > To: solr-user@lucene.apache.org > Subject: Data Import Handler on 6.4.1 > > I am sure I am missing something simple but > > I am running Solr 4.8.1 and trialling 6.4.1 on another computer. > > I have had to manually modify the automatic 6.4.1 scheme config as we use a > set of specialised field types. They work fine. > > I am now trying to populate my core with data and having problems. > > Exactly what names/paths should I be using in the solrconfig.xml file to get > this working - I don’t recall doing ANYTHING for 4.8.1 > > regex=".*\.jar" /> > regex="solr-dataimporthandler-.*\.jar" /> ? > > And where do I put the mysql-connector-java-5.1.29-bin.jar file and how do I > reference it to get it loaded? > > > ?? > > And then later in the solrconfig.xml I have: > > class="org.apache.solr.handler.dataimport.DataImportHandler"> > >db-data-config.xml > > > > > Any help much appreciated. > > Regards > > Michael > > > -Original Message- > From: David Hastings [mailto:hastings.recurs...@gmail.com] > Sent: 15 March 2017 17:47 > To: solr-user@lucene.apache.org > Subject: Re: Get handler not working > > from your previous email: > "There is no "id" > field defined in the schema." > > you need an id field to use the get handler > > On Wed, Mar 15, 2017 at 1:45 PM, Chris Ulicny wrote: > >> I thought that "id" and "ids" were fixed parameters for the get >> handler, but I never remember, so I've already tried both. Each time >> it comes back with the same response of no document. >> >> On Wed, Mar 15, 2017 at 1:31 PM Alexandre Rafalovitch >> >> wrote: >> >>> Actually. >>> >>> I think Real Time Get handler has "id" as a magical parameter, not >>> as a field name. It maps to the real id field via the uniqueKey >>> definition: >>> https://cwiki.apache.org/confluence/display/solr/RealTime+Get >>> >>> So, if you have not, could you try the way you originally wrote it. >>> >>> Regards, >>> Alex. >>> >>> http://www.solr-start.com/ - Resources for Solr users, new and >> experienced >>> >>> >>> On 15 March 2017 at 13:22, Chris Ulicny wrote: >>>> Sorry, that is a typo. The get is using the iqdocid field. There >>>> is no >>> "id" >>>> field defined in the schema. >>>> >>>> solr/TestCollection/get?iqdocid=2957-TV-201604141900 >>>> >>>> solr/TestCollection/select?q=*:*&fq=iqdocid:2957-TV-201604141900 >>>> >>>> On Wed, Mar 15, 2017 at 1:15 PM Erick Erickson < >> erickerick...@gmail.com> >>>> wrote: >>>> >>>>> Is this a typo or are you trying to use get with an "id" field >>>>> and your filter query uses "iqdocid"? >>>>> >>>>> Best, >>>>> Erick >>>>> >>>>> On Wed, Mar 15, 2017 at 8:31 AM, Chris Ulicny >> wrote: >>>>>> Yes, we're using a fixed schema with the iqdocid field set as >>>>>> the >>>>> uniqueKey. >>>>>> >>>>>> On Wed, Mar 15, 2017 at 11:28 AM Alexandre Rafalovitch < >>>>> arafa...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> What is your uniqueKey? Is it iqdocid? >>>>>>> >>>>>>> Regards, >>>>>>> Alex. >>>>>>> >>>>>>> http://www.solr-start.com/ - Resources for Solr users, new and >>>>> experienced >>>>&g
RE: Data Import Handler on 6.4.1
For Solr 6.3, I have to move mine to ../solr-6.3.0/server/solr-webapp/webapp/WEB-INF/lib. If you are using jetty. Kind regards, Daphne Liu BI Architect - Matrix SCM CEVA Logistics / 10751 Deerwood Park Blvd, Suite 200, Jacksonville, FL 32256 USA / www.cevalogistics.com T 904.564.1192 / F 904.928.1448 / daphne@cevalogistics.com -Original Message- From: Michael Tobias [mailto:mtob...@btinternet.com] Sent: Wednesday, March 15, 2017 2:36 PM To: solr-user@lucene.apache.org Subject: Data Import Handler on 6.4.1 I am sure I am missing something simple but I am running Solr 4.8.1 and trialling 6.4.1 on another computer. I have had to manually modify the automatic 6.4.1 scheme config as we use a set of specialised field types. They work fine. I am now trying to populate my core with data and having problems. Exactly what names/paths should I be using in the solrconfig.xml file to get this working - I don’t recall doing ANYTHING for 4.8.1 ? And where do I put the mysql-connector-java-5.1.29-bin.jar file and how do I reference it to get it loaded? ?? And then later in the solrconfig.xml I have: db-data-config.xml Any help much appreciated. Regards Michael -Original Message- From: David Hastings [mailto:hastings.recurs...@gmail.com] Sent: 15 March 2017 17:47 To: solr-user@lucene.apache.org Subject: Re: Get handler not working from your previous email: "There is no "id" field defined in the schema." you need an id field to use the get handler On Wed, Mar 15, 2017 at 1:45 PM, Chris Ulicny wrote: > I thought that "id" and "ids" were fixed parameters for the get > handler, but I never remember, so I've already tried both. Each time > it comes back with the same response of no document. > > On Wed, Mar 15, 2017 at 1:31 PM Alexandre Rafalovitch > > wrote: > > > Actually. > > > > I think Real Time Get handler has "id" as a magical parameter, not > > as a field name. It maps to the real id field via the uniqueKey > > definition: > > https://cwiki.apache.org/confluence/display/solr/RealTime+Get > > > > So, if you have not, could you try the way you originally wrote it. > > > > Regards, > >Alex. > > > > http://www.solr-start.com/ - Resources for Solr users, new and > experienced > > > > > > On 15 March 2017 at 13:22, Chris Ulicny wrote: > > > Sorry, that is a typo. The get is using the iqdocid field. There > > > is no > > "id" > > > field defined in the schema. > > > > > > solr/TestCollection/get?iqdocid=2957-TV-201604141900 > > > > > > solr/TestCollection/select?q=*:*&fq=iqdocid:2957-TV-201604141900 > > > > > > On Wed, Mar 15, 2017 at 1:15 PM Erick Erickson < > erickerick...@gmail.com> > > > wrote: > > > > > >> Is this a typo or are you trying to use get with an "id" field > > >> and your filter query uses "iqdocid"? > > >> > > >> Best, > > >> Erick > > >> > > >> On Wed, Mar 15, 2017 at 8:31 AM, Chris Ulicny > wrote: > > >> > Yes, we're using a fixed schema with the iqdocid field set as > > >> > the > > >> uniqueKey. > > >> > > > >> > On Wed, Mar 15, 2017 at 11:28 AM Alexandre Rafalovitch < > > >> arafa...@gmail.com> > > >> > wrote: > > >> > > > >> >> What is your uniqueKey? Is it iqdocid? > > >> >> > > >> >> Regards, > > >> >>Alex. > > >> >> > > >> >> http://www.solr-start.com/ - Resources for Solr users, new and > > >> experienced > > >> >> > > >> >> > > >> >> On 15 March 2017 at 11:24, Chris Ulicny wrote: > > >> >> > Hi, > > >> >> > > > >> >> > I've been trying to use the get handler for a new solr cloud > > >> collection > > >> >> we > > >> >> > are using, and something seems to be amiss. > > >> >> > > > >> >> > We are running 6.3.0, so we did not explicitly define the > > >> >> > request > > >> handler > > >> >> > in the solrconfig since it's supposed to be implicitly defined. > We > > >> also > > >> >> > have the update log enabled with the default configuration. > > >> >> > > > >> >> > Whene
Data Import Handler on 6.4.1
I am sure I am missing something simple but I am running Solr 4.8.1 and trialling 6.4.1 on another computer. I have had to manually modify the automatic 6.4.1 scheme config as we use a set of specialised field types. They work fine. I am now trying to populate my core with data and having problems. Exactly what names/paths should I be using in the solrconfig.xml file to get this working - I don’t recall doing ANYTHING for 4.8.1 ? And where do I put the mysql-connector-java-5.1.29-bin.jar file and how do I reference it to get it loaded? ?? And then later in the solrconfig.xml I have: db-data-config.xml Any help much appreciated. Regards Michael -Original Message- From: David Hastings [mailto:hastings.recurs...@gmail.com] Sent: 15 March 2017 17:47 To: solr-user@lucene.apache.org Subject: Re: Get handler not working from your previous email: "There is no "id" field defined in the schema." you need an id field to use the get handler On Wed, Mar 15, 2017 at 1:45 PM, Chris Ulicny wrote: > I thought that "id" and "ids" were fixed parameters for the get > handler, but I never remember, so I've already tried both. Each time > it comes back with the same response of no document. > > On Wed, Mar 15, 2017 at 1:31 PM Alexandre Rafalovitch > > wrote: > > > Actually. > > > > I think Real Time Get handler has "id" as a magical parameter, not > > as a field name. It maps to the real id field via the uniqueKey > > definition: > > https://cwiki.apache.org/confluence/display/solr/RealTime+Get > > > > So, if you have not, could you try the way you originally wrote it. > > > > Regards, > >Alex. > > > > http://www.solr-start.com/ - Resources for Solr users, new and > experienced > > > > > > On 15 March 2017 at 13:22, Chris Ulicny wrote: > > > Sorry, that is a typo. The get is using the iqdocid field. There > > > is no > > "id" > > > field defined in the schema. > > > > > > solr/TestCollection/get?iqdocid=2957-TV-201604141900 > > > > > > solr/TestCollection/select?q=*:*&fq=iqdocid:2957-TV-201604141900 > > > > > > On Wed, Mar 15, 2017 at 1:15 PM Erick Erickson < > erickerick...@gmail.com> > > > wrote: > > > > > >> Is this a typo or are you trying to use get with an "id" field > > >> and your filter query uses "iqdocid"? > > >> > > >> Best, > > >> Erick > > >> > > >> On Wed, Mar 15, 2017 at 8:31 AM, Chris Ulicny > wrote: > > >> > Yes, we're using a fixed schema with the iqdocid field set as > > >> > the > > >> uniqueKey. > > >> > > > >> > On Wed, Mar 15, 2017 at 11:28 AM Alexandre Rafalovitch < > > >> arafa...@gmail.com> > > >> > wrote: > > >> > > > >> >> What is your uniqueKey? Is it iqdocid? > > >> >> > > >> >> Regards, > > >> >>Alex. > > >> >> > > >> >> http://www.solr-start.com/ - Resources for Solr users, new and > > >> experienced > > >> >> > > >> >> > > >> >> On 15 March 2017 at 11:24, Chris Ulicny wrote: > > >> >> > Hi, > > >> >> > > > >> >> > I've been trying to use the get handler for a new solr cloud > > >> collection > > >> >> we > > >> >> > are using, and something seems to be amiss. > > >> >> > > > >> >> > We are running 6.3.0, so we did not explicitly define the > > >> >> > request > > >> handler > > >> >> > in the solrconfig since it's supposed to be implicitly defined. > We > > >> also > > >> >> > have the update log enabled with the default configuration. > > >> >> > > > >> >> > Whenever I send a get query for a document already known to > > >> >> > be in > > the > > >> >> > collection, I get no documents returned. But when I use a > > >> >> > filter > > >> query on > > >> >> > the uniqueKey field for the same value I get the document > > >> >> > back > > >> >> > > > >> >> > solr/TestCollection/get?id=2957-TV-201604141900 > > >> >> > > > >> >> > solr/TestCollection/select?q=*:*&fq=iqdocid:2957-TV-20160414 > > >> >> > 1900 > > >> >> > > > >> >> > Is there some configuration that I am missing? > > >> >> > > > >> >> > Thanks, > > >> >> > Chris > > >> >> > > >> > > >