search

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing
http://verdictdb.org
Apache License 2.0
249 stars 66 forks source link

ODBC #164

Closed commercial-hippie closed 6 years ago

commercial-hippie commented 6 years ago

Hi

Thanks for creating this, it's amazing!

Just wondering if there are any plans of creating a ODBC driver to connect to verdict? I'm working on a PHP application and I would love to use verdict in it.

Cheers, Michael

commercial-hippie commented 6 years ago

I've managed to build a small local API in node using node-jdbc that queries Redshift via verdict. Very basic but it's working out well.

Thanks :smile:

pyongjoo commented 6 years ago

Hi Michael,

I'm glad to hear that it's somehow working. Just a few comments:

  1. If there are any Verdict's JDBC driver errors, please submit an issue. We are trying to meet the standard JDBC41 specifications, but there could some missing functions (or inconsistencies).
  2. A better-tested version of VerdictDB will be released next week, so you can also try that one. Of course, we will have a quick-start guide for it. Right now, our test cases include postgres (10), mysql (5.5), hive, impala, redshift, and spark (2). We will add a support for Oracle and SQL Server after. If you are using something else, please let us know.
  3. We wanted to implement a native ODBC driver but haven't found time for it. We may start to work on it after several months, but not right now.

Regards, Yongjoo

On Wed, Jul 18, 2018 at 10:27 PM Michael notifications@github.com wrote:

I've managed to build a small local API in node using node-jdbc https://github.com/CraZySacX/node-jdbc/ that queries verdict. Very basic but it's working out well.

Thanks 😄

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/164#issuecomment-406134432, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQYCkOaIewpmgEHoqeqb63dhJYjYsezks5uH-6WgaJpZM4VT3TM .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com

commercial-hippie commented 6 years ago

@pyongjoo thanks for the response! I couldn't get the prepared statements working but I'll give it a go next week on the new version before I create a new issue.

Michael

pyongjoo commented 6 years ago

I see. It will be helpful if you can provide us with the query so that we can replicate the issue and ensure it works in our test cases.

If you want us to keep the query private, then you can send me an email; then, we will keep the resources in our internal private repository.

On Thu, Jul 19, 2018 at 5:12 PM Michael notifications@github.com wrote:

@pyongjoo https://github.com/pyongjoo thanks for the response! I couldn't get the prepared statements working but I'll give it a go next week on the new version before I create a new issue.

Michael

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/164#issuecomment-406415942, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQYCi6o-cj96-38XsHVeYUMMgRZlGpqks5uIPYsgaJpZM4VT3TM .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com