Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-2860

FIWARE.Request.Tech.Data.BigData-Analysis.DoubtsAboutUsingCosmos

    Details

    • Type: extRequest
    • Status: Closed
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:
      None

      Description

      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>]

        Activity

          People

          • Assignee:
            frb Francisco Romero
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: