Hive ODBC Connection ETIMEDOUT

I was trying to connect TableAU to Cloudera Hadoop on Windows, every time I got an error saying ETIMEDOUT, no other error message can be found.

To solve this, make sure HiveServer 2 can be selected, and for Authentication Mechanism, choose Username and then type ‘hive‘ in the Username text.

Hive ODBC Connection ETIMEDOUT by @sskaje:

Incoming search terms:

PHP ODBC Connect Cloudera Impala and Hive


CentOS 5.5
PHP 5.3.10
(This article also works for PHP 5.3.3 on CentOS 6).



UnixODBC can be installed from yum repo

I built a unixODBC 2.3.2 from source, installed to /usr/local/unixODBC

ODBC Connectors

Cloudera offers ODBC libs for both Hive and Impala:

Follow the install guide on urls above, only wget and yum –nogpgcheck localinstall xxx.rpm required.
Continue reading “PHP ODBC Connect Cloudera Impala and Hive” »

PHP ODBC Connect Cloudera Impala and Hive by @sskaje:

Incoming search terms:

Build Old PHP-ODBC from Source

CentOS 5.5 + PHP 5.3.10, I’ve built the latest unixODBC 2.3.2 from source to /usr/local/unixODBC.

I need to add php-odbc to my php’s extension list, as what I did, phpize && configure && make, but error occurred:

I tried to add ‘–with-adabas=no‘, but failed.

The solution is, DELETE all configs like

and leave the

block in config.m4.

Then phpize, configure, make.

For pdo_odbc, configure may like

Build Old PHP-ODBC from Source by @sskaje:

Incoming search terms: