crateDB via Apache Drill

[Charuta Rajopadhye <ch...@gmail.com>]

Hi,

I am trying to connect to crate database via Apache Drill. Went through
Drill docs, but was unable to find pertinent information.

I could connect to my local RDBMS successfully, using the following steps: (
https://drill.apache.org/docs/plugin-configuration-basics/)

1. Visit http://localhost:8047/storage to create new storage plugin.

2. Enter configuration from
https://drill.apache.org/docs/rdbms-storage-plugin/ for mysql

3. Add mysql connector jar in jars/3rdparty

4. In drill-override.conf, add: drill.exec.sys.store.provider.local.path =
"mysql-connector-java-5.1.37-bin.jar"

Performing the exact same steps for crate does not work.

The configuration i used is:

1.

{

  "type": "jdbc",

  "driver": "io.crate.client.jdbc.CrateDriver",

  "url": "crate://localhost:5432/",

  "enabled": false

}

2. Tried this with

crate-jdbc-1.9.1.jar and crate-jdbc-standalone-2.2.0.jar

Please refer: https://crate.io/docs/clients/jdbc/#crate-jdbc-properties

Please let me know if something is amiss. The error fired is not verbose
enough. ( Please retry: error (unable to create/ update storage) )

Please let me know if i am on the right track or it has to be something
else altogether.


Thanks and Regards,

Charuta Rajopadhye