flink connector phoenix 一直报错如下
单独添加如下的jar 到 flink/lib 下,包如下异常、没有更详细的报错
[root@nufront-worker-01 lib]# pwd
/opt/module/flink-1.13.2/lib
[root@nufront-worker-01 lib]# ll
...
-rw-r--r-- 1 root root 4317285 Apr 1 20:10 phoenix-core-5.0.0-HBase-2.0.jar
...
这个phoenix-core-5.0.0-HBase-2.0.jar 依赖众多依赖…
新解压一个flink-1.13.2、在这目录里,进行处理、终于提示了写不一样的错…
尝试一个一个添加的话,,,没完没了(至少方向是对的)
但是看phoenix 的 jar 也不是很多。。。
那么应该有那个jar是包含他所需的…好吧 phoenix-5.0.0-HBase-2.0-client.jar 满足。。。
==== dlink flinksql connector phoenix 提交job 报错:Could not initialize class org.apache.phoenix.jdbc.PhoenixDriver ====
CREATE TABLE WHO_GOODS_LABEL (
GOODS_ID STRING,
ISWHITE STRING,
DATA_DATE STRING,
PRIMARY KEY (GOODS_ID) NOT ENFORCED
) WITH (
'connector.type' = 'phoenix',
'connector.url' = 'jdbc:phoenix:nufront-master-01:2181',
'connector.table' = 'WHO_GOODS_LABEL',
'connector.driver' = 'org.apache.phoenix.jdbc.PhoenixDriver',
--'connector.username' = '',
--'connector.password' = '',
'phoenix.schema.isnamespacemappingenabled' = 'true',
'phoenix.schema.mapsystemtablestonamespace' = 'true',
'connector.write.flush.max-rows' = '1'
);
create table test6(
GOODS_ID STRING,
ISWHITE STRING,
DATA_DATE STRING
)WITH(
'connector' = 'jdbc',
'url' = 'jdbc:mysql://nufront-worker-01:3306/ehut_line11_subway',
'table-name' = 'WHO_GOODS_LABEL',
'username' = 'root',
'password' = '123456'
);
insert into test6
select * from WHO_GOODS_LABEL;
遇到的问题:
删除flink lib里 hbase-client-2.1.0-cdh6.3.1.jar flink-sql-connector-hbase-2.2_2.11-1.13.2.jar
==== dlink 添加 phoenix 数据源 ====
jar 解压 phoenix-5.0.0-HBase-2.0-client.jar 删除servlet / gson ,再jar打包成 jar