apache-drill storage plugin creation failed

Question

I was trying to create a storage plugin configuration in apache-drill ( 1.6 ) for oracle jdbc. I have already copied ojdbc7.jar within the apache-drill-1.6.0/jars/3rdparty directory.

But am getting an error

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

while trying to create the storage plugin !

Here is the storage plugin configuration:

   {
      "type": "jdbc",
      "driver": "oracle.jdbc.OracleDriver",
      "url": "jdbc:oracle:thin:username/password@xx.xx.xx.xx:1521:***",
      "enabled": true
    }

& here is the drill-override.conf file :

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "localhost:2181",
  sys.store.provider.local.path="/data/drill"
}

I have restarted drill after copying ojdbc7.jar file within the drill 3rd party directory !

I found some similar issues here in stackoverflow .. ( storage_plugin failure & drill-1.3&Oracle jdbc ) But nothing worked for me !!

Do you have any idea about this ?

[ I am using apache-drill version 1.6 in distributed mode , centOS 7 & java_version 1.8 ]

Answer 1

I solved this issue by myself. Here is the changes that I did to resolve this one :

1. I changed my storage plugin configuration ( according to this POST )

   {    
     "type": "jdbc", 
     "driver": "oracle.jdbc.driver.OracleDriver",
     "url": "jdbc:oracle:thin:@<IP>:<PORT>:<SID>", 
     "username": "<USERNAME>", 
     "password": "<PASSWORD>",
     "enabled": true
   }
   

2. Just changed drill-override.conf

   drill.exec: {
      cluster-id: "drillbits1",
      zk.connect: "localhost:2181",
     drill.exec.sys.store.provider.local.path="/data/drill"
   }
   

3 . Also, I replaced ojdbc7.jar with ojdbc6.jar ( I was trying to connect oracle DB version. 11.2.0.4 -