[Backlogmanager] [FIWARE-JIRA] (HELP-8809) [fiware-stackoverflow] Error connecting with hive, to a cosmos server of fiware

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-8809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez updated HELP-8809:
---------------------------------
     HD-Chapter: Data
    Description: 
Created question in FIWARE Q/A platform on 16-06-2016 at 15:06
{color: red}Please, ANSWER this question AT{color} 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 at 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.


  was:

Created question in FIWARE Q/A platform on 16-06-2016 at 15:06
{color: red}Please, ANSWER this question AT{color} 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 at 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.


     HD-Enabler: Cosmos

> [fiware-stackoverflow] Error connecting with hive, to a cosmos server of fiware
> -------------------------------------------------------------------------------
>
>                 Key: HELP-8809
>                 URL: https://jira.fiware.org/browse/HELP-8809
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: Backlog Manager
>              Labels: fiware, fiware-cosmos, hadoop
>
> Created question in FIWARE Q/A platform on 16-06-2016 at 15:06
> {color: red}Please, ANSWER this question AT{color} 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 at 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.



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)