How are you running Drill? Using the embedded drillbit on Linux? If you started that from the shell then it should spit you out to a shell where you can type in commands, I think it's SQLLine actually. It's been a while since I used the Drill SQLLIne shell but you should be able to type something like 'show schemas;' then 'use <schema>;' and 'show tables;' then you can do SELECT from that table.
In your example, if biz is the schema named for the JDBC plugin and merchants is the name of the table, you're likely doing it correct already. There's not much difference between ANSI and ORACLE SQL with a simple query like that. On Tue, Jun 23, 2020 at 4:24 PM Christopher Kane <[email protected]> wrote: > > Alright so I did a bit of googling and I saw SELECT 1 should work across most > database implementations. Select 1 against my data source resulted in a query > profile being generated with a Completed tag next to it, and a result with a > heading of EXPR$0 and then under that a 1. So I guess that would at least > validate that I can get something back from Oracle? > > -----Original Message----- > From: Christopher Kane > Sent: Tuesday, June 23, 2020 4:19 PM > To: [email protected] > Subject: RE: Initial Oracle Setup > > Charles > -I think you're right. My understanding of DBs is at the efficient > user/consumer level. I know how to navigate and find what I want but I do not > know the structure very well which could be causing some problems here. If > you could share a sample query that should return anything from what I am now > connected to that would be great. The query I was using was very simple, > select * from biz.merchants where merchant_id=85616270. However as you can > see 'biz' is a schema and I'm not sure if I need to set a default schema in > some way. > -Also I think I'm just the type of user where everything I touch breaks in > some way, I guess that's why I enjoy testing. > > Rafael > -I'm accessing everything from the Drill UI, if I wanted to see a list of > tables/schemas it's found how would I go about doing that? I think that would > be a good way to see if what I have setup is working as expected. With the > query I have above, how would it differ in ANSI SQL? > -I could probably get the logs, but would need to reach out to a DBA for that > and I think he's already off for the day. > > -----Original Message----- > From: Rafael Jaimes III <[email protected]> > Sent: Tuesday, June 23, 2020 4:15 PM > To: [email protected] > Subject: Re: Initial Oracle Setup > > Good point, that would be like the bug with Presto JDBC on Drill 1.18. > If that's the case, the logs from ORACLE would help diagnose the issue. > > On Tue, Jun 23, 2020 at 4:12 PM Charles Givre <[email protected]> wrote: > > > > Rafael, > > I think what's happening here is that Drill isn't understanding the results > > that Oracle is returning, perhaps due to a data type that Drill doesn't > > recognize. Chris, can you share the query? Again, usually databases are > > super easy to set up with Drill so I'm surprised this is happening. > > -- C > > > > > > > > > On Jun 23, 2020, at 4:08 PM, Rafael Jaimes III <[email protected]> > > > wrote: > > > > > > Ah thanks for the info on that. > > > > > > Chris, I can't seem to recall seeing that error before. Sounds like > > > it is a syntax issue perhaps? Note than ORACLE's SQL is a little > > > different than ANSI SQL that Drill uses. For this case, you'd be > > > using ANSI SQL and not the underlying ORACLE syntax. I believe Drill > > > should do that translation for you if I'm not mistaken. > > > > > > If you're using squirrel shell from an embedded instance, I would go > > > through and list the schemas/tables and start with some really basic > > > queries just to test connectivity. > > > > > > - Rafael > > > > > > On Tue, Jun 23, 2020 at 4:05 PM Charles Givre <[email protected]> wrote: > > >> > > >> Are you able to query anything from the DB? BTW... I'm really surprised > > >> by all of this. I've never tried Drill with Oracle, but I've used Drill > > >> with MySQL, Postgres and MSSQL and usually they're the easiest to work > > >> with. > > >> --C > > >> > > >> > > >>> On Jun 23, 2020, at 3:58 PM, Christopher Kane > > >>> <[email protected]> wrote: > > >>> > > >>> Yes thank you! To your point about using 1.17, I could always take the > > >>> config from 1.18 and copy it over and see if that fixes my issue. > > >>> > > >>> I think the only thing I'm having an issue with now I think is > > >>> related to this: > > >>> https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache > > >>> .org_jira_browse_CALCITE-2D3533&d=DwIFaQ&c=rE3mhBYFJfJGqQ7WI0-DPw& > > >>> r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=UiDno6G820rHeUAXrr > > >>> tOkJl6lm0q0XNpxN8QNitMMwA&s=f_B-GyW3JBWUrLczdKHOSTUwmHzfMYDm9WoWta > > >>> uyM3A&e= > > >>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apach > > >>> e.org_jira_browse_CALCITE-2D3533&d=DwIFaQ&c=rE3mhBYFJfJGqQ7WI0-DPw > > >>> &r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=UiDno6G820rHeUAXr > > >>> rtOkJl6lm0q0XNpxN8QNitMMwA&s=f_B-GyW3JBWUrLczdKHOSTUwmHzfMYDm9WoWt > > >>> auyM3A&e= > > > >>> > > >>> Everything appears to be setup now but when executing a query for the > > >>> data source I setup, I receive > > >>> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION > > >>> ERROR: Unknown SQL type -101. Any suggestions there? > > >>> > > >>> -----Original Message----- > > >>> From: Rafael Jaimes III <[email protected] > > >>> <mailto:[email protected]>> > > >>> Sent: Tuesday, June 23, 2020 3:43 PM > > >>> To: [email protected] <mailto:[email protected]> > > >>> Subject: Re: Initial Oracle Setup > > >>> > > >>> Glad you got it working with the new version regardless! > > >>> > > >>> On Tue, Jun 23, 2020 at 3:38 PM Christopher Kane > > >>> <[email protected]> wrote: > > >>>> > > >>>> Wow, I gotta hand it to you, I don't know what I was expecting to > > >>>> happen but I got a Success! So that's awesome, thank you so much for > > >>>> your help! I am going to quickly run a test query on this data source > > >>>> now and see what happens. > > >>>> > > >>>> -----Original Message----- > > >>>> From: Christopher Kane <[email protected]> > > >>>> Sent: Tuesday, June 23, 2020 3:31 PM > > >>>> To: [email protected] > > >>>> Subject: RE: Initial Oracle Setup > > >>>> > > >>>> Yeah I am not the most familiar with building from source, so I'll > > >>>> check out your pre-release, install it like I did 1.17.0 and see what > > >>>> happens! > > >>>> > > >>>> -----Original Message----- > > >>>> From: Charles Givre <[email protected]> > > >>>> Sent: Tuesday, June 23, 2020 3:23 PM > > >>>> To: user <[email protected]> > > >>>> Subject: Re: Initial Oracle Setup > > >>>> > > >>>> It hasn't been released yet, so you'd have to d/l from github > > >>>> (https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ > > >>>> apach > > >>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lf > > >>>> llmVq > > >>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s > > >>>> =C8v5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= > > >>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ > > >>>> apach > > >>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lf > > >>>> llmVq > > >>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s > > >>>> =C8v5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= >) and build > > >>>> from source. > > >>>> If you can't do that, I have a pre-release here: > > >>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_c > > >>>> givre > > >>>> _drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7W > > >>>> I0-DP > > >>>> w&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZS > > >>>> NloM5 > > >>>> zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H- > > >>>> qXY0& > > >>>> e= > > >>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ > > >>>> cgivr > > >>>> e_drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7 > > >>>> WI0-D > > >>>> Pw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZ > > >>>> SNloM > > >>>> 5zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H > > >>>> -qXY0 > > >>>> &e= > > > >>>> > > >>>> > > >>>>> On Jun 23, 2020, at 3:21 PM, Christopher Kane > > >>>>> <[email protected]> wrote: > > >>>>> > > >>>>> You might have to provide a link for Drill 1.18, I'm not seeing that > > >>>>> available on the downloads section of the site. > > >>>>> > > >>>>> -----Original Message----- > > >>>>> From: Christopher Kane > > >>>>> <[email protected]> > > >>>>> Sent: Tuesday, June 23, 2020 3:14 PM > > >>>>> To: [email protected] > > >>>>> Subject: RE: Initial Oracle Setup > > >>>>> > > >>>>> I'm all for it honestly, I've never used Apache Drill before and am > > >>>>> trying it out as a POC for something I'm trying to do at work. So > > >>>>> you're saying in addition to the driver required by whichever RDBMS > > >>>>> you're setting up, there is an Apache Drill JDBC plugin that works in > > >>>>> combination with the driver? > > >>>>> > > >>>>> -----Original Message----- > > >>>>> From: Charles Givre <[email protected]> > > >>>>> Sent: Tuesday, June 23, 2020 3:11 PM > > >>>>> To: [email protected] > > >>>>> Subject: Re: Initial Oracle Setup > > >>>>> > > >>>>> Another qq: Would you be willing to try Drill 1.18? There were some > > >>>>> significant changes made to the JDBC plugin in 1.18 and I wonder if > > >>>>> that might solve the issue. > > >>>>> > > >>>>>> On Jun 23, 2020, at 3:05 PM, Christopher Kane > > >>>>>> <[email protected]> wrote: > > >>>>>> > > >>>>>> On both the directory of drill and on startup I am running > > >>>>>> Apache Drill 1.17.0 > > >>>>>> > > >>>>>> -----Original Message----- > > >>>>>> From: Charles Givre <[email protected] > > >>>>>> <mailto:[email protected]>> > > >>>>>> Sent: Tuesday, June 23, 2020 3:03 PM > > >>>>>> To: user <[email protected] <mailto:[email protected]>> > > >>>>>> Subject: Re: Initial Oracle Setup > > >>>>>> > > >>>>>> One more question.. what version of Drill are you using? > > >>>>>> > > >>>>>> > > >>>>>>> On Jun 23, 2020, at 3:01 PM, Christopher Kane > > >>>>>>> <[email protected]> wrote: > > >>>>>>> > > >>>>>>> Rafael > > >>>>>>> -I did place it in the jars/3rdparty folder. > > >>>>>>> > > >>>>>>> Storage Plugin Config: > > >>>>>>> { > > >>>>>>> "type": "jdbc", > > >>>>>>> "enabled": true, > > >>>>>>> "driver": "oracle.jdbc.driver.OracleDriver", > > >>>>>>> "url": > > >>>>>>> "jdbc:oracle:thin:username/password@chris-ora-scan:1521/chris_app" > > >>>>>>> } > > >>>>>>> (it's been modified to remove sensitive information) > > >>>>>>> > > >>>>>>> Charles > > >>>>>>> -I did turn Verbose on as you instructed, below is the full > > >>>>>>> stacktrace. Now I will say that the one DBA I was conversing with > > >>>>>>> mentioned something about JRE, and I find interesting in this stack > > >>>>>>> trace that it seems to be a RunTime exception. > > >>>>>>> -I'm not sure if I was aware they were at a version 10? This is the > > >>>>>>> link I was using to download the JDBC driver: > > >>>>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e= > > >>>>>>> > > >>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e=> > > >>>>>>> and the only options I see available and relevant are either > > >>>>>>> ojdbc7.jar or ojdbc6.jar. At this point I've tried both but am > > >>>>>>> willing to change my configuration while troubleshooting. In > > >>>>>>> addition the recommended driver for Oracle by Apache seems to be > > >>>>>>> ojdbc7.12.1.0.2.jar referenced from this page here: > > >>>>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e= > > >>>>>>> > > >>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e=> > > >>>>>>> and that is the one I am currently using, ojdbc7.jar from the > > >>>>>>> 12.1.0.2 release of Oracle Database. > > >>>>>>> > > >>>>>>> 2020-06-23 14:52:37,017 [qtp377017996-50] ERROR > > >>>>>>> o.a.d.e.server.rest.StorageResources - Unable to create/ > > >>>>>>> update > > >>>>>>> plugin: QA2 Oracle > > >>>>>>> org.apache.drill.common.exceptions.ExecutionSetupException: > > >>>>>>> Failure setting up new storage plugin configuration for config > > >>>>>>> org.apache.drill.exec.store.jdbc.JdbcStorageConfig@7d9c9e53 > > >>>>>>> at > > >>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(S > > >>>>>>> tora > > >>>>>>> ge > > >>>>>>> P > > >>>>>>> l > > >>>>>>> uginRegistryImpl.java:536) at > > >>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.createOr > > >>>>>>> Upda > > >>>>>>> te > > >>>>>>> ( > > >>>>>>> S > > >>>>>>> toragePluginRegistryImpl.java:132) > > >>>>>>> at > > >>>>>>> org.apache.drill.exec.server.rest.PluginConfigWrapper.createOr > > >>>>>>> Upda > > >>>>>>> te > > >>>>>>> I > > >>>>>>> n > > >>>>>>> Storage(PluginConfigWrapper.java:56) > > >>>>>>> at > > >>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpd > > >>>>>>> ateP > > >>>>>>> lu > > >>>>>>> g > > >>>>>>> i > > >>>>>>> nJSON(StorageResources.java:212) at > > >>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpd > > >>>>>>> ateP > > >>>>>>> lu > > >>>>>>> g > > >>>>>>> i > > >>>>>>> n(StorageResources.java:233) at > > >>>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke > > >>>>>>> 0(Na > > >>>>>>> ti > > >>>>>>> v > > >>>>>>> e > > >>>>>>> Method) at > > >>>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke > > >>>>>>> (Nat > > >>>>>>> iv > > >>>>>>> e > > >>>>>>> M > > >>>>>>> ethodAccessorImpl.java:62) at > > >>>>>>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.in > > >>>>>>> voke > > >>>>>>> (D > > >>>>>>> e > > >>>>>>> l > > >>>>>>> egatingMethodAccessorImpl.java:43) > > >>>>>>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.server.model.internal.ResourceMethodInvoc > > >>>>>>> atio > > >>>>>>> nH > > >>>>>>> a > > >>>>>>> n > > >>>>>>> dlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.ja > > >>>>>>> va:8 > > >>>>>>> 1) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourc > > >>>>>>> eMet > > >>>>>>> ho > > >>>>>>> d > > >>>>>>> D > > >>>>>>> ispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourc > > >>>>>>> eMet > > >>>>>>> ho > > >>>>>>> d > > >>>>>>> D > > >>>>>>> ispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161 > > >>>>>>> ) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.server.model.internal.JavaResourceMethodD > > >>>>>>> ispa > > >>>>>>> tc > > >>>>>>> h > > >>>>>>> e > > >>>>>>> rProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatch > > >>>>>>> erPr > > >>>>>>> ov > > >>>>>>> i > > >>>>>>> d > > >>>>>>> er.java:205) at > > >>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourc > > >>>>>>> eMet > > >>>>>>> ho > > >>>>>>> d > > >>>>>>> D > > >>>>>>> ispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:9 > > >>>>>>> 9) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke > > >>>>>>> (Res > > >>>>>>> ou > > >>>>>>> r > > >>>>>>> c > > >>>>>>> eMethodInvoker.java:389) at > > >>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply( > > >>>>>>> Reso > > >>>>>>> ur > > >>>>>>> c > > >>>>>>> e > > >>>>>>> MethodInvoker.java:347) at > > >>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply( > > >>>>>>> Reso > > >>>>>>> ur > > >>>>>>> c > > >>>>>>> e > > >>>>>>> MethodInvoker.java:102) at > > >>>>>>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime. > > >>>>>>> java > > >>>>>>> :3 > > >>>>>>> 2 > > >>>>>>> 6 > > >>>>>>> ) at > > >>>>>>> org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.internal.Errors.process(Errors.java:315) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.internal.Errors.process(Errors.java:297) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.internal.Errors.process(Errors.java:267) > > >>>>>>> at > > >>>>>>> org.glassfish.jersey.process.internal.RequestScope.runInScope( > > >>>>>>> Requ > > >>>>>>> es > > >>>>>>> t > > >>>>>>> S > > >>>>>>> cope.java:317) at > > >>>>>>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java: > > >>>>>>> 3 > > >>>>>>> 05) at > > >>>>>>> org.glassfish.jersey.server.ApplicationHandler.handle(Applicat > > >>>>>>> ionH > > >>>>>>> an > > >>>>>>> d > > >>>>>>> l > > >>>>>>> er.java:1154) at > > >>>>>>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebCompo > > >>>>>>> nent > > >>>>>>> .j > > >>>>>>> a > > >>>>>>> v > > >>>>>>> a:473) at > > >>>>>>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java: > > >>>>>>> 4 > > >>>>>>> 2 > > >>>>>>> 7) at > > >>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletC > > >>>>>>> onta > > >>>>>>> in > > >>>>>>> e > > >>>>>>> r > > >>>>>>> .java:388) at > > >>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletC > > >>>>>>> onta > > >>>>>>> in > > >>>>>>> e > > >>>>>>> r > > >>>>>>> .java:341) at > > >>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletC > > >>>>>>> onta > > >>>>>>> in > > >>>>>>> e > > >>>>>>> r > > >>>>>>> .java:228) at > > >>>>>>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java: > > >>>>>>> 84 > > >>>>>>> 8 > > >>>>>>> ) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter( > > >>>>>>> Serv > > >>>>>>> le > > >>>>>>> t > > >>>>>>> H > > >>>>>>> andler.java:1780) at > > >>>>>>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFi > > >>>>>>> lter > > >>>>>>> (C > > >>>>>>> s > > >>>>>>> r > > >>>>>>> fTokenValidateFilter.java:55) at > > >>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter( > > >>>>>>> Serv > > >>>>>>> le > > >>>>>>> t > > >>>>>>> H > > >>>>>>> andler.java:1767) at > > >>>>>>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilt > > >>>>>>> er(C > > >>>>>>> sr > > >>>>>>> f > > >>>>>>> T > > >>>>>>> okenInjectFilter.java:54) at > > >>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter( > > >>>>>>> Serv > > >>>>>>> le > > >>>>>>> t > > >>>>>>> H > > >>>>>>> andler.java:1767) at > > >>>>>>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java: > > >>>>>>> 583) at > > >>>>>>> org.eclipse.jetty.server.session.SessionHandler.doHandle(Sessi > > >>>>>>> onHa > > >>>>>>> nd > > >>>>>>> l > > >>>>>>> e > > >>>>>>> r.java:224) at > > >>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(Conte > > >>>>>>> xtHa > > >>>>>>> nd > > >>>>>>> l > > >>>>>>> e > > >>>>>>> r.java:1180) at > > >>>>>>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java: > > >>>>>>> 5 > > >>>>>>> 13) at > > >>>>>>> org.eclipse.jetty.server.session.SessionHandler.doScope(Sessio > > >>>>>>> nHan > > >>>>>>> dl > > >>>>>>> e > > >>>>>>> r > > >>>>>>> .java:185) at > > >>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doScope(Contex > > >>>>>>> tHan > > >>>>>>> dl > > >>>>>>> e > > >>>>>>> r > > >>>>>>> .java:1112) at > > >>>>>>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler. > > >>>>>>> j > > >>>>>>> a > > >>>>>>> va:141) at > > >>>>>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper. > > >>>>>>> java:134) at > > >>>>>>> org.eclipse.jetty.server.Server.handle(Server.java:539) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:3 > > >>>>>>> 33) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection. > > >>>>>>> ja > > >>>>>>> v > > >>>>>>> a > > >>>>>>> :251) at > > >>>>>>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded > > >>>>>>> (Abs > > >>>>>>> tr > > >>>>>>> a > > >>>>>>> c > > >>>>>>> tConnection.java:283) at > > >>>>>>> org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:1 > > >>>>>>> 08) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannel > > >>>>>>> EndP > > >>>>>>> oi > > >>>>>>> n > > >>>>>>> t > > >>>>>>> .java:93) at > > >>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.e > > >>>>>>> xecu > > >>>>>>> te > > >>>>>>> P > > >>>>>>> r > > >>>>>>> oduceConsume(ExecuteProduceConsume.java:303) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.p > > >>>>>>> rodu > > >>>>>>> ce > > >>>>>>> C > > >>>>>>> o > > >>>>>>> nsume(ExecuteProduceConsume.java:148) > > >>>>>>> at > > >>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.r > > >>>>>>> un(E > > >>>>>>> xe > > >>>>>>> c > > >>>>>>> u > > >>>>>>> teProduceConsume.java:136) at > > >>>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedTh > > >>>>>>> read > > >>>>>>> Po > > >>>>>>> o > > >>>>>>> l > > >>>>>>> .java:671) at > > >>>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool. > > >>>>>>> java:589) at java.base/java.lang.Thread.run(Thread.java:832) > > >>>>>>> Caused by: java.lang.RuntimeException: Rule description > > >>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid at > > >>>>>>> org.apache.calcite.plan.RelOptRule.<init>(RelOptRule.java:104) > > >>>>>>> at > > >>>>>>> org.apache.calcite.rel.convert.ConverterRule.<init>(ConverterRule. > > >>>>>>> ja > > >>>>>>> v > > >>>>>>> a > > >>>>>>> :78) at > > >>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$JdbcDrelCon > > >>>>>>> vert > > >>>>>>> er > > >>>>>>> R > > >>>>>>> u > > >>>>>>> le.<init>(JdbcStoragePlugin.java:224) > > >>>>>>> at > > >>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$DrillJdbcCo > > >>>>>>> nven > > >>>>>>> ti > > >>>>>>> o > > >>>>>>> n > > >>>>>>> .<init>(JdbcStoragePlugin.java:119) > > >>>>>>> at > > >>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(Jdbc > > >>>>>>> Stor > > >>>>>>> ag > > >>>>>>> e > > >>>>>>> P > > >>>>>>> lugin.java:103) at > > >>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.n > > >>>>>>> ewIn > > >>>>>>> st > > >>>>>>> a > > >>>>>>> n > > >>>>>>> ce0(Native Method) at > > >>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.n > > >>>>>>> ewIn > > >>>>>>> st > > >>>>>>> a > > >>>>>>> n > > >>>>>>> ce(NativeConstructorAccessorImpl.java:62) > > >>>>>>> at > > >>>>>>> java.base/jdk.internal.reflect.DelegatingConstructorAccessorIm > > >>>>>>> pl.n > > >>>>>>> ew > > >>>>>>> I > > >>>>>>> n > > >>>>>>> stance(DelegatingConstructorAccessorImpl.java:45) > > >>>>>>> at > > >>>>>>> java.base/java.lang.reflect.Constructor.newInstanceWithCaller( > > >>>>>>> Cons > > >>>>>>> tr > > >>>>>>> u > > >>>>>>> c > > >>>>>>> tor.java:500) at > > >>>>>>> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java: > > >>>>>>> 4 > > >>>>>>> 81) at > > >>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(S > > >>>>>>> tora > > >>>>>>> ge > > >>>>>>> P > > >>>>>>> l > > >>>>>>> uginRegistryImpl.java:528) > > >>>>>>> ... 56 common frames omitted > > >>>>>>> > > >>>>>>> -----Original Message----- > > >>>>>>> From: Charles Givre <[email protected]> > > >>>>>>> Sent: Tuesday, June 23, 2020 2:51 PM > > >>>>>>> To: [email protected] > > >>>>>>> Subject: Re: Initial Oracle Setup > > >>>>>>> > > >>>>>>> One more thing... > > >>>>>>> Did you try with the current Oracle JDBC driver? I believe they > > >>>>>>> are at version 10 now. > > >>>>>>> Thanks, > > >>>>>>> -- C > > >>>>>>> > > >>>>>>>> On Jun 23, 2020, at 1:59 PM, Rafael Jaimes III > > >>>>>>>> <[email protected]> wrote: > > >>>>>>>> > > >>>>>>>> Hi Chris, > > >>>>>>>> > > >>>>>>>> You put the JDBC driver in the 3rd party folder? > > >>>>>>>> > > >>>>>>>> You're right you might be onto something if you get the > > >>>>>>>> password failed message. Can you post the exact text (JSON) > > >>>>>>>> of the storage plugin config? > > >>>>>>>> > > >>>>>>>> -Rafael > > >>>>>>>> > > >>>>>>>> On Tue, Jun 23, 2020 at 1:56 PM Christopher Kane > > >>>>>>>> <[email protected]> wrote: > > >>>>>>>>> > > >>>>>>>>> Hey Everyone, > > >>>>>>>>> > > >>>>>>>>> I'm looking to setup and create a new Oracle Storage Plugin for > > >>>>>>>>> my local Apache Drill instance. I have determined that a correct > > >>>>>>>>> oracle connection string with an incorrect password results in > > >>>>>>>>> the following message: Please retry: Error while creating / > > >>>>>>>>> updating storage : java.sql.SQLException: Cannot create > > >>>>>>>>> PoolableConnectionFactory (ORA-01017: invalid username/password; > > >>>>>>>>> logon denied ). Now updating the connection string to use the > > >>>>>>>>> correct password results in the following message: Please retry: > > >>>>>>>>> Error while creating / updating storage : Rule description > > >>>>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid. > > >>>>>>>>> > > >>>>>>>>> I have confirmed with our DBAs and through my own testing that my > > >>>>>>>>> connection string is correct. When attempting to google anything > > >>>>>>>>> related to the message 'JDBC_DREL_Converter' unfortunately I am > > >>>>>>>>> not able to find anything useful. At this point I'm kind of > > >>>>>>>>> grasping at straws as to what my issue is at this point. In > > >>>>>>>>> addition I also have the correct oracle thin driver installed, > > >>>>>>>>> which was the recommend one from the RDBMS page within the Apache > > >>>>>>>>> Drill documentation and I've also added this line to my > > >>>>>>>>> drill-override.conf, drill.exec.sys.store.provider.local.path = > > >>>>>>>>> "ojdbc7.jar". But I'm assuming if any of that wasn't setup > > >>>>>>>>> correctly, I wouldn't be able to get an error message back from > > >>>>>>>>> Oracle saying that my password was incorrect. Any help in regards > > >>>>>>>>> to this would be greatly appreciated. > > >>>>>>>>> > > >>>>>>>>> Christopher Kane > > >>>>>>>>> Software Test Engineer | Clover, CardConnect, FiServ > > >>>>>>>>> [email protected]<mailto:[email protected]>, > > >>>>>>>>> [email protected]<mailto:Christopher.Kane@cardconnect. > > >>>>>>>>> com>, > > >>>>>>>>> [email protected]<mailto:Christopher.Kane2@firstdata. > > >>>>>>>>> c > > >>>>>>>>> o > > >>>>>>>>> m>, > > >>>>>>>>> m>[email protected]<mailto:Christopher.Kane1@fise > > >>>>>>>>> m>rv.c > > >>>>>>>>> m>om > > >>>>>>>>> m>> > > >>>>>>>>> > > >>>>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any > > >>>>>>>>> attachments are proprietary and confidential information > > >>>>>>>>> protected from disclosure and intended only for the use of the > > >>>>>>>>> recipient(s) named above. If the reader of this message is not > > >>>>>>>>> the intended recipient, or an employee or agent responsible for > > >>>>>>>>> delivering this message to the intended recipient, you are hereby > > >>>>>>>>> notified that any dissemination, distribution or copying of this > > >>>>>>>>> message or any attachments is strictly prohibited. If you have > > >>>>>>>>> received this communication in error, please notify CardConnect > > >>>>>>>>> immediately by replying to this message and then delete this > > >>>>>>>>> message and any attachments from your computer. > > >>>>>>> > > >>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any > > >>>>>>> attachments are proprietary and confidential information protected > > >>>>>>> from disclosure and intended only for the use of the recipient(s) > > >>>>>>> named above. If the reader of this message is not the intended > > >>>>>>> recipient, or an employee or agent responsible for delivering this > > >>>>>>> message to the intended recipient, you are hereby notified that any > > >>>>>>> dissemination, distribution or copying of this message or any > > >>>>>>> attachments is strictly prohibited. If you have received this > > >>>>>>> communication in error, please notify CardConnect immediately by > > >>>>>>> replying to this message and then delete this message and any > > >>>>>>> attachments from your computer. > > >>>>>> > > >>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any > > >>>>>> attachments are proprietary and confidential information protected > > >>>>>> from disclosure and intended only for the use of the recipient(s) > > >>>>>> named above. If the reader of this message is not the intended > > >>>>>> recipient, or an employee or agent responsible for delivering this > > >>>>>> message to the intended recipient, you are hereby notified that any > > >>>>>> dissemination, distribution or copying of this message or any > > >>>>>> attachments is strictly prohibited. If you have received this > > >>>>>> communication in error, please notify CardConnect immediately by > > >>>>>> replying to this message and then delete this message and any > > >>>>>> attachments from your computer. > > >>>>> > > >>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments > > >>>>> are proprietary and confidential information protected from > > >>>>> disclosure and intended only for the use of the recipient(s) named > > >>>>> above. If the reader of this message is not the intended recipient, > > >>>>> or an employee or agent responsible for delivering this message to > > >>>>> the intended recipient, you are hereby notified that any > > >>>>> dissemination, distribution or copying of this message or any > > >>>>> attachments is strictly prohibited. If you have received this > > >>>>> communication in error, please notify CardConnect immediately by > > >>>>> replying to this message and then delete this message and any > > >>>>> attachments from your computer. > > >>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments > > >>>>> are proprietary and confidential information protected from > > >>>>> disclosure and intended only for the use of the recipient(s) named > > >>>>> above. If the reader of this message is not the intended recipient, > > >>>>> or an employee or agent responsible for delivering this message to > > >>>>> the intended recipient, you are hereby notified that any > > >>>>> dissemination, distribution or copying of this message or any > > >>>>> attachments is strictly prohibited. If you have received this > > >>>>> communication in error, please notify CardConnect immediately by > > >>>>> replying to this message and then delete this message and any > > >>>>> attachments from your computer. > > >>>> > > >>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments > > >>>> are proprietary and confidential information protected from disclosure > > >>>> and intended only for the use of the recipient(s) named above. If the > > >>>> reader of this message is not the intended recipient, or an employee > > >>>> or agent responsible for delivering this message to the intended > > >>>> recipient, you are hereby notified that any dissemination, > > >>>> distribution or copying of this message or any attachments is strictly > > >>>> prohibited. If you have received this communication in error, please > > >>>> notify CardConnect immediately by replying to this message and then > > >>>> delete this message and any attachments from your computer. > > >>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments > > >>>> are proprietary and confidential information protected from disclosure > > >>>> and intended only for the use of the recipient(s) named above. If the > > >>>> reader of this message is not the intended recipient, or an employee > > >>>> or agent responsible for delivering this message to the intended > > >>>> recipient, you are hereby notified that any dissemination, > > >>>> distribution or copying of this message or any attachments is strictly > > >>>> prohibited. If you have received this communication in error, please > > >>>> notify CardConnect immediately by replying to this message and then > > >>>> delete this message and any attachments from your computer. > > >>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments > > >>> are proprietary and confidential information protected from disclosure > > >>> and intended only for the use of the recipient(s) named above. If the > > >>> reader of this message is not the intended recipient, or an employee or > > >>> agent responsible for delivering this message to the intended > > >>> recipient, you are hereby notified that any dissemination, distribution > > >>> or copying of this message or any attachments is strictly prohibited. > > >>> If you have received this communication in error, please notify > > >>> CardConnect immediately by replying to this message and then delete > > >>> this message and any attachments from your computer. > > >> > > > THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are > proprietary and confidential information protected from disclosure and > intended only for the use of the recipient(s) named above. If the reader of > this message is not the intended recipient, or an employee or agent > responsible for delivering this message to the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > message or any attachments is strictly prohibited. If you have received this > communication in error, please notify CardConnect immediately by replying to > this message and then delete this message and any attachments from your > computer.
