Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

@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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.