drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arjun kr <arjun...@outlook.com>
Subject Re: Apache drill : Error while creating storage plugin for Oracle DB
Date Tue, 31 Oct 2017 17:00:10 GMT
Hi Akshay,


Did you copy jdbc driver to all the drill nodes and restarted drillbits ?


Thanks,


Arjun


________________________________
From: Akshay Joshi <joshiakshay0005@gmail.com>
Sent: Tuesday, October 31, 2017 9:46 PM
To: user@drill.apache.org
Subject: Apache drill : Error while creating storage plugin for Oracle DB

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