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 <[email protected]> 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
