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

(Doc ID 2119942.1)

Last updated on MARCH 24, 2016

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.



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