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

FIWARE.Question.Tech.Data.BigData-Analysis.Accesing Cosmos data with Hive from Javascript

    Details

      Description

      Created question in FIWARE Q/A platform on 14-10-2014 at 18:10
      Please, ANSWER this question AT http://stackoverflow.com/questions/26366059/accesing-cosmos-data-with-hive-from-javascript

      Question:
      Accesing Cosmos data with Hive from Javascript

      Description:
      I'm triying to access data stored in Cosmos by using javascript to create a web interface. I know there's a java code available to make query's with Hive. That code is shown below:

      private Connection getConnection(
      String ip, String port, String user, String password) {
      try

      { // dynamically load the Hive JDBC driver Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); }

      catch (ClassNotFoundException e)

      { System.out.println(e.getMessage()); return null; } // try catch

      try { // return a connection based on the Hive JDBC driver, default DB return DriverManager.getConnection("jdbc:hive://" + ip + ":" + port + "/default?user=" + user + "&password=" + password); } catch (SQLException e) { System.out.println(e.getMessage()); return null; }

      // try catch
      } // getConnection

      private void doQuery() {
      try {
      // from here on, everything is SQL!
      Statement stmt = con.createStatement();
      ResultSet res = stmt.executeQuery("select column1,column2," +
      "otherColumns from mytable where column1='whatever' and " +
      "columns2 like '%whatever%'");

      // iterate on the result
      while (res.next())

      { String column1 = res.getString(1); Integer column2 = res.getInteger(2); // whatever you want to do with this row, here }

      // while

      // close everything
      res.close(); stmt.close(); con.close();
      } catch (SQLException ex)

      { System.exit(0); }

      // try catch
      } // doQuery

      I need to know how to implement that code in javascript, I know it's possible but I don't know how.

      Thanks!

        Activity

        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-03 21:05|CREATED monitor | # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-03 21:05|CREATED monitor | # answers= 1, accepted answer= True
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-04 00:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-04 00:05|UPDATED status: transition Answer| # answers= 1, accepted answer= True
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-04 03:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-04 03:05|UPDATED status: transition Answered| # answers= 1, accepted answer= True
        Hide
        backlogmanager Backlog Manager added a comment -

        2015-10-08 15:05|UPDATED status: transition Finish| # answers= 1, accepted answer= True

        Show
        backlogmanager Backlog Manager added a comment - 2015-10-08 15:05|UPDATED status: transition Finish| # answers= 1, accepted answer= True

          People

          • Assignee:
            frb Francisco Romero
            Reporter:
            backlogmanager Backlog Manager
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: