Trafodion + Zeppelin on HDP2.3 Sandbox:

[#1]

Pre-reqs are to download and start the EsgynDB sandbox:

https://community.hortonworks.com/content/kbentry/23695/esgyndb-based-on-apache-trafodion-and-hdp-23...

1. Download Trafodion clients from https://esgyn.com/product/download

2. Untar JDBCT4.zip file and extract jdbcT4.jar file

3. Copy jdbcT4.jar file to zeppelin install folder/lib and restart zeppelin services

4. Launch the zeppelin localhost:9995

5. Go to the interpreter tab and click on +Create

6. In create interpreter,

for Name fieldtype, Trafodion

For Interpreter drop down box, select psql

It will show up the properties box

for postgresql.driver.nameorg.trafodion.jdbc.t4.T4Driver

For postgresql.passwordss

For postgresql.urljdbc:jdbcT4://<yourTrafodion server>:23400/:

For postgresql.userss

Then click Save

The click restart (far right)

7. Go to Notebook and create notebook by specifying a name

On the far right, click on "Interpreter Binding" Bind Trafodion interpreter to your notebook

Move Trafodion to the top and unselect the other interpreter

and then Save

8. At the %sql prompt type a SQL query (select * from trafodion.seabase.t1)

Note:

when notebook is idle interpretopr connection times out. There is a property in zeppelin site.xml file that can be modified and then restart zeppelin

<property>

<name>zeppelin.interpreter.connect.timeout</name>

<value>30000</value>

<description>Interpreter process connect timeout in msec.</description>

</property>