Phoenix Integration with OBIEE 11g

User_DLSC0

Hi All,

We are trying to integrate apache phoenix into OBIEE so that I have installed hortonworks ODBC RPM and created data source connection entry in odbc.ini as following

and set the LIB path,

https://hortonworks.com/downloads/

[Phoenix]

Driver=/opt/hortonworks/phoenixodbc/lib/64/libphoenixodbc_sb64.so

HOST=XXXXX

PORT=8765

DriverUnicodeType=1

LogonID=xxxxxxxx

Password=xxxxxxxx

in RPD, I created physical folder "Apache Hadoop" and connection pool "ODBC 3.5".

And When I run direct database against Phoenix giving following error, Kindly assist what are the changes required at the server side as well as in RPD??

Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 16015] SQL statement execution failed. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "Phoenix" select count(*)  from "TABLE NAME')}

Regards,

Avinash

Thomas Dodds

You might be missing a step ...

https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-2-connecting-obiee-11-1-1-7-to-hadoop-data-sources/