My Oracle Support Banner

Unable To Publish External Hive Tables Created With "Copy To BDA" with Oracle Big Data Discovery (BDD) (Doc ID 2119942.1)

Last updated on DECEMBER 27, 2019

Applies to:

Oracle Big Data SQL - Version 2.0 and later
Oracle Big Data Discovery - Version and later
Linux x86-64


The problem here is that it is not possible to publish external Hive tables created with "Copy To BDA" with Oracle Big Data Discovery (BDD).

This is the scenario leading to the failure:

1. The instructions in Section 4 of Oracle Big Data SQL User's Guide, Copying Oracle Tables to Hadoop, including the step below were followed:

6. However it is possible to:

a) use the dataprocessing_CLI to expose tables created from CSV files imported by HUE into HDFS and then use them to load tables.
b) query the table from "Copy to BDA" within HUE.



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.