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

FIWARE.Request.Tech.Data.BigData-Analysis.Can't connect to Cosmos to query Hive server using JDBC client

    Details

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

      Description

      Seems like some connection/network issue.

      Any idea whats wrong?

      Thanks!

      the exception I get is:

      Can not get hive connection java.sql.SQLException: Could not open client
      transport with JDBC Uri: jdbc:hive2://cosmos.lab.fiware.org:10000/default:
      null
      java.sql.SQLException: Could not open client transport with JDBC Uri:
      jdbc:hive2://cosmos.lab.fiware.org:10000/default: null
      at
      org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:215)
      at
      org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:163)
      at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:215)

      Menachem Shtalhaim

      menachem.shtalhaim@n-join.com <elkana@n-join.com> | +972-5
      <%2B972-527-213941>47241959 | www.n-join.com

      n-Join – Maximizing industrial potential

      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-incense-coaching@lists.fiware.org) instead of the old one.
      _______________________________________________
      Fiware-incense-coaching mailing list
      Fiware-incense-coaching@lists.fiware.org
      https://lists.fiware.org/listinfo/fiware-incense-coaching
      [Created via e-mail received from: Menachem Shtalhaim <menachem.shtalhaim@n-join.com>]

        Issue Links

          Activity

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open In Progress In Progress
          15h 1 Francisco Romero 10/Mar/16 8:42 AM
          Closed Closed In Progress In Progress
          1s 1 Manuel Escriche 05/Apr/16 6:00 PM
          In Progress In Progress Answered Answered
          2d 21h 21m 2 Francisco Romero 08/Apr/16 3:22 PM
          Answered Answered Closed Closed
          26d 8h 18m 2 Francisco Romero 08/Apr/16 3:22 PM
          fla Fernando Lopez made changes -
          Fix Version/s 2021 [ 12600 ]
          mev Manuel Escriche made changes -
          backlogmanager Backlog Manager made changes -
          Summary [Fiware-incense-coaching] Can't connect to Cosmos to query Hive server using JDBC client FIWARE.Request.Tech.Data.BigData-Analysis.Can't connect to Cosmos to query Hive server using JDBC client
          HD-Chapter Data [ 10838 ]
          Hide
          frb Francisco Romero added a comment -

          Closing no more feedback was received.

          Show
          frb Francisco Romero added a comment - Closing no more feedback was received.
          frb Francisco Romero made changes -
          Resolution Done [ 10000 ]
          Status Answered [ 10104 ] Closed [ 6 ]
          frb Francisco Romero made changes -
          Status In Progress [ 3 ] Answered [ 10104 ]
          mev Manuel Escriche made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] In Progress [ 3 ]
          mev Manuel Escriche made changes -
          Resolution Fixed [ 1 ] Done [ 10000 ]
          Status Answered [ 10104 ] Closed [ 6 ]
          mev Manuel Escriche made changes -
          Resolution Fixed [ 1 ]
          HD-Enabler Cosmos [ 10872 ]
          Hide
          fw.ext.user FW External User added a comment -

          Hi Pasquale,

          I always sent a copy to the list and to the personal email of the user

          Regards,
          Francisco

          El 10/3/16 11:43, "Pasquale Andriani (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

          Show
          fw.ext.user FW External User added a comment - Hi Pasquale, I always sent a copy to the list and to the personal email of the user Regards, Francisco El 10/3/16 11:43, "Pasquale Andriani (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
          Hide
          pandriani Pasquale Andriani added a comment -

          Hi Francisco,
          please use to JIRA EMAIL feature, otherwise your reply will never reach the external user.

          Thanks in advance,
          Pasquale

          Show
          pandriani Pasquale Andriani added a comment - Hi Francisco, please use to JIRA EMAIL feature, otherwise your reply will never reach the external user. Thanks in advance, Pasquale
          frb Francisco Romero made changes -
          Status In Progress [ 3 ] Answered [ 10104 ]
          frb Francisco Romero made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          fw.ext.user FW External User added a comment -

          Hi,

          This should be fixed now. I¹ve found that after rebooting the cluster last
          week another process different than HiveServer2 was eventually taking the
          TCP/10000 port.

          Regards,
          Francisco

          El 9/3/16 18:08, "Pasquale Andriani (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. I¹ve found that after rebooting the cluster last week another process different than HiveServer2 was eventually taking the TCP/10000 port. Regards, Francisco El 9/3/16 18:08, "Pasquale Andriani (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
          pandriani Pasquale Andriani made changes -
          Assignee Francisco Romero [ frb ]
          Hide
          pandriani Pasquale Andriani added a comment -

          Hi, can you have a look to this?
          Regards,
          P.

          Show
          pandriani Pasquale Andriani added a comment - Hi, can you have a look to this? Regards, P.
          backlogmanager Backlog Manager made changes -
          Field Original Value New Value
          Link This issue relates to HELC-1307 [ HELC-1307 ]
          backlogmanager Backlog Manager created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved: