Hello,

I have some difficulties to use the cosmos service. I describe the
details here. About the hive service:

I can't connect to the cosmos service remotely

port: 10000
host: cosmos.lab.fi-ware.org <http://cosmos.lab.fi-ware.org>
user: revisely

I'm using this php connector

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

But show me this error message:
/Fatal error: Uncaught exception 'Thrift\Exception\TTransportException'
with message 'TSocket: timed out reading 5 bytes from
cosmos.lab.fi-ware.org <http://cosmos.lab.fi-ware.org>:10000

/When I try to make a join with 3 or more tables the result is
unexpected. For example, this test query displays no data when the table
has valid data.

select t1.school_id, t2.school_id, t3.school_id, t4.school_id from
(select school_id from paper group by school_id) t1 join
(select school_id from paper group by school_id) t2 on
t1.school_id=t2.school_id join
(select school_id from paper group by school_id) t3 on
t2.school_id=t3.school_id join
(select school_id from paper group by school_id) t4 on
t3.school_id=t4.school_id;

Also the version of Hive in Cosmos is 0.9, but they exists now a more
recent version, 1.1. This release as a more complete set of SQL language.
Could we it available?.

Thanks for your attention,

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

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

[Created via e-mail received from: Victor Esteban <victor@limogin.com>]