Can't create Drill storage plugin for oracle

0
votes

I want to create storage plugin in drill for oracle jdbc. I copy ojdbc7.jar to apache-drill-1.3.0/jars/3rdparty path and add drill.exec.sys.store.provider.local.path = "/mypath" to dill.override.conf. when I want to create a new storage plugin with below configuration:

 {
  "type": "jdbc",
  "enabled": true,
  "driver": "oracle.jdbc.OracleDriver",
  "url":"jdbc:oracle:thin:user/[email protected]:1521/orcll"
}

I get unable to create/update storage error.

I am using Redhat 7 & Drill version - 1.3. in distributed mode.

1
oraclejdbcapache-drillapache-zookeeper

1 Answers

0
votes

I guess the problem is with default schema name. It should be orcl instead of orcll.

Plugin: 

{
  "type": "jdbc",
  "enabled": true
  "driver": "oracle.jdbc.OracleDriver",
  "url": "jdbc:oracle:thin:user/[email protected]:1521:orcl"   
}