Connect crateDB via Apache Drill

["charuta.rajopadhye" <ch...@springct.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/ <https://drill.apache.org/docs/plugin-configuration-basics/>)
1. Visit http://localhost:8047/storage <http://localhost:8047/storage> to create new storage plugin.
2. Enter configuration from https://drill.apache.org/docs/rdbms-storage-plugin/ <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/ <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 <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

Re: Connect crateDB via Apache Drill

["charuta.rajopadhye" <ch...@springct.com>]

I was able to achieve the connection using the storage configuration:

{

  "type": "jdbc",

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

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

  "username": "crate",

  "password": null,

  "enabled": true

}

and the crate-jdbc-standalone-2.2.0.jar

Tables involving simple datatypes can be queried using this.

But the ones with dynamic datatype, in crate return NullPointerException.

Please let me know how to work around this.


Thanks,

Charuta


On Tue, Aug 22, 2017 at 4:14 PM, Charuta Rajopadhye <charutar90@gmail.com <ma...@gmail.com>> wrote:
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/ <https://drill.apache.org/docs/plugin-configuration-basics/>)

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

2. Enter configuration from https://drill.apache.org/docs/rdbms-storage-plugin/ <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 <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



> On 22-Aug-2017, at 4:11 PM, charuta.rajopadhye <ch...@springct.com> wrote:
> 
> 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/ <https://drill.apache.org/docs/plugin-configuration-basics/>)
> 1. Visit http://localhost:8047/storage <http://localhost:8047/storage> to create new storage plugin.
> 2. Enter configuration from https://drill.apache.org/docs/rdbms-storage-plugin/ <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/ <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 <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