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 From: Brady, John Sent: Tuesday, March 10, 2015 9:56 AM To: 'user@phoenix.apache.org' Subject: installing Phoenix using AWS-EMR 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(); } } } ------------------------------------------------------------- Intel Ireland Limited (Branch) Collinstown Industrial Park, Leixlip, County Kildare, Ireland Registered Number: E902934 This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
