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 <arjun...@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 <kkha...@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:joshiakshay0...@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 <joshiakshay0...@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 <arjun...@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 <kkha...@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:joshiakshay0...@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 <arjun...@outlook.com> > wrote: > >> > >> > > >> > Do you see any specific error message in drillbit.log ? > >> > > >> > Thanks, > >> > > >> > Arjun > >> > > >> > ________________________________ > >> > From: Akshay Joshi <joshiakshay0...@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...@outlook.com> > wrote: > >> > > >> > > Hi Akshay, > >> > > > >> > > > >> > > Did you copy jdbc driver to all the drill nodes and restarted > >> drillbits ? > >> > > > >> > > > >> > > Thanks, > >> > > > >> > > > >> > > Arjun > >> > > > >> > > > >> > > ________________________________ > >> > > From: Akshay Joshi <joshiakshay0...@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 > >> > > > >> > > >> > > > > >
