: 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
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
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