My Oracle Support Banner

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 JANUARY 22, 2020

Applies to:

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

Symptoms

NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner. 

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

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
Symptoms
Cause
Solution
References


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