Support Questions
Find answers, ask questions, and share your expertise

Unable to add Phoenix query server as a source to Tableau using Hortonworks ODBC driver

Unable to add Phoenix query server as a source to Tableau using Hortonworks ODBC driver

Explorer

Followed this doc, to install ODBC driver and installed and PQS (by adding phoenix query server as component to one of host).

checked the connectivity using telnet and it is able to connect to PQS.

While I try to add the source in Tableau Desktop I see connection errors. I have attached my odbc.ini file and screenshot of the error.

odbc.ini

```[Driver] ErrorMessagesPath=/Library/hortonworks/phoenixodbc/ErrorMessages LogLevel=0 LogPath=[LogPath] SwapFilePath=/tmp [ODBC Drivers] Hortonworks Phoenix ODBC Driver=Installed [Hortonworks Phoenix ODBC Driver] Description=Hortonworks Phoenix ODBC Driver Driver=/Library/hortonworks/phoenixodbc/lib/libphoenixodbc_sbu.dylib HOST=10.74.8.58 PORT=8765```

92713-phoenix.jpg

Thanks in advance.

1 REPLY 1

Re: Unable to add Phoenix query server as a source to Tableau using Hortonworks ODBC driver

@prarthana basgod Can you check the PQS logs if there are any exceptions?

Usually hadoop proxy will block the external connections unless this host is not configured. Do check hadoop.proxyuser.HTTP.hosts property core-site.xml and configure it accordingly.