[Fiware-tech-help] doubts about the use of the service cosmos

[Victor Esteban]

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 at limogin.com <mailto:victor at limogin.com>
*Telf. * +34 615 800 104
*Web: * http://www.limogin.com
*LinkedIn:* http://www.linkedin.com/in/limogin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20150415/793f1ce5/attachment.html>