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!
2015-10-03 21:05|CREATED monitor | # answers= 1, accepted answer= True