You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by sharda borse <sh...@gmail.com> on 2018/03/08 06:50:10 UTC
unable to add storahe plugin for rdbms
Hi Drill Support Team,
i was trying to add rdbms storage plugin for apache drill. but receieved
error as "
"
Followed same steps.
1. added mysql-connector-java-5.1.45 in
/apache-drill-1.12.0/jars/3rdparty/
2.
changed drill-override.conf contents
> drill.exec: {
cluster-id: "drillbits1",
zk.connect: "localhost:2181",
drill.exec.sys.store.provider.local.path =
> "mysql-connector-java-5.1.45-bin.jar"
}
3. restarted drill
4. logged through drill UI to add storage plugin.
- new Storage pluging name:- jdbcMysql
{
"type":"jdbc",
"driver":"com.mysql.jdbc.Driver",
"url":"jdbc:mysql://127.0.0.1:3306",
"username":"root",
"password":"hadoop",
"enabled":true
}
-
error:- *Please retry: error (unable to create/ update storage)*
--
Thanks,
Sharda Borse
Re: unable to add storahe plugin for rdbms
Posted by Kunal Khatua <ku...@apache.org>.
This looks incorrect:
drill.exec.sys.store.provider.local.path = "mysql-connector-java-5.1.
45-bin.jar"
Refer this https://drill.apache.org/docs/storage-plugin-registration/#
storage-plugin-configuration-persistence
and provide a path that will allow you to persist the storage plugins'
info.
On 3/7/2018 11:45:06 PM, sharda borse <sh...@gmail.com> wrote:
Hi Drill Support Team,
i was trying to add rdbms storage plugin for apache drill. but receieved
error as "
"
Followed same steps.
1. added mysql-connector-java-5.1.45 in
/apache-drill-1.12.0/jars/3rdparty/
2.
changed drill-override.conf contents
> drill.exec: {
cluster-id: "drillbits1",
zk.connect: "localhost:2181",
drill.exec.sys.store.provider.local.path =
> "mysql-connector-java-5.1.45-bin.jar"
}
3. restarted drill
4. logged through drill UI to add storage plugin.
- new Storage pluging name:- jdbcMysql
{
"type":"jdbc",
"driver":"com.mysql.jdbc.Driver",
"url":"jdbc:mysql://127.0.0.1:3306",
"username":"root",
"password":"hadoop",
"enabled":true
}
-
error:- *Please retry: error (unable to create/ update storage)*
--
Thanks,
Sharda Borse