Kafka Connect Number type fields -
when use kafka connect source rdbms oracle , number type fields seen bytes below,
column "id" value "4" number has been sent ,but @ consumer console value has been seen "id":"ba=="
what can in order solve issue ?
kafka connect started below command
connect-standalone ./etc/kafka/connect-standalone.properties /home/kafka/oracle.properties.test ######## connect-standalone.properties # these defaults. file demonstrates how override settings. bootstrap.servers=kafkaserver01.localdomain:9092 # converters specify format of data in kafka , how translate connect data. every connect user # need configure these based on format want data in when loaded or stored kafka key.converter=org.apache.kafka.connect.json.jsonconverter value.converter=org.apache.kafka.connect.json.jsonconverter # converter-specific settings can passed in prefixing converter's setting converter want apply # key.converter.schemas.enable=true value.converter.schemas.enable=true # internal converter used offsets , config data configurable , must specified, users # want use built-in default. offset , config data never visible outside of kafka connect in format. internal.key.converter=org.apache.kafka.connect.json.jsonconverter internal.value.converter=org.apache.kafka.connect.json.jsonconverter internal.key.converter.schemas.enable=false internal.value.converter.schemas.enable=false offset.storage.file.filename=/tmp/connect.offsets # flush faster normal, useful testing/debugging offset.flush.interval.ms=10000 ######## /home/kafka/oracle.properties.test configuration file name=oracle-connect-test1 connector.class=io.confluent.connect.jdbc.jdbcsourceconnector tasks.max=1 topic.prefix= connection.url=jdbc:oracle:thin:test/oracle@testsrv01:1521:testdb table.whitelist=test1,test2 mode=timestamp timestamp.column.name=cdc_timestamp ## console consumer kafka-console-consumer --bootstrap-server kafkaserver01.localdomain:9092 --topic test1
thanks.
Comments
Post a Comment