drill-user mailing list archives

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

Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
the drillbits on all nodes.

Thanks and Regards,
Akshay
On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr <arjun.kr@outlook.com> wrote:

> 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