Last updated on MARCH 24, 2016
Applies to:Oracle Big Data SQL - Version 2.0 and later
Oracle Big Data Discovery - Version 220.127.116.11.0 and later
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