ODBC Connector - Hive vs Impala

Stu459 — Fri, 16 Sep 2022 13:49:51 GMT

Hi all.

Was looking to connect a BI Application to our cluster and noticed that there are both Hive and Impala ODBC connectors available.

I was trying to understand the difference, it may potentially be a typo in the Hive description as it states:

"passing the SQL queries to the underlying Impala engine."

Should this say Hive? If so then I obviously understand the difference 🙂

If not, what is the difference between the connectors and how would I decide which will work best for me?

Re: ODBC Connector - Hive vs Impala

EricL — Thu, 25 Oct 2018 11:05:15 GMT

Hi,

Thanks for reporting the typo, I believe that you are right, it should be Hive engine as it is Hive ODBC driver. I will repot this internally and get it updated.

The difference basically one connects to HiveServer2 and the other connects to Impala :).

question Re: ODBC Connector - Hive vs Impala in Archives of Support Questions (Read Only)

ODBC Connector - Hive vs Impala

Re: ODBC Connector - Hive vs Impala