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代码
- <?
- // php连接hive thrift依赖包路径
- $GLOBALS['THRIFT_ROOT'] = '/var/www/html/hivephp/thrift/';
- // load the required files for connecting to Hive
- require_once $GLOBALS['THRIFT_ROOT'] . 'packages/hive_service/ThriftHive.php';
- require_once $GLOBALS['THRIFT_ROOT'] . 'transport/TSocket.php';
- require_once $GLOBALS['THRIFT_ROOT'] . 'protocol/TBinaryProtocol.php';
- // Set up the transport/protocol/client
- $transport = new TSocket('localhost', 10000);
- $protocol = new TBinaryProtocol($transport);
- $client = new ThriftHiveClient($protocol);
- $transport->open();
- // run queries, metadata calls etc
- $client->execute('add jar /usr/local/Hadoop/hive/lib/hive-contrib-0.7.0-cdh3u0.jar');
- $client->execute('select count(1) from apilog');
- var_dump($client->fetchAll());
- $transport->close();
- ?>
将以上代码存为test.php到apache的www路径/var/www/html/中 php连接hive的依赖包放到/var/www/html/hivephp/thrift/
php连接hive thrift server的lib包，经测试用hive压缩包中自带的php lib无法测试成功 ,php连接hive的lib包下载地址
下载地址在安科网的1号FTP服务器里，下载地址：
密码：www.muu.cc
下载方法见这里 http://www.linuxidc.net/thread-1187-1-1.html
打开浏览器浏览http://localhost/test.php就可以看到查询结果了
相关推荐
zlsdmx 2020-07-05
tugangkai 2020-07-04
archive 2020-07-30
成长之路 2020-07-28
eternityzzy 2020-07-19
taisenki 2020-07-05
tugangkai 2020-07-05
SignalDu 2020-07-05
tomson 2020-07-05
tomson 2020-07-05
Zhangdragonfly 2020-06-28
genshengxiao 2020-06-26
成长之路 2020-06-26
tomson 2020-06-26
蜗牛之窝 2020-06-26
成长之路 2020-06-25