drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akshay Joshi <joshiakshay0...@gmail.com>
Subject Apache drill : Error while creating storage plugin for Oracle DB
Date Tue, 31 Oct 2017 16:16:07 GMT
Hi Team,

I have configured drill on 4 node cluster and getting error while creating
storage plugin for Oracle DB.

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

Oracle DB Version : *12.1.0.2.0*

Following steps followed to create storage plugin:
1. copied ojdbc7.jar to jars/3rdparty folder
2. Storage plugin configuration
{
  "type": "jdbc",
  "driver": "oracle.jdbc.driver.OracleDriver",
  "url": "jdbc:oracle:thin:<<username>>/<<password>>@<<IP>>:<<PORT>>/ORCL",
  "enabled": true
}
3. drill-override.conf file
drill.exec: {
  cluster-id: "drillbits1",
  drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
  zk.connect: "<<IP>>:<<PORT>"
}

Thanks and Regards,
Akshay

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message