Not able to import hive tables to OBIEE 11.1.1.9.0 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Not able to import hive tables to OBIEE 11.1.1.9.0

Received Response
1
Views
1
Comments
Jack
Jack Rank 4 - Community Specialist

Hi

i have configured Hive drivers and added hadop apache at connection pool. But when i am trying import tables from hive to obiee rpd, have issue as database doesnot contain any CRM tables. If i uncheck and ask for import it is brining out empty database schema without any tables.

can anyone please suggest as how can i import tables from hive to obiee rpd

thanks in advance

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    You can import from obiee 11.1.1.7.1 (in this version so supported) , there is a OTN article that talk about it Business Analytics: Big Data Meets Business Intelligence , and after it do a an upgrade to 11.1.9.1, it works for me ( I wrote a post . - sorry this is in spanish, this is entirely for geek purpose).

    The bad news, nevertheless, what I did IT IS NOT what Oracle recommends and you probably get some problems in your test or production environment. I was looking for a document in oracle support about it, but no luck (don't know if someone cope with this and share the experience..).

    Nobody wants that you boss kills you, so...