My Oracle Support Banner

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 DECEMBER 04, 2019

Applies to:

Oracle Big Data SQL - Version 1.1 and later
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.

  

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

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.