The instructions are on the Phoenix site also – main question is how to install latest phoenix release.

 

http://phoenix.apache.org/phoenix_on_emr.html

 

 

 

Hi,

 

I’m installing Phoenix using AWS-EMR as described at the end of this link

 

http://java.dzone.com/articles/apache-phoenix-sql-driver

 

During setup you define the bootsrap action to load Phoenix onto your AWS EMR cluster.

 

I’ve a 2 questions.

 

1.       The bootstrap action installs phoenix 2.2.0 – how do you get it to install the latest release?

 

2.       If your using a JDBC connection which IP address should you connect to? Is it the master node?

 

Thanks

 

This is my code:

 

import java.sql.*;

 

public class PhoenixJDBC {

    

     public static void main(String args[]) {

    

     try {

         //Register JDBC Driver

         Class.forName("org.apache.phoenix.jdbc.PhoenixDriver").newInstance();

      

         Connection conn = DriverManager.getConnection("jdbc:phoenix:54.xx.xx.xx","","");

        

         //Create a Statement class to execute the SQL statement

         Statement stmt = conn.createStatement();

    

         //Execute the SQL statement and get the results in a Resultset

         ResultSet rs = stmt.executeQuery("select * from US_POPULATION");

    

         // Iterate through the ResultSet, displaying two values

         // for each row using the getString method

    

         while (rs.next())

             System.out.println("Name= " + rs.getString("host"));

     }

     catch (SQLException e) {

         e.printStackTrace();

     }

     catch (Exception e) {

         e.printStackTrace();

     }

     }

     }