hbase20xsqlwriter问题

[nmgliangwei]

使用hnase20xsqlwriter报no suitable driver，无法连接。我看有client的包。
大家有使用此插件的吗，是否正常。

[nmgliangwei]

{
	"content":[
		{
			"reader":{
				"parameter":{
					"path":"/user/hive/warehouse/src.db/test/dt='2021-11-01'",
					"column":[
						{
							"index":0,
							"type":"string"
						},
						{
							"index":1,
							"type":"string"
						},
						{
							"type":"string",
							"value":"{TM}"
						},
						{
							"index":3,
							"type":"string"
						}
					],
					"defaultFS":"hdfs://namenode:8020",
					"encoding":"UTF-8",
					"fileType":"parquet"
				},
				"name":"hdfsreader"
			},
			"writer":{
				"parameter":{
					"schema":"test",
					"nullMode":"skip",
					"column":[
						"a",
						"f1.b",
						"f1.c",
						"f1.d"
					],
					"batchSize":"1000",
					"table":"xxxx",
					"queryServerAddress":"http://xxxx:8765"
				},
				"name":"hbase20xsqlwriter"
			}
		}
	],
	"setting":{
		"speed":{
			"channel":2
		}
	}
}

[nmgliangwei]

报错信息如下:
�[36m2021-12-03 11:22:15.569�[0;39m �[32m[ job-0]�[0;39m �[1;31mERROR�[0;39m �[35mEngine �[0;39m - Code:[Hbasewriter-02], Description:[获取QueryServer连接时出错.]. - Code:[Hbasewriter-02], Description:[获取QueryServer连接时出错.]. - 无法连接QueryServer，配置不正确或服务未启动，请检查配置和服务状态或者联系HBase管理员. - java.sql.SQLException: No suitable driver found for http://xxx:8765
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.wgzhao.addax.plugin.writer.hbase20xsqlwriter.HBase20xSQLHelper.getClientConnection(HBase20xSQLHelper.java:108)
at com.wgzhao.addax.plugin.writer.hbase20xsqlwriter.HBase20xSQLHelper.validateParameter(HBase20xSQLHelper.java:84)
at com.wgzhao.addax.plugin.writer.hbase20xsqlwriter.HBase20xSQLWriter$Job.init(HBase20xSQLWriter.java:43)
at com.wgzhao.addax.core.job.JobContainer.initJobWriter(JobContainer.java:710)
at com.wgzhao.addax.core.job.JobContainer.init(JobContainer.java:326)
at com.wgzhao.addax.core.job.JobContainer.start(JobContainer.java:132)
at com.wgzhao.addax.core.Engine.start(Engine.java:79)
at com.wgzhao.addax.core.Engine.entry(Engine.java:137)
at com.wgzhao.addax.core.Engine.main(Engine.java:175)

[nmgliangwei]

@wgzhao 大佬有空帮看看吗

[nmgliangwei]

解决了,需要这么写,jdbc:phoenix:thin:url=http://xxxx:8765