通过PHP中的Hive / Thrift查询数据库不起作用 [英] Querying database through Hive/Thrift in PHP does not work

问题描述

我试图通过PHP中的Hive / Thrift查询数据库。然而，我经常会遇到一个错误：

  TSocket：超时读取XYZ中的4个字节
  
 
我使用 
 
 
  https://cwiki.apache.org/Hive/hiveclient.html#HiveClient-PHP  
 
 
 
以及此PHP Thrift客户端
 
 
 
  https://github.com/garamon/php-thrift-hive-client  
 
 
 
我的代码：
 
 
 <？php 
 
 $ socket = new TSocket（'XYZ'，12345）; 
 
 $ socket-> setSendTimeout（30 * 1000）; 
 $ socket-> setRecvTimeout（30 * 1000）; 
 
 $ transport = new TBufferedTransport（$ socket，1024，1024）; 
 $ protocol = new TBinaryProtocol（$ transport）; 
 
 $ client = new ThriftHiveClientEx（$ protocol）; 
 
 $ transport-> open（）; 
 
 $ client->执行（我的查询）; 
 
？> 
  
注意 - 我可以通过控制台（telnet命令）与XYZ连接。
 
 
 
我会提供任何帮助。感谢。
解决方案
在使用完全相同的资源时，我遇到了类似的问题。事实证明，代码没有意识到它是否超时或是否阻塞端口。我发现这篇文章对我有帮助： 
 
 
  https://issues.apache.org/jira/browse/THRIFT-347  
 
 
 
在TSocket.php代码中（garamon_base_dir / lib / transport ）你必须编辑大约223到236行。
 
 
 
它说： 
 
 
  if（$ buf === FALSE || $ buf ===''）{... 
和
 if（$ md ['timed_out']）{... $ （$ md [timed_out']）{... 
  
 
 
 < （$ buf === FALSE）{... 
和
 
 $ b $ p $ 
 if（true === $ md ['timed_out']&& false === $ md ['blocked']）
 and finally 
 if（true === $ md ['timed_out']&& false === $ md ['blocked']）
  

然后它在修复之后开始工作。祝你好运！

I'm trying to query a database through Hive/Thrift in PHP. However, I am constantly getting an error:

TSocket: timed out reading 4 bytes from XYZ

I'm using a code from

https://cwiki.apache.org/Hive/hiveclient.html#HiveClient-PHP

along with this PHP Thrift Client

https://github.com/garamon/php-thrift-hive-client

My code:

<?php

$socket    = new TSocket( 'XYZ', 12345 );

$socket->setSendTimeout(30 * 1000);
$socket->setRecvTimeout(30 * 1000);

$transport = new TBufferedTransport( $socket, 1024, 1024 );
$protocol  = new TBinaryProtocol( $transport );

$client    = new ThriftHiveClientEx( $protocol );

$transport->open();

$client->execute("my query");

?>

Note - I am able to connect with XYZ through console (telnet command).

I would appriciate any help. Thanks.

解决方案

I had a similar problem when starting with those exact same resources. It turns out the code is not recognizing whether it has timed out or whether it is blocking the port. I found this article which helped me:

https://issues.apache.org/jira/browse/THRIFT-347

In your TSocket.php code ( garamon_base_dir/lib/transport ) you have to edit approximately lines 223 through 236.

Where it says:

if( $buf === FALSE || $buf === '' ) { ...
and
if( $md['timed_out'] ) { ...
and then again
if( $md[timed_out'] ) { ...

change to (respectively):

if( $buf === FALSE ) { ...
and
if( true === $md['timed_out'] && false === $md['blocked'] )
and finally 
if( true === $md['timed_out'] && false === $md['blocked'] )

Then it started working after this fix. Good luck!

这篇关于通过PHP中的Hive / Thrift查询数据库不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！