Home Applications presto-iris

presto-iris

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
5
1 reviews
2
Awards
217
Views
0
IPM installs
0
0
Details
Releases
Reviews
Awards
Issues
Pull requests
Presto InterSystems IRIS Connector

What's new in this version

Initial Release

Presto InterSystems IRIS Connector

PrestoDB

Presto is a powerful interactive querying engine that enables running SQL queries on anything – be it MySQL, HDFS, local file, Kafka – as long as there exist a connector to the source.

This is Presto connector to the InterSystems IRIS

Usage

Build from this sources using command, requires Java 11

git clone https://github.com/caretdev/presto-iris.git
git clone presto-iris
./mvnw package

Or download the latest release
file presto-iris-0.1-plugin.tar.gz

Extract it to plugin folder of Presto

Create file named iris.properties in folder etc/catalog of Presto (e.g. /opt/presto-server/etc/catalog/iris.properties)
where the filename is a name for the catalog

connector.name=iris
connection-url=jdbc:IRIS://iris:1972/USER
connection-user=_SYSTEM
connection-password=SYS

Local Demo

Start the demo environment using docker-compose

docker-compose up -d --build

For the demo purpose, it uses Apache Superset with superset-iris,
and examples which comes with it, and it takes a while when it will loaded.

Presto UI will be availble on this link http://localhost:8080/ui/#

When SuperSet will finish load examples after 10-15 minutes, it should became available by link http://localhost:8088/databaseview/list
Using admin/admin as username/password

img.png

Superset connected to Presto, and catalog iris, which configured to connect to IRIS

Now go to Dashboards

img_2.png

Going to Presto UI we can see that Presto executed queries, and see some statistics

img_3.png

The same data from IRIS can be observed by using Presto connector in DBeaver

img_5.png

img_4.png

Read more
Donate
Made with
Version
0.1.001 Feb, 2024
Category
Integration
Works with
InterSystems IRIS
First published
24 Nov, 2023