This program we are submitting from Eclipse local and Phoenix store in remote server.
---------------------------------------------------------------------------------------
Java code:
public static String driverName = "org.apache.phoenix.jdbc.PhoenixDriver";
try {
Class.forName(driverName);
System.out.println("In try");
conn = DriverManager.getConnection("jdbc:phoenix:10.40.17.183,10.40.17.155,10.40.17.129:2181:/hbase","","");
System.out.println("Connected");
conn.createStatement().execute("create table IF NOT EXISTS TEST0702(mykey integer not null primary key, asset_name varchar(50),item_name varchar(50),country_org_name varchar(100),branch_org_name varchar(100),dc_name varchar(100),building_name varchar(100),floor_desc varchar(500),cubicle_id varchar(500),ws_no varchar(500),iou_name varchar(500),monthly_count integer,month_year varchar(200),project_no varchar(200),project_name varchar(500),project_id varchar(200),project_status varchar(200),completion_date varchar(200),start_date varchar(200))"); conn.commit();
System.out.println("Table Created!!");
}
Console Message : In try
log4j:WARN
No appenders could be found for logger
(org.apache.hadoop.conf.Configuration.deprecation).
log4j:WARN
Please initialize the log4j system properly.
log4j:WARN
See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info. org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.MasterNotRunningException:
Can't get connection to ZooKeeper: KeeperErrorCode = OperationTimeout at
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:890) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1224) at
org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113) at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1937) at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:751) at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186) at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314) at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:306) at
org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:304) at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1363) at
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1911) at
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1880) at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1880) at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180) at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132) at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151) at
java.sql.DriverManager.getConnection(DriverManager.java:571) at
java.sql.DriverManager.getConnection(DriverManager.java:215) at
PhoenixConnection.getConnection(PhoenixConnection.java:38) at
PhoenixConnection.main(PhoenixConnection.java:17) Caused
by: org.apache.hadoop.hbase.MasterNotRunningException:
org.apache.hadoop.hbase.MasterNotRunningException:
Can't get connection to ZooKeeper: KeeperErrorCode = OperationTimeout at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$StubMaker.makeStub(HConnectionManager.java:1698) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$MasterServiceStubMaker.makeStub(HConnectionManager.java:1724) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getKeepAliveMasterService(HConnectionManager.java:1931) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getHTableDescriptor(HConnectionManager.java:2732) at
org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:426) at
org.apache.hadoop.hbase.client.HBaseAdmin.getTableDescriptor(HBaseAdmin.java:431) at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:824) ...
21 more Caused
by: org.apache.hadoop.hbase.MasterNotRunningException:
Can't get connection to ZooKeeper: KeeperErrorCode = OperationTimeout at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.checkIfBaseNodeAvailable(HConnectionManager.java:934) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.access$600(HConnectionManager.java:597) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$StubMaker.makeStubNoRetries(HConnectionManager.java:1624) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$StubMaker.makeStub(HConnectionManager.java:1670) ...
27 more Caused
by: org.apache.zookeeper.KeeperException$OperationTimeoutException:
KeeperErrorCode = OperationTimeout at
org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.checkZk(RecoverableZooKeeper.java:145) at
org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.exists(RecoverableZooKeeper.java:222) at
org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(ZKUtil.java:481) at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.checkIfBaseNodeAvailable(HConnectionManager.java:923) ...
30 more
... View more
