[ https://issues.apache.org/jira/browse/HIVE-21218?focusedWorklogId=398134&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-398134 ]
ASF GitHub Bot logged work on HIVE-21218: ----------------------------------------- Author: ASF GitHub Bot Created on: 05/Mar/20 04:59 Start Date: 05/Mar/20 04:59 Worklog Time Spent: 10m Work Description: cricket007 commented on pull request #933: HIVE-21218: Adding support for Confluent Kafka Avro message format URL: https://github.com/apache/hive/pull/933#discussion_r388077675 ########## File path: kafka-handler/README.md ########## @@ -50,6 +50,9 @@ ALTER TABLE SET TBLPROPERTIES ( "kafka.serde.class" = "org.apache.hadoop.hive.serde2.avro.AvroSerDe"); ``` + +If you use Confluent's Avro serialzier or deserializer with the Confluent Schema Registry, you will need to remove five bytes from beginning of each message. These five bytes represent [a magic byte and a four-byte schema ID from registry.](https://docs.confluent.io/current/schema-registry/serializer-formatter.html#wire-format) Review comment: Typo: serializer Remove five bytes from *the* beginning of each From *the* Registry ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 398134) > KafkaSerDe doesn't support topics created via Confluent Avro serializer > ----------------------------------------------------------------------- > > Key: HIVE-21218 > URL: https://issues.apache.org/jira/browse/HIVE-21218 > Project: Hive > Issue Type: Bug > Components: kafka integration, Serializers/Deserializers > Affects Versions: 3.1.1 > Reporter: Milan Baran > Assignee: David McGinnis > Priority: Major > Labels: pull-request-available > Attachments: HIVE-21218.2.patch, HIVE-21218.3.patch, > HIVE-21218.4.patch, HIVE-21218.5.patch, HIVE-21218.patch > > Time Spent: 12h > Remaining Estimate: 0h > > According to [Google > groups|https://groups.google.com/forum/#!topic/confluent-platform/JYhlXN0u9_A] > the Confluent avro serialzier uses propertiary format for kafka value - > <magic_byte 0x00><4 bytes of schema ID><regular avro bytes for object that > conforms to schema>. > This format does not cause any problem for Confluent kafka deserializer which > respect the format however for hive kafka handler its bit a problem to > correctly deserialize kafka value, because Hive uses custom deserializer from > bytes to objects and ignores kafka consumer ser/deser classes provided via > table property. > It would be nice to support Confluent format with magic byte. > Also it would be great to support Schema registry as well. -- This message was sent by Atlassian Jira (v8.3.4#803005)