I have tried to reconfigure BDS for new DB installed .
Bds version : 3.1
Oracle db : 184.108.40.206
Cloudera (Kerberose enabled )and Oracle server are in different unix box .
I have successfully installed the database side bundle generated .Generated Keytab for oracle user and placed it in DB nodes too ..
Im able to access the hadoop machine from the machine in which the oracle server is installed \
with hadoop fs -ls /user and able to put files to hdfs too .
Table creation happens but im unable to retrieve the same .
Im unable to find DBMS_HADOOP package as sys user .
Please help if there are any patches to be installed .
CREATE TABLE stg_custodial_accounts_try1 (.....................................)ORGANIZATION EXTERNAL (TYPE oracle_hive DEFAULT DIRECTORY "ORA_BIGDATA_CL_cluster"
ACCESS PARAMETERS 12 (com.oracle.bigdata.tablename: dbname1.stg_custodial_accounts));
SQL> SQL> select * from stg_custodial_accounts_try1
select * from stg_custodial_accounts_try1
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-06550: line 1, column 68:
PLS-00201: identifier 'DBMS_HADOOP.GET_USER_MAP' must be declared
ORA-06550: line 1, column 53:
PL/SQL: Statement ignored