Good evening everyone.
I'm trying to migrate some tables from RDS MySQL to OpenSearch through DMS. However, I have a problem with decimal columns. When configuring the task and sending it to OpenSearch, the DMS is treating it as a Float. But Float doesn't have the precision I need (decimal(10,2)) and it distorts the data. OpenSearch supports both double and scaled_float, but if in my index I map the column with these types I get DMS error like:
"cannot be changed from type [scaled_float] to [float]"
From the documentation it seems that DMS only supports int and float for numbers. (https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.Elasticsearch.html)
I would like to know if there is any alternative to this.