biee12c连接hive_BIEE 12C 连接 HIVE Spark 做数据源

尝试了好多次终于BIEE连通了HIVE和Spark

HIVE &Spark 配置:

1、在客户机AdminTool配置好Hive ODBC(Oracle DataDirect)；

2、AdminTool导入的时候会发生异常，HIVE我这里是通过手动添加表和字段的，Spark没问题；

3、上传RPD；

4、修改linux配置，主要是两个地方，一个是obis.properties，另一个是odbc.ini配置

在/user_projects/domains/bi/config/fmwconfig/bienv目录下

obis.properties配置：LD_LIBRARY_PATH=/usr/lib64,

$ORACLE_HOME/bi/common/ODBC/Merant/8.0.1/lib,

$ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib,

$ORACLE_HOME/bi/bifoundation/server/bin,

$ORACLE_HOME/bi/bifoundation/web/bin,

$ORACLE_HOME/bi/clients/Essbase/EssbaseRTC/bin,

$ORACLE_HOME/bi/common/ODBC,

$ORACLE_INSTANCE,

$ORACLE_HOME/lib

HADOOP_DLL=$ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib/ARhive27.so

odbc.ini 配置

[Spark]Driver=$ORACLE_HOME/bi/common/ODBC/Merant/8.0.1/lib/ARspark28.so

Description=Oracle 8.0 Apache Spark Wire Protocol

ArraySize=16384

Database=YourDB

DefaultLongDataBuffLen=1024

EnableDescribeParam=0

HostName=YourIPAddress

LoginTimeout=30

MaxVarcharSize=2000

PortNumber=YourPort

RemoveColumnQualifiers=0

StringDescribeType=12

TransactionMode=0

UseCurrentSchema=0

[Hive]Driver=$ORACLE_HOME/bi/common/ODBC/Merant/7.1.5/lib/ARhive27.so

Description=Oracle 7.1 Apache Hive Wire Protocol

ArraySize=16384

Database=default

DefaultLongDataBuffLen=1024

EnableDescribeParam=0

HostName=YourIPAddress

LoginTimeout=30

MaxVarcharSize=2000

PortNumber=YourPort

RemoveColumnQualifiers=0

StringDescribeType=12

TransactionMode=0

完成后需要重启OBIS