Created question in FIWARE Q/A platform on 16-06-2016 at 15:06
Please, ANSWER this question AT https://stackoverflow.com/questions/37861188/error-connecting-with-hive-to-a-cosmos-server-of-fiware

Question:
Error connecting with hive, to a cosmos server of fiware

Description:
I can't connect via hive to cosmos server in PHP with:

// Load this lib
require_once _DIR_ . '/php-thrift-sql-master/ThriftSQL.phar';

// Try out a Hive query

$usuario="user@user";
$clave="pass";

$hive = new \ThriftSQL\Hive( 'cosmos.lab.fiware.org', 10000, $usuario, $clave, 1);
$hiveTables = $hive
->setSasl( false ) // To turn SASL auth off, on by default
->connect()
->queryAndFetchAll( 'SHOW TABLES' );
print_r( $hiveTables );

// Don't forget to clear the client and close socket.
$hive->disconnect();

Error produced is Thrift\Exception\TTransportException: TSocket: timed out reading 4 bytes from cosmos.lab.fiware.org:10000 in phar://C:/Users/.../php-thrift-sql-master/ThriftSQL.phar/Thrift/Transport/TSocket.php on line 274

I tried with other servers like storage.cosmos.lab.fiware.org and computing.cosmos.lab.fiware.org. And if I put a long timeout, then the script waits forever.

Can you help me to connect with php to the hive server of cosmos?

Thanks in advance.