Details
-
Type:
Monitor
-
Status: Closed
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:
-
HD-Chapter:Data
-
HD-Enabler:Cosmos
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
catch (ClassNotFoundException e)
{ System.out.println(e.getMessage()); return null; } // try catchtry { // 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())
// while
// close everything
res.close(); stmt.close(); con.close();
} catch (SQLException ex)
// 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
Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
---|---|---|---|---|---|---|---|---|---|
|
2h 59m | 1 | Backlog Manager | 04/Oct/15 12:04 AM | |||||
|
2h 59m | 1 | Backlog Manager | 04/Oct/15 3:04 AM | |||||
|
4d 11h 59m | 1 | Backlog Manager | 08/Oct/15 3:04 PM |