Unable to connect Drill to couchbase, can you give correct configuration? Please.

[karthikeyana]

I'm trying to connect drill to couchbase using jdbc-n1ql-0.4.5.jar jar but not able to connect can you give me idea to connect.

[Capppo]

driver is: "com.couchbase.jdbc.CBDriver", but probably it doesn't work again, it's too old IMHO.

[micopiira]

@Capppo

I just tried it with Couchbase 6.0.0 and managed to get the driver itself somewhat working.

You just need to give the credentials like this:

Properties properties = new Properties();
properties.put("credentials", "[{\"user\": \"Administrator\", \"pass\": \"password\"}]");
Connection con = DriverManager.getConnection("jdbc:couchbase://localhost:8093", properties);

Things that use POST requests, like batch queries don't work though but I could submit a PR for that.