Connecting Oracle BI to HIVE

3359624

Hello All.

I have installed Oracle BI into ubuntu in VirtualBox.

I'm trying to connect BI to Hive via web interface and get this error on dialog :

This is log file:

http://image.prntscr.com/image/d0ae06bac9474671a379011551280a2e.png

[rid: 0:2:23] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <TIMEOUT_ERROR Request timed out: Request Headers

X-BI-SERVICE-INSTANCE-KEY=ssi

User-Agent=DSS/v1

Accept-Language=en-US,en;q=0.5

OBIEE_SERVICE_NAME=DatasourceService

OBIEE_BYPASS_ADF_PROTOCOL=true

OBIEE_CONN_POOL_TIMEOUT=300000

OBIPARAM_ImpersonatedUser=weblogic

BISuperUserName=tzmv4us7do8ji2xcenylwhafg3qbkrp5

OBIARG_datasourceName=JDBC

OBIARG_targetConn=JDBC (BIJDBC)

OBIPARAM_DriverClass=oracle.bi.jdbc.AnaJdbcDriver

OBIPARAM_TargetType=Hadoop

OBIPARAM_ConnectionString=jdbc:oraclebi://oracle-VirtualBox:9508/PrimaryCCS=oracle-VirtualBox;PrimaryCCSPort=9508;SSL=false;NQ_SESSION.SERVICEINSTANCEKEY=ssi;

OBIPARAM_UserName=tzmv4us7do8ji2xcenylwhafg3qbkrp5

OBIPARAM_Password=XXXXX

OBIPARAM_ConnectionID='weblogic'.'HiveDs'

OBIEE_METHOD_NAME=getObjectsList

OBIPARAM_SchemaClearCache=true

Host=oracle-VirtualBox:9502

Accept=text/html, image/gif, image/jpeg, */*; q=.2

Connection=Keep-Alive

ECID-Context=1.cd5c7bc2-c8c5-4214-bea9-f403ebd8eaec-000002dd;kYinv0YDJPHBBLPUn3VSdGXIVVNLCKIHVKHM5VML5JGLFINN1ODDs9DEn4DDt2C

Cause - The request did not complete within the allotted time.

Action - Check the log for details and increase the connection pool timeout or fix the root cause.

oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:454)

javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

>

Seems bi trying to reach something on 9508 port, what shall be there?

I do can ping machine where Hive is installed and it's running okay.

Maybe i still need to install something more?

Update :
On 9508: Cluster Controller i suppose it should be running.

Update 2:
So on 9508 OBICCS is supposed to be, and i see on last part of startup script output that it is started.

From admin console ( Environment-> Clusters) i saw that my bi_cluster doesn't have anything in 'cluster address' column, what value should be there?

Added complete log to attachments

And in general: am i correct supposing that i need cluster to connect BI to HIVE?