[
https://issues.apache.org/jira/browse/HIVE-21218?focusedWorklogId=397993&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-397993
]
ASF GitHub Bot logged work on HIVE-21218:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 04/Mar/20 23:45
Start Date: 04/Mar/20 23:45
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_r388001426
##########
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 Avro serialzier/deserializer with Schema Registry you may
want to remove 5 bytes from beginning that represents magic byte + schema ID
from registry.
+It can be done by setting `"avro.serde.type"="confluent"` or
`"avro.serde.type"="skip"` with `"avro.serde.skip.bytes"="5"`. It's recommended
to set an avro schema via
`"avro.schema.url"="http://hostname/SimpleDocument.avsc"` or
`"avro.schema.literal"="{"type" : "record","name" : "SimpleRecord","..."}`. If
both properties are set then `avro.schema.literal` has higher priority.
Review comment:
It is still recommended to set the literal if using `confluent`?
Link https://github.com/confluentinc/schema-registry/pull/686
----------------------------------------------------------------
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: 397993)
Time Spent: 11h (was: 10h 50m)
> 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: 11h
> 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)
