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 -
On Tue, May 24, 2011 at 1:03 PM, stockii stock.jo...@googlemail.com 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
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
new error message:
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
On Tue, May 24, 2011 at 5:36 PM, stockii stock.jo...@googlemail.com 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 :-)
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
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:
entity name=dates query=SELECT * FROM consumer WHERE
id='${main.cp_id}'
field
On Mon, May 23, 2011 at 6:51 PM, stockii stock.jo...@googlemail.com 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
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
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
On Mon, May 23, 2011 at 7:03 PM, stockii stock.jo...@googlemail.com 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
Hello
i want to index some datefields with this dateformat: -mm-dd. Solr
thwows an exception like this: can not be represented as java.sql.Date
i am unsing ...transformer=DateFormatTransformer
and ...zeroDateTimeBehavoir=convertToNull
how can i say to DIH to convert this fields in correct
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:
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
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 stock.jo...@googlemail.com wrote:
did you mean something like this ?
DATE_FORMAT(cp.field,
entity name=foo pk=cp_id transformer=DateFormatTransformer
query=SELECT ...,
...some fields ...
cp.start_date_1,
cp.start_date_2,
cp.end_date_1,
cp.end_date_2,
.. some other fields ..
FROM ...
/entity
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
18 matches
Mail list logo