Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect to Apache drill through JDBC/ODBC

Onkar Nath TiwariSep 24 2018 — edited Sep 24 2018

I put a lot of efforts to connect to apche drill through JDBC/ODBC but none got successful.

I tried the links for

JDBC --> OBIEE tips and tricks: Using Apache Drill as a JDBC data source in OBIEE 12c

ODBC --> https://mapr.com/blog/essential-tips-using-apache-drill-obiee-12c/

but none worked.

After installing drill I am able to query data from command prompt but not through JDBC/ODBC driver.

pastedImage_3.png

I thought JDBC will be easier and tried JDBC but everytime I got the error

pastedImage_4.png

Any clue what's going wrong here ....

I looked in the log and found

<AdminServer> <[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <565f7960-ce1d-4768-a5bd-5a84f46d0142-000005d0> <1537770284168> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-240003> <Administration Console encountered the following error: java.lang.ClassNotFoundException: Cannot load driver: org.apache.drill.jdbc.Driver

But am not getting where exactly I need to modify the classpath to include the driverand get it loaded.

Please guide me on this....

Thanks in advance

Onkar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2018
Added on Sep 24 2018
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
731 views