CODEWITHSUNDEEP
hadoophbaseapache-phoenix
Asha Koshti
Asha Koshti

Reputation: 2993

Phoenix Installation with client gives exception?

I have configured hadoop1.0.3 on with 3 machines with fully distributed mode.on the first machine below jobs are running:

1) 4316 SecondaryNameNode 4006 NameNode 4159 DataNode 4619 TaskTracker 4425 JobTracker

2) 2794 TaskTracker 2672 DataNode

3) 3338 DataNode 3447 TaskTracker

Now when i run simple map reduce job on it,it takes longer time to execute map reducejob.So i installed HBASE layer over Hadoop.now I have below processes for HBASE on 3 clusters.

1) 5115 HQuorumPeer 5198 HMaster 5408 HRegionServer

2) 3719 HRegionServer

3) 2719 HRegionServer

Now i installed Phoenix according to the instructions:

https://github.com/forcedotcom/phoenix#installation But I dont understand where to install Phoenix client?? I installed on same master machine but i am not able to invoke the following command.

./psql.sh master(zookeeper name) ../examples/web_stat.sql ../examples/web_stat.csv ../examples/web_stat_queries.sql

It gives below error:

com.salesforce.phoenix.exception.PhoenixIOException: Retried 10 times
        at com.salesforce.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:123)
        at com.salesforce.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:106)
        at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:599)
        at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:777)
        at com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:365)
        at com.salesforce.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:81)
        at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.executeUpdate(PhoenixStatement.java:278)
        at com.salesforce.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:741)
        at com.salesforce.phoenix.util.SchemaUtil.initMetaData(SchemaUtil.java:332)
        at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:861)
        at com.salesforce.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:151)
        at com.salesforce.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:157)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:222)
        at com.salesforce.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:168)
Caused by: org.apache.hadoop.hbase.MasterNotRunningException: Retried 10 times
        at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:138)
        at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:517)

Upvotes: 0

Views: 933

Answers (1)

Tariq
Tariq

Reputation: 34184

Either your HMaster is not running or the client is not able to contact it because of some reason. Re-run JPS to make sure that it's still running. To cross check you can go to the HBase webUI (hmaster_machine:60010).

Also make sure you have added the phoenix-[version].jar to the classpath of your RegionServer or copied it to your HBASE_HOME/lib directory.

Upvotes: 1

Related Questions