type_infer icon indicating copy to clipboard operation
type_infer copied to clipboard

[Bug]: Postgres money type is inferred as categorial input

Open Alexnortung opened this issue 5 months ago • 1 comments

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:

billede

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.

Alexnortung avatar Mar 20 '24 14:03 Alexnortung