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 17-08-2015 at 11:08
Please, ANSWER this question AT https://stackoverflow.com/questions/32047191/hive-port-is-closed
Question:
Hive port is closed
Description:
I want to launch Hive queries remotely.
For that, I am using the hive-jdbc library (0.14.0 version) and hadoop-core (1.2.1 version).
Some weeks ago, I launch the following code:
try
{ Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); }catch (ClassNotFoundException e)
{ e.printStackTrace(); System.exit(1); } Connection con = DriverManager.getConnection(
"jdbc:hive://cosmos.lab.fi-ware.org:10000/default", "user",
"password");
Statement stmt = con.createStatement();
String sql = "select * from table_name";
ResultSet res = stmt.executeQuery(sql);
while (res.next())
and it works, but now I am getting this error:
java.sql.SQLException: Could not establish connection to cosmos.lab.fi-ware.org:10000/default: java.net.ConnectException: Conexión rehusada
at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:117)
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
I saw that now the Hive port (10000) is closed.
So, I am wondering what is the correct way to use a remote hive client to access to cosmos, or If I have to change the way to get data from cosmos.
Activity
| Field | Original Value | New Value |
|---|---|---|
| Component/s | FIWARE-TECH-HELP [ 10278 ] |
| Assignee | Francisco Romero [ frb ] |
| HD-Enabler | Cosmos [ 10872 ] | |
| Description |
Created question in FIWARE Q/A platform on 17-08-2015 at 11:08 {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/32047191/hive-port-is-closed +Question:+ Hive port is closed +Description:+ I want to launch Hive queries remotely. For that, I am using the hive-jdbc library (0.14.0 version) and hadoop-core (1.2.1 version). Some weeks ago, I launch the following code: try { Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); System.exit(1); } Connection con = DriverManager.getConnection( "jdbc:hive://cosmos.lab.fi-ware.org:10000/default", "user", "password"); Statement stmt = con.createStatement(); String sql = "select * from table_name"; ResultSet res = stmt.executeQuery(sql); while (res.next()) { System.out.println("value: " + res.getString(1)); } and it works, but now I am getting this error: java.sql.SQLException: Could not establish connection to cosmos.lab.fi-ware.org:10000/default: java.net.ConnectException: Conexión rehusada at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:117) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:107) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) I saw that now the Hive port (10000) is closed. So, I am wondering what is the correct way to use a remote hive client to access to cosmos, or If I have to change the way to get data from cosmos. |
Created question in FIWARE Q/A platform on 17-08-2015 at 11:08
{color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/32047191/hive-port-is-closed +Question:+ Hive port is closed +Description:+ I want to launch Hive queries remotely. For that, I am using the hive-jdbc library (0.14.0 version) and hadoop-core (1.2.1 version). Some weeks ago, I launch the following code: try { Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); System.exit(1); } Connection con = DriverManager.getConnection( "jdbc:hive://cosmos.lab.fi-ware.org:10000/default", "user", "password"); Statement stmt = con.createStatement(); String sql = "select * from table_name"; ResultSet res = stmt.executeQuery(sql); while (res.next()) { System.out.println("value: " + res.getString(1)); } and it works, but now I am getting this error: java.sql.SQLException: Could not establish connection to cosmos.lab.fi-ware.org:10000/default: java.net.ConnectException: Conexión rehusada at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:117) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:107) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) I saw that now the Hive port (10000) is closed. So, I am wondering what is the correct way to use a remote hive client to access to cosmos, or If I have to change the way to get data from cosmos. |
| HD-Chapter | Data [ 10838 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Answered [ 10104 ] |
| Resolution | Done [ 10000 ] | |
| Status | Answered [ 10104 ] | Closed [ 6 ] |
| Fix Version/s | 2021 [ 12600 ] |