presto-ignite-connector-plugin

This connector will help you to query the ignite(https://ignite.apache.org) in memeory database from presto. which in turn help you to join ignite data with other database(like cassandra,hive,etc).

Steps to build the jar

1. Build the jar using below command

   mvn clean install

2. Jar ignite-presto-connector-331-0.0.1-SNAPSHOT-jar-with-dependencies.jar will get generated in target folder.

3. create a folder /plugin/ignite

4.copy all the jar from /plugin/mysql to /plugin/ignite

5. Delete the presto-mysql-331-services.jar from /plugin/ignite

6. Copy the newly build jar ignite-presto-connector-331-0.0.1-SNAPSHOT-jar-with-dependencies.jar to /plugin/ignite

7.create a presto catalog file /etc/catalog/ignite.properties and add the below content.change the ip and password accordingly

  connector.name=ignite
  connection-url=jdbc:ignite:thin://localhost:10800
  ignite.user=ignite
  ignite.password=ignite

8. restart the presto server.(make sure above change should be on all the node)

Note:- This connector build aginst prestosql version 331 and ignite jdbc driver 2.7.0 It supports below functaionality

  1.Select

  2.insert

  3.alter(add and drop column)