I’ve this desk in SQL Server:
CREATE TABLE [dbo].[blast_info](
[blast_id] [int] NOT NULL,
[tnt_amount_kg] [decimal](18, 2) NOT NULL,
[time_blasted] [datetime] NOT NULL,
[hole_deep_ft] [numeric](9, 2) NULL,
[hole_coord_n] [numeric](18, 6) NOT NULL,
[hole_coord_e] [numeric](18, 6) NULL
) ON [PRIMARY]
debezium is configured to run as plugin from confluent. Knowledge is posted into Kafka however once I learn it both through python or console-consumer I see encoded values for numeric and decimal varieties:
{"blast_id":17,"tnt_amount_kg":"eA==","time_blasted":1585803600000,"hole_deep_ft":"AOY=","hole_coord_n":"A/OOVvYA","hole_coord_e":"AKSQkBwA","__ts_ms":1586140437125}
{"blast_id":16,"tnt_amount_kg":"ANw=","time_blasted":1583125200000,"hole_deep_ft":"Aa4=","hole_coord_n":"A/OOVvYA","hole_coord_e":"AKSQkBwA","__ts_ms":1586140437125}
{"blast_id":17,"tnt_amount_kg":"eA==","time_blasted":1585803600000,"hole_deep_ft":"AOY=","hole_coord_n":"A/OOVvYA","hole_coord_e":"AKSQkBwA","__ts_ms":1586140437126}
Processed a complete of 38 messages
Why is that this and what’s can be the repair? Thanks.