Connect to the Fusion SQL Service from JDBC

The default JDBC properties for connecting to the Fusion SQL service are:

Driver:

org.apache.hive.jdbc.HiveDriver

Driver JAR:

Unix:

/opt/fusion/latest.x/apps/libs/hive-jdbc-shaded-2.1.1.jar

Windows:

C:\lucidworks\fusion\latest.x\apps\libs\hive-jdbc-shaded-2.1.1.jar

JDBC URL:

jdbc:hive2://localhost:8768/default;transportMode=http;httpPath=fusion

The username and password are the same as the ones you use to authenticate to Fusion.