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

FIWARE.Request.Tech.Data.BigData-Analysis.FI-LabAssistance

    Details

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

      Description

      Dear all,

      I'm trying to connect from a VM in the FIWARE Lab to the Cosmos GE using
      Hive (following this description
      http://forge.fi-ware.org/plugins/mediawiki/wiki/fiware/index.php/BigData_Analysis_-_User_and_Programmer_Guide#Java).
      Here is my code for opening a connection to Hive:

      try {
      Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");
      } catch (ClassNotFoundException error) {
      System.err.println(error.getMessage());
      return null;
      }
      try {
      // use JDBC to connect to hive and your Cosmos credentials (first part of
      FIWARE Lab user name and FIWARE Lab password
      return DriverManager.getConnection("jdbc:hive://
      cosmos.lab.fi-ware.org:10000/default?user=" + user + "&password=" +
      password);
      } catch (SQLException error) {
      error.printStackTrace();
      System.err.println(error.getMessage());
      }

      user and password are my FIWARE Lab credentials, with out the part after
      the @.

      After a couble of seconds I get the following message, that the connection
      has been rest:

      java.sql.SQLException: org.apache.thrift.transport.TTransportException:
      java.net.SocketException: Connection reset
      at
      org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:196)
      at
      org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:132)
      at
      org.apache.hadoop.hive.jdbc.HiveConnection.configureConnection(HiveConnection.java:132)
      at
      org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:122)
      at
      org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:106)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:233)

      I've even tried to use the IP Address (130.206.80.46), but still the same
      error.
      Can you please give me a hint, what I'm doing wrong.

      Thank,
      Benjamin

      _______________________________________________
      Fiware-lab-help mailing list
      Fiware-lab-help@lists.fi-ware.org
      https://lists.fi-ware.org/listinfo/fiware-lab-help

      [Created via e-mail received from: =?UTF-8?Q?Benjamin_Gei=C3=9Fler?= <benjamin.geissler@gmail.com>]

        Activity

        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        mev Manuel Escriche made changes -
        HD-Enabler Cosmos [ 10872 ]
        HD-Chapter Data [ 10838 ]
        mev Manuel Escriche made changes -
        mev Manuel Escriche made changes -
        Summary FIWARE.Request.Lab.Data.BigData-Analysis.FI-LabAssistance FIWARE.Request.Tech.Data.BigData-Analysis.FI-LabAssistance
        mev Manuel Escriche made changes -
        Component/s FIWARE-TECH-HELP [ 10278 ]
        Component/s FIWARE-LAB-HELP [ 10279 ]
        frb Francisco Romero made changes -
        Summary [Fiware-lab-help] FI-Lab Assistance FIWARE.Request.Lab.Data.BigData-Analysis.FI-LabAssistance
        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 -
        Component/s FIWARE-LAB-HELP [ 10279 ]
        frb Francisco Romero made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        mev Manuel Escriche made changes -
        Workflow FW eRequest Workflow [ 19848 ] FW extRequest Workflow-II [ 20248 ]
        Issue Type eRequest [ 10101 ] extRequest [ 10104 ]
        FI-WARE Environment FI-LAB [ 10100 ]
        mev Manuel Escriche made changes -
        Field Original Value New Value
        Assignee Francisco Romero Bueno [ frb ]
        fw.ext.user FW External User created issue -

          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: