Hadoop相关 Hive Impala PHP 学习研究

PHP ODBC Connect Cloudera Impala and Hive

By @sskaje


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.

PHP ODBC Connect Cloudera Impala and Hive by @sskaje:

Incoming search terms:

PHP 学习研究

Build Old PHP-ODBC from Source

By @sskaje

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: