RE: [bulk]: Re: Dates and DataImportHandler

2017-09-21 Thread Mannott, Birgit
Forget it. I mixed up the timezone with the locale. I thought I could set the timezone for the DIH last index but that's not possible -Original Message- From: Mannott, Birgit [mailto:b.mann...@klopotek.de] Sent: Thursday, September 21, 2017 1:09 PM To: solr-user@lucene.apach

[bulk]: Re: Dates and DataImportHandler

2017-09-21 Thread Mannott, Birgit
ased on one's system configuration, I don't know. This stuff isn't very well documented. On Tue, Sep 19, 2017 at 7:22 AM, Mannott, Birgit wrote: > Hi, > > I have a similar problem. I try to change the timezone for the > last_index_time by setting > > t

RE: [bulk]: Dates and DataImportHandler

2017-09-19 Thread Mannott, Birgit
Hi, I have a similar problem. I try to change the timezone for the last_index_time by setting in the section of my data-config.xml file. But when doing this I always get a NullPointerException on Delta Import: 2017-09-15 14:04:00.825 INFO (Thread-2938) [ x:mex_prd_dev1100-ap] o

query with @ and *

2017-09-14 Thread Mannott, Birgit
Hi, I have a problem when searching on email addresses. @ seems to be handled as a special character but I don't find anything about it in the documentation. This is my test data t...@one.com t...@two.com searching for test* results both, ok. searching for t...@one.com results the correct one,

[bulk]: Re: Optimizing Dataimport from Oracle; cursor sharing; changing oracle session parameters

2017-08-17 Thread Mannott, Birgit
o it would be really great if the Data Import Handler would be able to use binding variables in selects so that cursor sharing could be done easier. Regards, Birgit -Original Message----- From: Mannott, Birgit [mailto:b.mann...@klopotek.de] Sent: Tuesday, August 15, 2017 4:58 PM To:

RE: [bulk]: Re: Optimizing Dataimport from Oracle; cursor sharing; changing oracle session parameters

2017-08-15 Thread Mannott, Birgit
a Import Handler? An alternative when you get into complex imports is to use a SolrJ client, here's a sample. That way you can use whatever tools the particular JDBC connector will allow and can be much faster. https://lucidworks.com/2012/02/14/indexing-with-solrj/ Best, Erick On Tue, Aug 15, 2017 at

Optimizing Dataimport from Oracle; cursor sharing; changing oracle session parameters

2017-08-15 Thread Mannott, Birgit
Hi, I'm using solr 6.6.0 and I have to do a complex data import from an oracle db concerning 3.500.000 data rows. For each row I have 15 additional entities. That means that more than 52 Million selects are send to the database. For every select that is done I optimized the oracle execution path