You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Akshay Joshi <jo...@gmail.com> on 2017/11/01 04:59:32 UTC
Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Arjun/Kunal,
Error message is not getting logged in drillbit.out as well once "create"
button is clicked. None of the log files is getting updated in drill UI.
Tried with curl command and getting the same error *(unable to create/
update storage) *without much stacktrace about error. PFB more details
about curl command and o/p. HTTPS is not enabled.
Just to add I am able to connect my oracle DB using sqldeveloper client.
*COMMAND*
curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
"config": {"type": "jdbc", "enabled": true,"driver":
"oracle.dbc.driver.OracleDriver",
"url":"jdbc:oracle:thin:<user>/<password>@<oracle server>:<port>/<schema>"
}}' http://<<drill-server-ip>>:8047/storage/query.json
*CURL O/P*
* About to connect() to <<drill-server-ip>> port 8047 (#0)
* Trying <<drill-server-ip>>... connected
* Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047 (#0)
> POST /storage/query.json HTTP/1.1
> User-Agent: curl/7.19.7 <<user-agent>>
> Host: <<drill-server-ip>>:8047
> Accept: */*
> Content-Type: application/json
> Content-Length: 179
>
< HTTP/1.1 200 OK
< Content-Type: application/json
< Content-Length: 59
< Server: Jetty(9.1.5.v20140505)
<
{
"result" : "error (unable to create/ update storage)"
* Connection #0 to host <<drill-server-ip>> left intact
* Closing connection #0
}
Kindly let me know if any other thoughts.
Thanks,
Akshay
On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
>
> Can you try with CURL as well ?
>
> curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.jdbc.driver.OracleDriver",
> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> server>:<port>/<schema>" }}' http://<<http://<drill>
> drill_server>:8047/storage/oracle1.json
>
> Please refer to this blog for curl command if you have HTTPS enabled.
>
> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.html
>
> Also assume that you are able to connect with this connection URL using
> any other jdbc application.
>
> Thanks,
>
> Arjun
> ________________________________
> From: Kunal Khatua <kk...@mapr.com>
> Sent: Tuesday, October 31, 2017 11:57 PM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> There are other logs that might be reporting the error.
>
> Look at the other logs in the Drill UI ... one of them that can carry more
> information would be drillbit.out
>
> -----Original Message-----
> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
> Sent: Tuesday, October 31, 2017 11:06 AM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> 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 <ar...@outlook.com> wrote:
>
> >
> > Do you see any specific error message in drillbit.log ?
> >
> > Thanks,
> >
> > Arjun
> >
> > ________________________________
> > From: Akshay Joshi <jo...@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 <ar...@outlook.com> wrote:
> >
> > > Hi Akshay,
> > >
> > >
> > > Did you copy jdbc driver to all the drill nodes and restarted
> drillbits ?
> > >
> > >
> > > Thanks,
> > >
> > >
> > > Arjun
> > >
> > >
> > > ________________________________
> > > From: Akshay Joshi <jo...@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
> > >
> >
>
Re: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Akshay Joshi <jo...@gmail.com>.
Hi Arjun/Kunal,
Yes I am able to create storage plugins other than oracle.
I have created plugin for Alluxio. dfs and cp were default plugins.
As well I am able to trigger queries using these plugins.
Thanks,
Akshay
On Wed, 1 Nov 2017 at 11:20 AM, Arjun kr <ar...@outlook.com> wrote:
> Hi Akshay,
>
>
> Just wondering if the issue is only with Oracle storage plugin. Are you
> able to create storage plugin other than oracle , say dfs or cp ?
>
>
> Thanks,
>
>
> Arjun
>
> ________________________________
> From: Kunal Khatua <kk...@mapr.com>
> Sent: Wednesday, November 1, 2017 11:12 AM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Could you file a JIRA for this? I see the potential sources where the bug
> originated and there doesn’t seem to be sufficient logging, so it gets hard
> to narrow it down.
>
> -----Original Message-----
> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
> Sent: Tuesday, October 31, 2017 10:04 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun/Kunal,
>
> Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
>
> Thanks,
> Akshay
>
> On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
> wrote:
>
> > Hi Arjun/Kunal,
> >
> > Error message is not getting logged in drillbit.out as well once
> "create"
> > button is clicked. None of the log files is getting updated in drill UI.
> >
> > Tried with curl command and getting the same error *(unable to create/
> > update storage) *without much stacktrace about error. PFB more details
> > about curl command and o/p. HTTPS is not enabled.
> > Just to add I am able to connect my oracle DB using sqldeveloper client.
> >
> > *COMMAND*
> > curl -v -X POST -H "Content-Type: application/json" -d
> > '{"name":"oracle1",
> > "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> > OracleDriver",
> > "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> > server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> > 8047/storage/query.json
> >
> > *CURL O/P*
> > * About to connect() to <<drill-server-ip>> port 8047 (#0)
> > * Trying <<drill-server-ip>>... connected
> > * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047
> > (#0)
> > > POST /storage/query.json HTTP/1.1
> > > User-Agent: curl/7.19.7 <<user-agent>>
> > > Host: <<drill-server-ip>>:8047
> > > Accept: */*
> > > Content-Type: application/json
> > > Content-Length: 179
> > >
> > < HTTP/1.1 200 OK
> > < Content-Type: application/json
> > < Content-Length: 59
> > < Server: Jetty(9.1.5.v20140505)
> > <
> > {
> > "result" : "error (unable to create/ update storage)"
> > * Connection #0 to host <<drill-server-ip>> left intact
> > * Closing connection #0
> > }
> >
> > Kindly let me know if any other thoughts.
> >
> > Thanks,
> > Akshay
> >
> >
> > On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
> >
> >>
> >> Can you try with CURL as well ?
> >>
> >> curl -v -X POST -H "Content-Type: application/json" -d
> >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
> >> "oracle.jdbc.driver.OracleDriver",
> >> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> >> server>:<port>/<schema>" }}' http://<<http://<drill>
> >> drill_server>:8047/storage/oracle1.json
> >>
> >> Please refer to this blog for curl command if you have HTTPS enabled.
> >>
> >> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
> >> html
> >>
> >> Also assume that you are able to connect with this connection URL
> >> using any other jdbc application.
> >>
> >> Thanks,
> >>
> >> Arjun
> >> ________________________________
> >> From: Kunal Khatua <kk...@mapr.com>
> >> Sent: Tuesday, October 31, 2017 11:57 PM
> >> To: user@drill.apache.org
> >> Subject: RE: Apache drill : Error while creating storage plugin for
> >> Oracle DB
> >>
> >> There are other logs that might be reporting the error.
> >>
> >> Look at the other logs in the Drill UI ... one of them that can carry
> >> more information would be drillbit.out
> >>
> >> -----Original Message-----
> >> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
> >> Sent: Tuesday, October 31, 2017 11:06 AM
> >> To: user@drill.apache.org
> >> Subject: Re: Apache drill : Error while creating storage plugin for
> >> Oracle DB
> >>
> >> 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 <ar...@outlook.com>
> wrote:
> >>
> >> >
> >> > Do you see any specific error message in drillbit.log ?
> >> >
> >> > Thanks,
> >> >
> >> > Arjun
> >> >
> >> > ________________________________
> >> > From: Akshay Joshi <jo...@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 <ar...@outlook.com>
> wrote:
> >> >
> >> > > Hi Akshay,
> >> > >
> >> > >
> >> > > Did you copy jdbc driver to all the drill nodes and restarted
> >> drillbits ?
> >> > >
> >> > >
> >> > > Thanks,
> >> > >
> >> > >
> >> > > Arjun
> >> > >
> >> > >
> >> > > ________________________________
> >> > > From: Akshay Joshi <jo...@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
> >> > >
> >> >
> >>
> >
> >
>
Re: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Akshay Joshi <jo...@gmail.com>.
Hi Arjun,
I tried this and still getting the same error.
Thanks,
Akshay
On Wed, 1 Nov 2017 at 12:30 PM, Arjun kr <ar...@outlook.com> wrote:
>
> Noticed that you are specifying property
> 'drill.exec.sys.store.provider.local.path' inside 'drill.exec' section. Can
> you try correcting it ? if it does not work , Please create JIRA with
> details as Kunal suggested.
>
> Shared entry :
>
> 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>"
> }
>
> Correct it as given below.
>
> drill.exec: {
> cluster-id: "drillbits1",
> sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
> zk.connect: "<<IP>>:<<PORT>"
> }
>
> Thanks,
>
> Arjun
>
> ________________________________
> From: Arjun kr <ar...@outlook.com>
> Sent: Wednesday, November 1, 2017 11:20 AM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Akshay,
>
>
> Just wondering if the issue is only with Oracle storage plugin. Are you
> able to create storage plugin other than oracle , say dfs or cp ?
>
>
> Thanks,
>
>
> Arjun
>
> ________________________________
> From: Kunal Khatua <kk...@mapr.com>
> Sent: Wednesday, November 1, 2017 11:12 AM
> To: user@drill.apache.org
> Subject: RE: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Could you file a JIRA for this? I see the potential sources where the bug
> originated and there doesn’t seem to be sufficient logging, so it gets hard
> to narrow it down.
>
> -----Original Message-----
> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
> Sent: Tuesday, October 31, 2017 10:04 PM
> To: user@drill.apache.org
> Subject: Re: Apache drill : Error while creating storage plugin for Oracle
> DB
>
> Hi Arjun/Kunal,
>
> Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
>
> Thanks,
> Akshay
>
> On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
> wrote:
>
> > Hi Arjun/Kunal,
> >
> > Error message is not getting logged in drillbit.out as well once
> "create"
> > button is clicked. None of the log files is getting updated in drill UI.
> >
> > Tried with curl command and getting the same error *(unable to create/
> > update storage) *without much stacktrace about error. PFB more details
> > about curl command and o/p. HTTPS is not enabled.
> > Just to add I am able to connect my oracle DB using sqldeveloper client.
> >
> > *COMMAND*
> > curl -v -X POST -H "Content-Type: application/json" -d
> > '{"name":"oracle1",
> > "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> > OracleDriver",
> > "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> > server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> > 8047/storage/query.json
> >
> > *CURL O/P*
> > * About to connect() to <<drill-server-ip>> port 8047 (#0)
> > * Trying <<drill-server-ip>>... connected
> > * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047
> > (#0)
> > > POST /storage/query.json HTTP/1.1
> > > User-Agent: curl/7.19.7 <<user-agent>>
> > > Host: <<drill-server-ip>>:8047
> > > Accept: */*
> > > Content-Type: application/json
> > > Content-Length: 179
> > >
> > < HTTP/1.1 200 OK
> > < Content-Type: application/json
> > < Content-Length: 59
> > < Server: Jetty(9.1.5.v20140505)
> > <
> > {
> > "result" : "error (unable to create/ update storage)"
> > * Connection #0 to host <<drill-server-ip>> left intact
> > * Closing connection #0
> > }
> >
> > Kindly let me know if any other thoughts.
> >
> > Thanks,
> > Akshay
> >
> >
> > On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
> >
> >>
> >> Can you try with CURL as well ?
> >>
> >> curl -v -X POST -H "Content-Type: application/json" -d
> >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
> >> "oracle.jdbc.driver.OracleDriver",
> >> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> >> server>:<port>/<schema>" }}' http://<<http://<drill>
> >> drill_server>:8047/storage/oracle1.json
> >>
> >> Please refer to this blog for curl command if you have HTTPS enabled.
> >>
> >> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
> >> html
> >>
> >> Also assume that you are able to connect with this connection URL
> >> using any other jdbc application.
> >>
> >> Thanks,
> >>
> >> Arjun
> >> ________________________________
> >> From: Kunal Khatua <kk...@mapr.com>
> >> Sent: Tuesday, October 31, 2017 11:57 PM
> >> To: user@drill.apache.org
> >> Subject: RE: Apache drill : Error while creating storage plugin for
> >> Oracle DB
> >>
> >> There are other logs that might be reporting the error.
> >>
> >> Look at the other logs in the Drill UI ... one of them that can carry
> >> more information would be drillbit.out
> >>
> >> -----Original Message-----
> >> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
> >> Sent: Tuesday, October 31, 2017 11:06 AM
> >> To: user@drill.apache.org
> >> Subject: Re: Apache drill : Error while creating storage plugin for
> >> Oracle DB
> >>
> >> 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 <ar...@outlook.com>
> wrote:
> >>
> >> >
> >> > Do you see any specific error message in drillbit.log ?
> >> >
> >> > Thanks,
> >> >
> >> > Arjun
> >> >
> >> > ________________________________
> >> > From: Akshay Joshi <jo...@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 <ar...@outlook.com>
> wrote:
> >> >
> >> > > Hi Akshay,
> >> > >
> >> > >
> >> > > Did you copy jdbc driver to all the drill nodes and restarted
> >> drillbits ?
> >> > >
> >> > >
> >> > > Thanks,
> >> > >
> >> > >
> >> > > Arjun
> >> > >
> >> > >
> >> > > ________________________________
> >> > > From: Akshay Joshi <jo...@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
> >> > >
> >> >
> >>
> >
> >
>
Re: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Arjun kr <ar...@outlook.com>.
Noticed that you are specifying property 'drill.exec.sys.store.provider.local.path' inside 'drill.exec' section. Can you try correcting it ? if it does not work , Please create JIRA with details as Kunal suggested.
Shared entry :
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>"
}
Correct it as given below.
drill.exec: {
cluster-id: "drillbits1",
sys.store.provider.local.path="/u01/bdcsce/drill/
apache-drill-1.11.0",
zk.connect: "<<IP>>:<<PORT>"
}
Thanks,
Arjun
________________________________
From: Arjun kr <ar...@outlook.com>
Sent: Wednesday, November 1, 2017 11:20 AM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Akshay,
Just wondering if the issue is only with Oracle storage plugin. Are you able to create storage plugin other than oracle , say dfs or cp ?
Thanks,
Arjun
________________________________
From: Kunal Khatua <kk...@mapr.com>
Sent: Wednesday, November 1, 2017 11:12 AM
To: user@drill.apache.org
Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB
Could you file a JIRA for this? I see the potential sources where the bug originated and there doesn’t seem to be sufficient logging, so it gets hard to narrow it down.
-----Original Message-----
From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Arjun/Kunal,
Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
Thanks,
Akshay
On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
wrote:
> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <<drill-server-ip>> port 8047 (#0)
> * Trying <<drill-server-ip>>... connected
> * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <<user-agent>>
> > Host: <<drill-server-ip>>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
> "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <<drill-server-ip>> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver",
>> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
>> server>:<port>/<schema>" }}' http://<<http://<drill>
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> ________________________________
>> From: Kunal Khatua <kk...@mapr.com>
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -----Original Message-----
>> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> 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 <ar...@outlook.com> wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > ________________________________
>> > From: Akshay Joshi <jo...@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 <ar...@outlook.com> wrote:
>> >
>> > > Hi Akshay,
>> > >
>> > >
>> > > Did you copy jdbc driver to all the drill nodes and restarted
>> drillbits ?
>> > >
>> > >
>> > > Thanks,
>> > >
>> > >
>> > > Arjun
>> > >
>> > >
>> > > ________________________________
>> > > From: Akshay Joshi <jo...@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
>> > >
>> >
>>
>
>
Re: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Arjun kr <ar...@outlook.com>.
Hi Akshay,
Just wondering if the issue is only with Oracle storage plugin. Are you able to create storage plugin other than oracle , say dfs or cp ?
Thanks,
Arjun
________________________________
From: Kunal Khatua <kk...@mapr.com>
Sent: Wednesday, November 1, 2017 11:12 AM
To: user@drill.apache.org
Subject: RE: Apache drill : Error while creating storage plugin for Oracle DB
Could you file a JIRA for this? I see the potential sources where the bug originated and there doesn’t seem to be sufficient logging, so it gets hard to narrow it down.
-----Original Message-----
From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Arjun/Kunal,
Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
Thanks,
Akshay
On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
wrote:
> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <<drill-server-ip>> port 8047 (#0)
> * Trying <<drill-server-ip>>... connected
> * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <<user-agent>>
> > Host: <<drill-server-ip>>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
> "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <<drill-server-ip>> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver",
>> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
>> server>:<port>/<schema>" }}' http://<<http://<drill>
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> ________________________________
>> From: Kunal Khatua <kk...@mapr.com>
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -----Original Message-----
>> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> 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 <ar...@outlook.com> wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > ________________________________
>> > From: Akshay Joshi <jo...@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 <ar...@outlook.com> wrote:
>> >
>> > > Hi Akshay,
>> > >
>> > >
>> > > Did you copy jdbc driver to all the drill nodes and restarted
>> drillbits ?
>> > >
>> > >
>> > > Thanks,
>> > >
>> > >
>> > > Arjun
>> > >
>> > >
>> > > ________________________________
>> > > From: Akshay Joshi <jo...@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
>> > >
>> >
>>
>
>
RE: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Kunal Khatua <kk...@mapr.com>.
Could you file a JIRA for this? I see the potential sources where the bug originated and there doesn’t seem to be sufficient logging, so it gets hard to narrow it down.
-----Original Message-----
From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Arjun/Kunal,
Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
Thanks,
Akshay
On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
wrote:
> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d
> '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <<drill-server-ip>> port 8047 (#0)
> * Trying <<drill-server-ip>>... connected
> * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047
> (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <<user-agent>>
> > Host: <<drill-server-ip>>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
> "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <<drill-server-ip>> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver",
>> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
>> server>:<port>/<schema>" }}' http://<<http://<drill>
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.
>> html
>>
>> Also assume that you are able to connect with this connection URL
>> using any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> ________________________________
>> From: Kunal Khatua <kk...@mapr.com>
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -----Original Message-----
>> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> 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 <ar...@outlook.com> wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > ________________________________
>> > From: Akshay Joshi <jo...@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 <ar...@outlook.com> wrote:
>> >
>> > > Hi Akshay,
>> > >
>> > >
>> > > Did you copy jdbc driver to all the drill nodes and restarted
>> drillbits ?
>> > >
>> > >
>> > > Thanks,
>> > >
>> > >
>> > > Arjun
>> > >
>> > >
>> > > ________________________________
>> > > From: Akshay Joshi <jo...@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
>> > >
>> >
>>
>
>
Re: Apache drill : Error while creating storage plugin for Oracle DB
Posted by Akshay Joshi <jo...@gmail.com>.
Hi Arjun/Kunal,
Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
Thanks,
Akshay
On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <jo...@gmail.com>
wrote:
> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out as well once "create"
> button is clicked. None of the log files is getting updated in drill UI.
>
> Tried with curl command and getting the same error *(unable to create/
> update storage) *without much stacktrace about error. PFB more details
> about curl command and o/p. HTTPS is not enabled.
> Just to add I am able to connect my oracle DB using sqldeveloper client.
>
> *COMMAND*
> curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
> "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver.
> OracleDriver",
> "url":"jdbc:oracle:thin:<user>/<password>@<oracle
> server>:<port>/<schema>" }}' http://<<drill-server-ip>>:
> 8047/storage/query.json
>
> *CURL O/P*
> * About to connect() to <<drill-server-ip>> port 8047 (#0)
> * Trying <<drill-server-ip>>... connected
> * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047 (#0)
> > POST /storage/query.json HTTP/1.1
> > User-Agent: curl/7.19.7 <<user-agent>>
> > Host: <<drill-server-ip>>:8047
> > Accept: */*
> > Content-Type: application/json
> > Content-Length: 179
> >
> < HTTP/1.1 200 OK
> < Content-Type: application/json
> < Content-Length: 59
> < Server: Jetty(9.1.5.v20140505)
> <
> {
> "result" : "error (unable to create/ update storage)"
> * Connection #0 to host <<drill-server-ip>> left intact
> * Closing connection #0
> }
>
> Kindly let me know if any other thoughts.
>
> Thanks,
> Akshay
>
>
> On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <ar...@outlook.com> wrote:
>
>>
>> Can you try with CURL as well ?
>>
>> curl -v -X POST -H "Content-Type: application/json" -d
>> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver":
>> "oracle.jdbc.driver.OracleDriver", "url":"jdbc:oracle:thin:<user>/<password>@<oracle
>> server>:<port>/<schema>" }}' http://<<http://<drill>
>> drill_server>:8047/storage/oracle1.json
>>
>> Please refer to this blog for curl command if you have HTTPS enabled.
>>
>> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries.html
>>
>> Also assume that you are able to connect with this connection URL using
>> any other jdbc application.
>>
>> Thanks,
>>
>> Arjun
>> ________________________________
>> From: Kunal Khatua <kk...@mapr.com>
>> Sent: Tuesday, October 31, 2017 11:57 PM
>> To: user@drill.apache.org
>> Subject: RE: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> There are other logs that might be reporting the error.
>>
>> Look at the other logs in the Drill UI ... one of them that can carry
>> more information would be drillbit.out
>>
>> -----Original Message-----
>> From: Akshay Joshi [mailto:joshiakshay0005@gmail.com]
>> Sent: Tuesday, October 31, 2017 11:06 AM
>> To: user@drill.apache.org
>> Subject: Re: Apache drill : Error while creating storage plugin for
>> Oracle DB
>>
>> 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 <ar...@outlook.com> wrote:
>>
>> >
>> > Do you see any specific error message in drillbit.log ?
>> >
>> > Thanks,
>> >
>> > Arjun
>> >
>> > ________________________________
>> > From: Akshay Joshi <jo...@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 <ar...@outlook.com> wrote:
>> >
>> > > Hi Akshay,
>> > >
>> > >
>> > > Did you copy jdbc driver to all the drill nodes and restarted
>> drillbits ?
>> > >
>> > >
>> > > Thanks,
>> > >
>> > >
>> > > Arjun
>> > >
>> > >
>> > > ________________________________
>> > > From: Akshay Joshi <jo...@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
>> > >
>> >
>>
>
>