Hello,

I can not connect with the servive hive remotely.

I'm use this library

https://github.com/Automattic/php-thrift-sql

And my connection declaration is the following:

// Load this lib
require_once _DIR_ . '/ThriftSQL.phar';

// Try out a Hive query
$hive = new \ThriftSQL\Hive('|cosmos.lab.fi-ware.org|',10000,'myuser','myaccountpass');
$hiveTables = $hive
->connect()
->queryAndFetchAll('SHOW TABLES' );
print_r($hiveTables );

But the call waits indefinitely until it reaches a timeout.

Thanks,

Victor.

–
Victor Esteban
*Mail: * victor@limogin.com <victor@limogin.com>
*Telf. * +34 615 800 104
*Web: * http://www.limogin.com
LinkedIn: http://www.linkedin.com/in/limogin

Dear Victor,

I’ve already forwarded your request to the second level support. They will give you help on your technical issues.

Best,
Daniele

_______________________________________________
Fiware-lab-help mailing list
Fiware-lab-help@lists.fi-ware.org
https://lists.fi-ware.org/listinfo/fiware-lab-help

Adding what has already been discussed by email:

On 07/07/2015 11:12, FRANCISCO ROMERO BUENO wrote:
Hola Victor,

Efectivamente, algunos datos a partir de /user/xxxx/report/student están subidos con propietario root:

hadoop fs -ls /user/xxxx/report/student
Found 3 items
drwxr-xr-x - root xxxx 0 2015-07-06 13:53 /user/xxxx/report/student/by_year=2013
drwxrwxrwx - xxxx xxxx 0 2015-07-07 10:30 /user/xxxx/report/student/by_year=2014
drwxr-xr-x - root xxxx 0 2015-07-07 10:29 /user/xxxx/report/student/by_year=2015

¿Cómo cargasteis estos datos?

Saludos,
Paco

NO activity since July. What are we waiting for? Thanks

As you can see, I made a question that was not answered by the user.

Anyway, doing a search on my personal email, this was finally fixed after moving to HiveServer2.

So closing.

In this cases we can wait from a couple of days to a week, no more time.
Thanks!