php串連hive執行sql查詢

使用php串連hive的條件

1  需要安裝thrift  安裝步驟

#  ./configure --without-ruby 

#   make && make install

如果沒有安裝libevent libevent-devel的應該先安裝這兩個依賴庫yum -y install libevent libevent-devel

安裝好後啟動hive thrift

# ./hive --service hiveserver >/dev/null 2>/dev/null &

查看hiveserver預設連接埠是否開啟10000   如果開啟表示成功

 

註：php版本要求是5.2或者以上

php串連hive代碼

<?</p><p>// php串連hive thrift依賴包路徑<br /> $GLOBALS['THRIFT_ROOT'] = '/var/www/html/hivephp/thrift/';<br />// load the required files for connecting to Hive<br />require_once $GLOBALS['THRIFT_ROOT'] . 'packages/hive_service/ThriftHive.php';<br />require_once $GLOBALS['THRIFT_ROOT'] . 'transport/TSocket.php';<br />require_once $GLOBALS['THRIFT_ROOT'] . 'protocol/TBinaryProtocol.php';<br />// Set up the transport/protocol/client<br />$transport = new TSocket('localhost', 10000);<br />$protocol = new TBinaryProtocol($transport);<br />$client = new ThriftHiveClient($protocol);<br />$transport->open();</p><p>// run queries, metadata calls etc</p><p>$client->execute('add jar /usr/local/hadoop/hive/lib/hive-contrib-0.7.0-cdh3u0.jar');<br />$client->execute('select count(1) from apilog');<br />var_dump($client->fetchAll());<br />$transport->close();</p><p>?>

 

將以上代碼存為test.php到apache的www路徑/var/www/html/中  php串連hive的依賴包放到/var/www/html/hivephp/thrift/

php串連hive的lib包 http://download.csdn.net/source/3409880

開啟瀏覽器瀏覽http://localhost/test.php就可以看到查詢結果了