Mixing
Can ClickHouse Kafka Engine consume compressed JSON messages?
Can ClickHouse Kafka Engine consume compressed JSON messages from a Kafka topic, using JSONEachRow format?
Will it automatically decompress messages and then apply the JSON parsing?
Does it need any special configuration for it?
EDIT My question is directed to whether compressing topics via set compression configuration on the Kafka topic would make ClickHouse not able to read these messages.
json apache-kafka clickhouse
asked Nov 22 '18 at 12:53
xmarxmar
475213
add a comment |
Can ClickHouse Kafka Engine consume compressed JSON messages from a Kafka topic, using JSONEachRow format?
Will it automatically decompress messages and then apply the JSON parsing?
Does it need any special configuration for it?
EDIT My question is directed to whether compressing topics via set compression configuration on the Kafka topic would make ClickHouse not able to read these messages.
json apache-kafka clickhouse
asked Nov 22 '18 at 12:53
xmarxmar
475213
add a comment |
Can ClickHouse Kafka Engine consume compressed JSON messages from a Kafka topic, using JSONEachRow format?
Will it automatically decompress messages and then apply the JSON parsing?
Does it need any special configuration for it?
EDIT My question is directed to whether compressing topics via set compression configuration on the Kafka topic would make ClickHouse not able to read these messages.
json apache-kafka clickhouse
asked Nov 22 '18 at 12:53
xmarxmar
475213
Can ClickHouse Kafka Engine consume compressed JSON messages from a Kafka topic, using JSONEachRow format?
Will it automatically decompress messages and then apply the JSON parsing?
Does it need any special configuration for it?
EDIT My question is directed to whether compressing topics via set compression configuration on the Kafka topic would make ClickHouse not able to read these messages.
json apache-kafka clickhouse
json apache-kafka clickhouse
asked Nov 22 '18 at 12:53
xmarxmar
475213
asked Nov 22 '18 at 12:53
xmarxmar
475213
edited Jan 21 at 18:37
xmar
asked Nov 22 '18 at 12:53
xmarxmar
475213
asked Nov 22 '18 at 12:53
xmarxmar
475213
asked Nov 22 '18 at 12:53
xmarxmar
475213
475213
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Kafka Engine consumes messages as they are - no more, no less. It's almost the same as reading from native files, with the exception that message boundaries might need special treatments. ClickHouse doesn't support reading compressed data files other than native serialized blocks. So the answer is no, it cannot consume compressed JSON messages.
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
add a comment |
Yes, as long as the ClickHouse client is able to understand Kafka topic compression. For example, earlier versions won't be able to understand ZStandard compression, but they would understand e.g. snappy.
Whether it's JSON or something else, that's up to the parsing method specified. If these messages are themselves compressed (redundant though) then they will not be parsed correctly, as @Amos says.
answered Jan 21 at 18:39
xmarxmar
475213
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431503%2fcan-clickhouse-kafka-engine-consume-compressed-json-messages%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Kafka Engine consumes messages as they are - no more, no less. It's almost the same as reading from native files, with the exception that message boundaries might need special treatments. ClickHouse doesn't support reading compressed data files other than native serialized blocks. So the answer is no, it cannot consume compressed JSON messages.
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
add a comment |
Kafka Engine consumes messages as they are - no more, no less. It's almost the same as reading from native files, with the exception that message boundaries might need special treatments. ClickHouse doesn't support reading compressed data files other than native serialized blocks. So the answer is no, it cannot consume compressed JSON messages.
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
add a comment |
Kafka Engine consumes messages as they are - no more, no less. It's almost the same as reading from native files, with the exception that message boundaries might need special treatments. ClickHouse doesn't support reading compressed data files other than native serialized blocks. So the answer is no, it cannot consume compressed JSON messages.
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
Kafka Engine consumes messages as they are - no more, no less. It's almost the same as reading from native files, with the exception that message boundaries might need special treatments. ClickHouse doesn't support reading compressed data files other than native serialized blocks. So the answer is no, it cannot consume compressed JSON messages.
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
edited Dec 8 '18 at 16:54
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
answered Nov 23 '18 at 13:49
AmosAmos
1,69031029
1,69031029
add a comment |
add a comment |
Yes, as long as the ClickHouse client is able to understand Kafka topic compression. For example, earlier versions won't be able to understand ZStandard compression, but they would understand e.g. snappy.
Whether it's JSON or something else, that's up to the parsing method specified. If these messages are themselves compressed (redundant though) then they will not be parsed correctly, as @Amos says.
answered Jan 21 at 18:39
xmarxmar
475213
add a comment |
Yes, as long as the ClickHouse client is able to understand Kafka topic compression. For example, earlier versions won't be able to understand ZStandard compression, but they would understand e.g. snappy.
Whether it's JSON or something else, that's up to the parsing method specified. If these messages are themselves compressed (redundant though) then they will not be parsed correctly, as @Amos says.
answered Jan 21 at 18:39
xmarxmar
475213
add a comment |
Yes, as long as the ClickHouse client is able to understand Kafka topic compression. For example, earlier versions won't be able to understand ZStandard compression, but they would understand e.g. snappy.
Whether it's JSON or something else, that's up to the parsing method specified. If these messages are themselves compressed (redundant though) then they will not be parsed correctly, as @Amos says.
answered Jan 21 at 18:39
xmarxmar
475213
Yes, as long as the ClickHouse client is able to understand Kafka topic compression. For example, earlier versions won't be able to understand ZStandard compression, but they would understand e.g. snappy.
Whether it's JSON or something else, that's up to the parsing method specified. If these messages are themselves compressed (redundant though) then they will not be parsed correctly, as @Amos says.
answered Jan 21 at 18:39
xmarxmar
475213
answered Jan 21 at 18:39
xmarxmar
475213
answered Jan 21 at 18:39
xmarxmar
475213
answered Jan 21 at 18:39
xmarxmar
475213
475213
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431503%2fcan-clickhouse-kafka-engine-consume-compressed-json-messages%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
