Commissioning Applications on Linux

Updated on 2022-09-14 GMT+08:00

View PDF

Running the JDBC Client and Viewing Results

Run the mvn clean compile assembly:single command to generate a JAR file and obtain it from the target directory in the project directory, for example, presto-examples-1.0-SNAPSHOT-jar-with-dependencies.jar.
Create a directory as the running directory in the running and commissioning environment, for example, /opt/presto_examples (Linux), and create the conf subdirectory in the directory.

Copy presto-examples-1.0-SNAPSHOT-jar-with-dependencies.jar exported in 1 to /opt/presto_examples.

To enable Kerberos authentication for a cluster, you need to copy the obtained user.keytab and krb5.conf files in 4 to the /opt/presto_examples/conf directory and modify the presto.preperties file in the conf directory of the sample code. Skip this step for a cluster with Kerberos authentication disabled.

**Table 1** **presto.preperties** parameters
Parameter	Description
user	Username used for Kerberos authentication, that is, the username of the development user created in Preparing a Development User.
KerberosPrincipal	Username used for authentication. That is, the username of the development user created in Preparing a Development User needs to be certificated.
KerberosConfigPath	Path where krb5.conf is stored
KerberosKeytabPath	Path where user.keytab is stored

Example

user = prestouser
SSL = true
KerberosRemoteServiceName = HTTP
KerberosPrincipal = prestouser
KerberosConfigPath = /opt/presto_examples/conf/krb5.conf
KerberosKeytabPath = /opt/presto_examples/conf/user.keytab

In Linux, run the sample program.

chmod +x /opt/presto_examples -R 
cd /opt/presto_examples
java -jar presto-examples-1.0-SNAPSHOT-jar-with-dependencies.jar

In the CLI, view the query results of the sample code.
The following information is displayed if the sample project is successful in Linux:
```
NY Metro : 2
Mid Atlantic : 6
Mid Atlantic : 6
North Midwest : 1
North Midwest : 3
North Midwest : 7
```