[Backlogmanager] [FIWARE-JIRA] (HELP-8777) [fiware-stackoverflow] Hive port is closed

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-8777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez updated HELP-8777:
---------------------------------
     HD-Chapter: Data
    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.


  was:

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-Enabler: Cosmos

> [fiware-stackoverflow] Hive port is closed
> ------------------------------------------
>
>                 Key: HELP-8777
>                 URL: https://jira.fiware.org/browse/HELP-8777
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: Francisco Romero
>              Labels: fiware, fiware-cosmos, hadoop
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)