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 <[email protected]
<mailto:[email protected]>> 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
> <[email protected]> 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
