无法为Mysql Apache Drill创建存储插件

问题描述

在文档的帮助下: http://drill.apache.org/docs/rdbms-storage-plugin/我一直试图在Apache Drill中为Mysql创建存储插件，我尝试了多种jdbc驱动程序: mysql-connector-java-5.1.39-bin ， sqlserverjdbc ，但我总是收到错误:

With help from the documentation : http://drill.apache.org/docs/rdbms-storage-plugin/ I've been trying to create a storage plugin for Mysql in Apache Drill, I tried multiple jdbc drivers : mysql-connector-java-5.1.39-bin , sqlserverjdbc but I always get the error:

Please retry: error (unable to create/update storage)

我的配置如下:

{
"type":"jdbc",
"driver":"mysql-connector-java-5.1.39-bin",
"url":"jdbc:mysql://localhost:3306",
"username":"root",
"password":"password",
"enabled": true
}

有人知道为什么它不起作用以及如何解决它吗?预先感谢

Does anyone know why it doesn't work and how to fix it please ?Thanks in adcance

PS:我看过这篇文章 SQL Server存储插件不起作用但没有帮助

PS: I've seen this post SQL Server Storage Plugin not Working but didn't help

推荐答案

根据 docs添加此插件.

{
  "type": "jdbc",
  "driver": "com.mysql.jdbc.Driver",
  "url": "jdbc:mysql://localhost:3306",
  "username": "root",
  "password": "mypassword",
  "enabled": true
}

注意:确保在< drill-directory>/jars/3rdparty

这篇关于无法为Mysql Apache Drill创建存储插件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！