Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread stockii
yes. thx for your help =) - --- System One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cores < 100.000 - Solr1 for Search-Requests - commit every Minute - 5GB Xmx - Solr2 for Upda

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread Gora Mohanty
On Tue, May 24, 2011 at 5:36 PM, stockii wrote: > i am so an IDIOT !!! SORRRYY XD hehe > > i wrote "zeroDateTimeBehavOIr" and not "zeroDateTimeBehavior" [...] Heh! So, everything OK, now? Regards, Gora P.S. I did ask about this earlier in the thread :-)

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread stockii
i am so an IDIOT !!! SORRRYY XD hehe i wrote "zeroDateTimeBehavOIr" and not "zeroDateTimeBehavior" ... - --- System One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cores <

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread stockii
new error message: -00-00^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread stockii
SELECT CONCAT('tablename_', CAST(cp.id AS CHAR)) AS uniquekey, cp.id, cp.fieldname .., mp.fieldname, mp. FROM consumer AS cp INNER JOIN morepush AS mp ON cp.id = mp.id in my "query" is a "norma" JOIN select. - --- System -

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread Gora Mohanty
On Tue, May 24, 2011 at 1:03 PM, stockii wrote: > okay, thx =) [...] So, which version of Solr are you using? Just tried this with Solr 1.4, and things seem to work as expected for me. Here is what I did: * Inserted a zero value into a mysql date field called testdate (also tried with datetime

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-24 Thread stockii
okay, thx =) - --- System One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cores < 100.000 - Solr1 for Search-Requests - commit every Minute - 5GB Xmx - Solr2 for Update-Request -

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-23 Thread Gora Mohanty
On Mon, May 23, 2011 at 7:03 PM, stockii wrote: > yes. i put the &zeroDateTimeBehavior=convertToNull to my url like: > url="jdbc:mysql://localhost/databaseName?zeroDateTimeBehavoir=convertToNull" I presume that this is just a typo here, i.e., "Behavoir" instead of "Behavior"

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-23 Thread stockii
the problems are not the empty -00-00 values. the problem is the missing timestamp at the end of the string ! - --- System One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cor

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-23 Thread stockii
yes. i put the &zeroDateTimeBehavior=convertToNull to my url like: url="jdbc:mysql://localhost/databaseName?zeroDateTimeBehavoir=convertToNull" ExceptoiN: May 23, 2011 3:30:22 PM org.apache.solr.handler.dataimport.DataImporter doFullImport SEVERE: Full Import failed org.apache.solr.handler.datai

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-23 Thread Gora Mohanty
On Mon, May 23, 2011 at 6:51 PM, stockii wrote: > okay. i didn find the problem =( > it sstill the same shit. > > i cannot conver with DateTimeFormater dates form -00-00 => > "-MM-dd'T'hh:mm:ss'Z'" [...] Please post the exact Solr exception. Have you tried the last suggestion in the DIH

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-23 Thread stockii
okay. i didn find the problem =( it sstill the same shit. i cannot conver with DateTimeFormater dates form -00-00 => "-MM-dd'T'hh:mm:ss'Z'" i put my date fields into another entity: solr throws exceptopn like above. WHY cannot transform

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-19 Thread stockii
okay, i found the problem. i put the fields two times in my data-config ;-) - --- System One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cores < 100.000 - Solr1 for Search-Request

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-19 Thread stockii
that not works with fields with this value: -00-00 OR/AND 2011-05-18 id tried with: but solr say always that these fields have a wrong format ! i try my sql-selects before i post it here ,-) - --- System One Serv

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-19 Thread Erick Erickson
Offhand, I don't think the problem is DIH since your stack trace specifies a SQL error. What is the SQL you're using? And the DIH configuration? Best Erick On Thu, May 19, 2011 at 10:53 AM, stockii wrote: > did you mean something like this ? > > DATE_FORMAT(cp.field, '%Y-%m-%di %H:%i:%s') AS fie

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-19 Thread stockii
did you mean something like this ? DATE_FORMAT(cp.field, '%Y-%m-%di %H:%i:%s') AS field ??? i think i need to add the timestamp to my date fields? or not ? why cannot DIH handle with this ? - --- System One Server, 12 G

Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH

2011-05-19 Thread roySolr
Try this in your query: TIME_FORMAT(timeDb, '%H:%i') as timefield http://www.java2s.com/Tutorial/MySQL/0280__Date-Time-Functions/TIMEFORMATtimeformat.htm -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-convert--MM-DD-to-YYY-MM-DD-hh-mm-ss-DIH-tp2961481p2961591.ht