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
