Phoenix错误信息: Malformed connection url

案例

HBase:

create 'employee','company','family'
put 'employee','row1','company:name','ted'
put 'employee','row1','company:position','worker'
put 'employee','row1','family:tel','13600912345'
put 'employee','row2','company:name','michael'
put 'employee','row2','company:position','manager'
put 'employee','row2','family:tel','1894225698'
scan 'employee'

Phoenix:创建映射

CREATE VIEW IF NOT EXISTS "employee" (
    "rowid" VARCHAR NOT NULL PRIMARY KEY, 
    "company"."name" VARCHAR,
    "company"."position" VARCHAR, 
    "family"."tel" VARCHAR
);
--------
0: jdbc:phoenix:node01:2181> select * from "employee"
. . . . . . . . . . . . . .> ;
+--------+----------+-----------+--------------+
| rowid  |   name   | position  |     tel      |
+--------+----------+-----------+--------------+
| row1   | ted      | worker    | 13600912345  |
| row2   | michael  | manager   | 1894225698   |

建立二级索引

create local index "idx_tel" on "employee"("family"."tel");

运行这句话的时候报错了

错误

org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 102 (08001): ERROR 102 (08001): Malformed connection url. :node01:2181,node02:2181,node03:2181:2181:/hbase; idx_tel

Malformed connection url. :node01:2181,node02:2181,node03:2181:2181

解决

cd /hbase/conf
vim hbase-site.xml
--------------修改-------

        <property>
                <name>hbase.zookeeper.quorum</name>
                <value>node01:2181,node02:2181,node03:2181</value>
        </property>
-------------------------

        <property>
                <name>hbase.zookeeper.quorum</name>
                <value>node01,node02,node03:2181</value>
        </property>

重启hbase,就成功了