I am trying to use the 3rd-party Cloudera JDBC driver to query Impala running on Cloudera CDH 5.4.
I am already able to query Hive using a 3rd party JDBC driver. I followed the instructions here: https://blogs.oracle.com/datawarehousing/entry/oracle_sql_developer_data_modeler. When I set this up, an additional tab appears in the "New/Select Database Connection" window in SQL Developer called "Hive."
For Impala, I have installed the JDBC drivers in SQL Developer. I tried downloading and including the updated version of the JDBC driver as specified by Cloudera here (info about Impala and JDBC in general): Configuring Impala to Work with JDBC and also Download Impala JDBC Connector v2.5.21 . No luck, if I get the most recent version of the JDBC driver, there is no additional tab that appears in the connection option in SQL developer that says "Impala."
Looking at the page above by Cloudera titled "Configuring Impala to Work with JDBC", it seems that Impala should be queryable by the Hive driver. However, when I try this with the existing Hive driver that I was using it does not work either.
Impala would be nice because I could get snappy (1 or 2 second) response times from queries instead of having to wait a minute for each query to return.