Uploaded image for project: 'Kafka'
  1. Kafka
  2. KAFKA-10103

JDBC Sink Connector doesn't support numerical values in event keys

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: KafkaConnect
    • Labels:
      None

      Description

      Our topics contain events with numerical keys and Avro values. We're trying to configure a JDBC connector to export data from these topics to Oracle DB, but it doesn't seem to work.

      If we use strings as keys everything works fine, but if we switch to Longs it stops working. We tried different values of key.converter, including org.apache.kafka.connect.converters.ByteArrayConverter, but either parsing of keys doesn't work, or they cannot be mapped to Oracle data type (NUMBER - this happens if we use ByteArrayConverter). 

      We also tried using transformations (CAST), but in that case we're getting Cast transformation does not support casting to/from BYTES

      Please excuse if this is not a bug and there is a way to work with numerical keys, we just couldn't find anything about that in the documentation.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              cjub Jakub
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: