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 18:06:20 GMT
Hi Arjun,

No error message getting logged in drillbit.log once I click on "create"
button.

Thanks,
Akshay

On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr <arjun.kr@outlook.com> wrote:

>
> Do you see any specific error message in drillbit.log ?
>
> Thanks,
>
> Arjun
>
> ________________________________
> From: Akshay Joshi <joshiakshay0005@gmail.com>
> Sent: Tuesday, October 31, 2017 11:10 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> 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