After Successfully Installing BDS on Oracle Exadata from DOC ID 2006798.1 Create Table Fails with ORA-29913, ORA-29400, KUP-11504

(Doc ID 2008918.1)

Last updated on APRIL 01, 2017

Applies to:

Oracle Big Data SQL - Version 1.1 and later
Linux x86-64

Symptoms

After sucessfully following: How to Enable Big Data SQL 1.1 on Oracle Exadata 12.1.0.2  (Doc ID 2006798.1) and implementing the workaround in the Known Issues Section i.e. to run: alter system set "_bigdata_external_table"=true;
running "Create Table" fails with an error like:

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11504: error from external driver: MetaException(message:hive table default.table_buffer does not exist)



For example:

SQL> CREATE TABLE <table> (x,    VARCHAR2(20),
 2                                          y,    VARCHAR2(20)
 3     ) ORGANIZATION EXTERNAL
 4      ( TYPE ORACLE_HIVE
 5        DEFAULT DIRECTORY "DEFAULT_DIR"
 6       ACCESS PARAMETERS
 7         (
 8         com.oracle.bigdata.tablename=default.table_buffer
 9         )
 10      )
 11  /

Table created.

 

 

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