Re: KSQL Enrichment issue with converting decimal to string column

2020-09-08 Thread Rainer Schamm
We are unfortunately not in control of the source and destination tables. In the source table the 'quantity' column is numeric. In the destination table 'quantityDest' column is a string. So the question is how can we convert from numeric value to string value using some KSQL syntax or functio

Re: KSQL Enrichment issue with converting decimal to string column

2020-09-08 Thread Robin Moffatt
Why is quantity a STRING? Should it be a numeric? -- Robin Moffatt | Senior Developer Advocate | ro...@confluent.io | @rmoff On Tue, 8 Sep 2020 at 08:52, Rainer Schamm wrote: > Hi all > > we are struggling a bit with a fairly simple stream that is supposed to > map columns from a topic popu

KSQL Enrichment issue with converting decimal to string column

2020-09-08 Thread Rainer Schamm
Hi all we are struggling a bit with a fairly simple stream that is supposed to map columns from a topic populated by a Source Jdbc Connector into a format destined for a Sink Jdbc Connector. Our tables look something like this: (These are not the actual column names we are using though) SOURC