Re: Decimal Mapping problem

2011-12-30 Thread Chris Hostetter
: Try to cast MySQL decimal data type to string, i.e. : : CAST( IF(drt.discount IS NULL,'0',(drt.discount/100)) AS CHAR) as discount : (or CAST AS TEXT) ...to clarify here, the values you are seeing are what happens when the DB returns to DIH a value in a type it doesn't udnerstand -- in this c

Re: Decimal Mapping problem

2011-12-29 Thread Alexey Serba
Try to cast MySQL decimal data type to string, i.e. CAST( IF(drt.discount IS NULL,'0',(drt.discount/100)) AS CHAR) as discount (or CAST AS TEXT) On Mon, Dec 19, 2011 at 1:24 PM, Niels Stevens wrote: > Hey everybody, > > I'm having an issue importing Decimal numbers from my Mysql DB to Solr. > Is

Decimal Mapping problem

2011-12-19 Thread Niels Stevens
Hey everybody, I'm having an issue importing Decimal numbers from my Mysql DB to Solr. Is there anybody with some advise, I will start and try to explain my problem. According to my findings, I think the lack of a explicit mapping of a Decimal value in the schema.xml is causing some issues I'm ex