How to remove schema part from the payload

[sau...@lifeincontrol.com]

Is there anyway I can get only payload part in json message ?

[Jiri Pechanec]

Hi,

please try setting value.converter.schemas.enable=false for the Connect configuration. It will then just provide plain JSON without schema.

J.

[John T]

I'm using the Debezium Connector for SQL Server with docker-compose, any idea how I change the connect configuration?

[Gunnar Morling]

If you're using Debezium's Docker image for Kafka connect, you can add this to your environment variables of the "connect" service in Compose:

    CONNECT_VALUE_CONVERTER_SCHEMAS_ENABLE=false

Hth,

--Gunnar

[John T]

Thanks for the quick answer, it worked.

[Alexandru Lazarev]

Hi All, 

Still cannot get rid of schema...

I followed tutorial on debezium.io and tried delete connector and recreate it with schema disabled:

curl -s -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d '{

"name": "inventory-connector",

"config": {

"connector.class": "io.debezium.connector.mysql.MySqlConnector",

"tasks.max": "1",

"key.convertor": "org.apache.kafka.connect.json.JsonConverter",

"key.converter.schemas.enable": "false",

"value.convertor": "org.apache.kafka.connect.json.JsonConverter",

"value.converter.schemas.enable": "false",

"database.hostname": "mysql",

"database.port": "3306",

"database.user": "debezium",

"database.password": "dbz",

"database.server.id": "184054",

"database.server.name": "dbserver1",

"database.include.list": "inventory",

"database.history.kafka.bootstrap.servers": "kafka:9092",

"database.history.kafka.topic": "dbhistory.inventory"

}

}'

but no effect at all!
Tried both with and without "key.convertor"/"value.convertor".

Only when starting docker image with "CONNECT_VALUE_CONVERTER_SCHEMAS_ENABLE=false"/"CONNECT_KEY_CONVERTER_SCHEMAS_ENABLE=false" schema is omitted.

QUESTION: Why so? What is the difference? 
Why I cannot disable schema from connector config itself?

Thx, I am a newbie here

[Gunnar Morling]

You got a typo there: convert*o*r instead of convert*e*r. It's then using the default converters from the KC level and your schema.enabled properties don't apply.

--Gunnar

[Alexandru Lazarev]

Thanks! Indeed

Virus-free. www.avast.com

--
You received this message because you are subscribed to a topic in the Google Groups "debezium" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/debezium/WBSZSoJ4734/unsubscribe.
To unsubscribe from this group and all its topics, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/0e943a6c-2a56-4862-8617-76cf0fa55fedn%40googlegroups.com.

Virus-free. www.avast.com

[林晓东]

I am running in debezium server mode,  there is a conf/application.properties ,and how to set the 

• value/key.converter.schemas.enable ?

I have done like this:

debezium.format.value.converter.schemas.enable=false

or 

debezium.sink.http.key.converter.schemas.enable=false

all has no effect.

[Chris Cranford]

Hi,

If the "debezium.format.[key|value].converter.schemas.enable" then this sounds like a bug, could you raise a Jira issue?
Could you also try "debezium.source.[key|value].converter.schemas.enable" to see if that works by chance?

Thanks
Chris

You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/3efda8c9-e140-4b73-8ff7-6a2831c612e5n%40googlegroups.com.

[Nathan Smit]

This is how I remove schemas in my Debezium Server deployment.  Looks a little different to what you have there:

debezium.source.value.converter=org.apache.kafka.connect.json.JsonConverter
debezium.source.value.converter.schemas.enable=false

[Chris Cranford]

Sorry Nathan, I probably should have clarified my usage of [key|value] was meant more in the pick one, this part is a choice fragment :)

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/a991114e-68c8-4870-a5bc-d310edde2f66n%40googlegroups.com.