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

[MIGUEL CARRILLO PACHECO]

Hi,

I'll put you in direct contact with the Ge owner privately (off-list)

Thanks,

Miguel
El 15/04/2015 a las 8:25, Victor Esteban escribió:
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



_______________________________________________
Fiware-tech-help mailing list
Fiware-tech-help at lists.fi-ware.org<mailto:Fiware-tech-help at lists.fi-ware.org>
https://lists.fi-ware.org/listinfo/fiware-tech-help



--

Please update your address book with my new e-mail address: miguel.carrillopacheco at telefonica.com<mailto:miguel.carrillopacheco at telefonica.com>

----------------------------------------------------------------------
     _/          _/_/                     Miguel Carrillo Pacheco
    _/   _/     _/  _/   Telefónica       Distrito Telefónica
   _/ _/_/_/   _/   _/   Investigación y  Edifico Oeste 1, Planta 6
  _/   _/     _/  _/     Desarrollo       Ronda de la Comunicación S/N
 _/          _/_/                         28050 Madrid (Spain)
                                          Tel:  (+34) 91 483 26 77

                         e-mail: miguel.carrillopacheco at telefonica.com<mailto:miguel.carrillopacheco at telefonica.com>

Follow FIWARE on the net

        Website:  http://www.fiware.org
        Facebook: https://www.facebook.com/eu.fiware
        Twitter:  http://twitter.com/Fiware
        LinkedIn: https://www.linkedin.com/groups/FIWARE-4239932
----------------------------------------------------------------------

________________________________

Este mensaje y sus adjuntos se dirigen exclusivamente a su destinatario, puede contener información privilegiada o confidencial y es para uso exclusivo de la persona o entidad de destino. Si no es usted. el destinatario indicado, queda notificado de que la lectura, utilización, divulgación y/o copia sin autorización puede estar prohibida en virtud de la legislación vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción.

The information contained in this transmission is privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, do not read it. Please immediately reply to the sender that you have received this communication in error and then delete it.

Esta mensagem e seus anexos se dirigem exclusivamente ao seu destinatário, pode conter informação privilegiada ou confidencial e é para uso exclusivo da pessoa ou entidade de destino. Se não é vossa senhoria o destinatário indicado, fica notificado de que a leitura, utilização, divulgação e/ou cópia sem autorização pode estar proibida em virtude da legislação vigente. Se recebeu esta mensagem por erro, rogamos-lhe que nos o comunique imediatamente por esta mesma via e proceda a sua destruição
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20150415/a88ed7b1/attachment.html>