I am using a postgres database with a money column that has several different values. But mindsdb (or lightwood) infers it as categorial input.
Video or screenshots
When using the sdk I get the following data:
Expected behavior
I would expect the money column to be inferred as a number column, since in postgres it is also a numeric value and is defenitely not a categorial value.
How to reproduce the error
Use a posgres database
create a table with a money column
add several rows with different values
create a model for it in mindsdb and see that it is inferred as categorial input
Anything else?
I think part of the problem is that postgres formats the money column output.
Thanks for reporting this @Alexnortung . It looks like the issue is in our type_infer library. We will check this. @paxcema Should we transfer this issue to type_infer repo ?
Short description of current behavior
I am using a postgres database with a money column that has several different values. But mindsdb (or lightwood) infers it as categorial input.
Video or screenshots
When using the sdk I get the following data:
Expected behavior
I would expect the money column to be inferred as a number column, since in postgres it is also a numeric value and is defenitely not a categorial value.
How to reproduce the error
Anything else?
I think part of the problem is that postgres formats the money column output.