My Oracle Support Banner

OGG For PostgreSQL To OGG Big Data: Unexpected Boolean Data Type Values Received (Doc ID 2843929.1)

Last updated on APRIL 17, 2023

Applies to:

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


Extracts and replicates to Big Data targets from several RDBMS database types including Oracle, MySQL and PostgreSQL.
We are now seeing problems in which the values replicated for PostgreSQL Boolean types are showing up in the target Hadoop File system in "binary" form.

Also note that when an initial data load is perform using loader program, the Boolean values come across as True and False.
Furthermore I believe these Boolean values are stored in the source database as 0 and 1 (False and True) respectively.

How can we GoldenGate to land the Boolean values on the target Hadoop system as either...
1) 0 and 1
2) False and True


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.