Big Data Adapter We Cannot Change The Format To The AVRO According To Oracle Official Documents (Doc ID 2157568.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 12.1.2.1.6 and later
Information in this document applies to any platform.

Goal

 We are using Big Data Adapters:

***********************************************************************
Oracle GoldenGate Delivery
Version 12.2.0.1.160419 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160430.1401
Linux, x64, 64bit (optimized), Generic on Apr 30 2016 18:07:13

Oracle GoldenGate Java Adapter, 12.2.0.1.1.011
Copyright (c) 2007, 2016. Oracle and/or its affiliates. All rights reserved
Built with Java 1.7.0_45 (class version: 51.0)

With:
1) HDFS handler AVRO_OP format
2) HDFS handler AVRO_ROW format
3) Kafka Handler AVRO_OP format
4) Kafka Handler AVRO_ROW format

Each props has the appropriate handler format:

gg.handler.hdfs.format=avro_op
gg.handler.hdfs.format=avro_row
gg.handler.kafkahandler.format=avro_op
gg.handler.kafkahandler.format=avro_row

But the output is in text rather than the expected:

2BDTEST.TBL_TRANSDATA_HDFSI42016-06-15 17:57:52.05458142016-06-15T17:58:00.621000(00000000010001968633IDWHENWHATDESCRIPTION 121 &2016-06-15 17:57:52 4351425 vDescription for record 121 generated on 2016-06-15 17:57:52

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms