Phoenix创建local index失败
执行创建local index出现如下错误
0: jdbc:phoenix:hbase01:2181> create local index local_index_name on "test" ("user"."name","user"."address");
23/07/28 17:28:56 WARN client.SyncCoprocessorRpcChannel: Call failed on IOException
org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 102 (08001): ERROR 102 (08001): Malformed connection url. :hbase01:2181,hbase02:2181,hbase03:2181:2181:/hbase; LOCAL_INDEX_NAMEat org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:106)at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:2188)at org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:17317)at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7930)at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2535)at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2509)at org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:45004)at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:415)at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124)at org.apache.hadoop.hbase.ipc.RpcHandler.run(RpcHandler.java:102)at org.apache.hadoop.hbase.ipc.RpcHandler.run(RpcHandler.java:82)
Caused by: java.sql.SQLException: ERROR 102 (08001): Malformed connection url. :hbase01:2181,hbase02:2181,hbase03:2181:2181:/hbase;at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:607)at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:217)at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.getMalFormedUrlException(PhoenixEmbeddedDriver.java:204)at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.create(PhoenixEmbeddedDriver.java:262)at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:144)at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)at java.sql.DriverManager.getConnection(DriverManager.java:664)at java.sql.DriverManager.getConnection(DriverManager.java:208)at org.apache.phoenix.util.QueryUtil.getConnection(QueryUtil.java:425)at org.apache.phoenix.util.QueryUtil.getConnectionOnServer(QueryUtil.java:403)at org.apache.phoenix.util.QueryUtil.getConnectionOnServer(QueryUtil.java:384)at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:2045)将hbase的配置文件hbase-site.xml中的hbase.zookeeper.quorum的value改成如下就即可
<property><name>hbase.zookeeper.quorum</name><value>hbase01,hbase02,hbase03</value></property>