Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
New Member

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>

850 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎03-19-2016 12:16 AM
Updated by:
New Member CLR
 
Contributors
Top Kudoed Authors