Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support cratedb #233

Open
cmdares opened this issue Aug 22, 2018 · 3 comments
Open

support cratedb #233

cmdares opened this issue Aug 22, 2018 · 3 comments

Comments

@cmdares
Copy link

cmdares commented Aug 22, 2018

Crate is a new big data solution for the Internet of things, which has been used in many industries. it is hoped that the embulk-output-jdbc can support the efficient ETL solution for cratedb, including insert and update.
db ref: https://crate.io/
bulk insert(update) ref:
https://crate.io/docs/crate/reference/en/latest/sql/statements/insert.html#id4

Similar to postgre sql feature
#131
thanks.

@hiroyuki-sato
Copy link
Contributor

Hello, @cmdares

Could you try embulk-output-jdbc + JDBC Driver for Crate ?

General database may possible to use JDBC plugin. Otherwise, someone needs to develop a new plugin.

@cmdares
Copy link
Author

cmdares commented Oct 1, 2018

https://crate.io/docs/crate/reference/en/latest/general/dml.html#upserts-on-duplicate-key-update
upsert feature like mysql and postgresql.
So it's still useful.

@hiroyuki-sato
Copy link
Contributor

Hello, @cmdares

Does this mean you need cratedb plugin?
Have you ever tried embulk-output-jdbc + JDBC Driver for Crate ?
If the plugin doesn't work, it's a good chance for you to create a new plugin by yourself.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants