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

FIWARE.Request.Tech.Data.BigData-Analysis.COSMOS-HIVE NOT WORKING

    Details

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

      Description

      Hello,

      After the maintenance of the past 4th of March, I cannot longer create tables on Cosmos.
      Please, find a log, where the connection is refused at 130.206.80.46:10000

      The user for this issue is jan.vansteenlandt

      time=2016-03-07T14:02:01.492UTC | lvl=INFO | trans=1457359286-159-0000000001 | srv=def_serv | subsrv=def_servpath | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[999] : Creating Hive external table 'jan_vansteenlandt_def_serv_def_servpath_esb90175829_startup_column' in database 'default'
      time=2016-03-07T14:02:01.708UTC | lvl=ERROR | trans=1457359286-159-0000000001 | srv=def_serv | subsrv=def_servpath | function=doCreateTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.backends.hive.HiveBackendImpl[103] : Runtime error (The Hive table cannot be created. Hive query='create external table if not exists default.jan_vansteenlandt_def_serv_def_servpath_esb90175829_startup_column (recvtime string,fiware_servicepath string,entityid string,entitytype string,employees string,employees_md array<struct<name:string,type:string,value:string>>,identity string,identity_md array<struct<name:string,type:string,value:string>>,position string,position_md array<struct<name:string,type:string,value:string>>,sector string,sector_md array<struct<name:string,type:string,value:string>>) row format serde 'org.openx.data.jsonserde.JsonSerDe' location '/user/jan.vansteenlandt/def_serv/def_servpath/esb90175829_startup''. Details=Could not open connection to jdbc:hive2://130.206.80.46:10000/default: java.net.ConnectException: Conexión rehusada)
      time=2016-03-07T14:02:01.709UTC | lvl=WARN | trans=1457359286-159-0000000001 | srv=def_serv | subsrv=def_servpath | function=provisionHiveTable | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionHDFSSink[1026] : The HiveQL external table could not be created, but Cygnus can continue working... Check your Hive/Shark installation

      Thanks in advance

      Confidentiality notice:
      This e-mail message, including any attachments, may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this e-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this e-mail message from your computer.

      Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost.
      Please, send your messages using the new domain (Fiware-tech-help@lists.fiware.org) instead of the old one.
      _______________________________________________
      Fiware-tech-help mailing list
      Fiware-tech-help@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-tech-help
      [Created via e-mail received from: =?utf-8?Q?Jose_Ben=C3=ADtez?= <jose@secmotic.com>]

        Activity

        Hide
        fw.ext.user FW External User added a comment -

        Hi,

        This should be fixed now.

        Regards,
        Francisco

        El 7/3/16 17:46, "Manuel Escriche (JIRA)" <jira-help-desk@fi-ware.org>

        ________________________________

        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
        Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost.
        Please, send your messages using the new domain (Fiware-tech-help@lists.fiware.org) instead of the old one.
        _______________________________________________
        Fiware-tech-help mailing list
        Fiware-tech-help@lists.fiware.org
        https://lists.fiware.org/listinfo/fiware-tech-help

        Show
        fw.ext.user FW External User added a comment - Hi, This should be fixed now. Regards, Francisco El 7/3/16 17:46, "Manuel Escriche (JIRA)" <jira-help-desk@fi-ware.org> ________________________________ 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 Since January 1st, old domains won't be supported and messages sent to any domain different to @lists.fiware.org will be lost. Please, send your messages using the new domain (Fiware-tech-help@lists.fiware.org) instead of the old one. _______________________________________________ Fiware-tech-help mailing list Fiware-tech-help@lists.fiware.org https://lists.fiware.org/listinfo/fiware-tech-help
        Hide
        frb Francisco Romero added a comment -

        Closing since no more feedback was received.

        Show
        frb Francisco Romero added a comment - Closing since no more feedback was received.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: