With RC2 (GIT 830) onwards of helical insight version 5.0 enterprise version we are supporting TrinoDB by default. In this blog we are covering how to make the connection string as well as in case if you are using an older version of helical insight how can you make it work.
- Download the Trino.zip and extract
- Copy trino.xml and trino.js file into below server path
"....\hi\hi-repository\System\Admin\SqlFunctions"
- Open sqlDialects.properties file and copy line :
# trino trino.jdbc.TrinoDriver=org.hibernate.dialect.PostgreSQLDialect
add this line into your sqlDialects.properties located at"....\hi\hi-repository\System\Admin"
- Open sqlFunctionsXmlMapping.properties file and copy line :
#trino
trino.jdbc.TrinoDriver=trino and add this line into your sqlFunctionsXmlMapping.properties located at"....\hi\hi-repository\System\Admin"
- Copy trino-jdbc-406.jar file and into below server path
"....\hi\hi-repository\System\Drivers"
- Restart Helical Insight application server.
NOTE : Above dialect configuration and JDBC driver by default come in Helical V5.0 RC2 onwards , you need to configure if you are using older version of Helical Insight
Sample connection String for Trino database :
jdbc:trino://<HOSTNAME>:8889/hive/sampledb