Exporting CLOB Data from an Oracle Database Using the External Table oracle_datapump into HDFS on a BDA with Copy to Hadoop Does Not Display CLOBS Correctly in Hive. (Doc ID 2236260.1)

Last updated on MARCH 18, 2017

Applies to:

Oracle Big Data SQL - Version 3.1.0 to 3.1.0 [Release 3.1]
Linux x86-64

Symptoms

Exporting CLOB Data from an Oracle Database Using the External Table oracle_datapump into HDFS on a BDA with Copy to Hadoop Does Not Display CLOBS Correctly in Hive.

For example a test as below illustrates the problem:

1. In an Oracle Database:

This works properly with VARCHAR but not with CLOB.

Cause

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