search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.76k stars 5.29k forks source link

support oracle？ #12911

Open vkingnew opened 5 years ago

vkingnew commented 5 years ago

support oracle？

mbasmanova commented 5 years ago

Are you asking for an Oracle connector? I'm not aware of anyone working on that. Would you like to make a contribution?

mbasmanova commented 5 years ago

Actually, looks like it might be available from Starburst: https://docs.starburstdata.com/latest/connector/oracle.html

vkingnew commented 5 years ago

I means to presto connects to oracle.Like MySQL or SQL server in official documents.

mbasmanova commented 5 years ago

@vkingnew The link above says that Starburst has developed Presto connector for Oracle and makes it available for a fee. It seem that they haven't contributed that connector to the open source though.

bendemott commented 4 years ago

I'm working on an Oracle connector to submit as a patch.

I see someone submitted a patch but didn't really have the interest to finish it - I'm hoping to finish it, write, tests, and update some documentation. I'll base the configuration parameters on the commercial Starburst connector. https://github.com/prestodb/presto/pull/11540

I also see this (very outdated) github exists: https://github.com/marcelopaesrech/presto-oracle

I could use help and input on how to integrate a test with Travis CI to validate the driver. Suggestions welcome.

There are docker containers/vms that contain test versions of Oracle Database

I'll get a repo up next week and update here. If anyone would like to help please let me know.

bendemott commented 4 years ago

@tooptoop4 Update - I've updated the oracle connector to Presto 0.225 and updated maven to build the extension as a stand-alone JAR for testing. We're currently using 0.225 for testing at my organization - I'll update to the Presto latest soon, and then keep it updated from then on. I'll create an "official" repo once it's stable. My plan is to build tests and test automation next. I'm actively working on this.

https://github.com/bendemott/presto-with-oracle

I have pending updates that I'll commit this week, I'll add pre-built JAR's as well.

TODO:

moizmuhammad commented 4 years ago

@bendemott Is pre-built JAR available?

palashgoel7 commented 3 years ago

https://github.com/prestodb/presto/pull/15014 has already added this