data connection name

Support custom name, or use the system default name, the default format is Trino_YYYYMMDDHHMMSS

connection method

• IP/Port: Support entering the server connection address and port number to connect
• JDBC connection string: Support entering JDBC connection string connection

JDBC connection string

String to connect to the database through the JDBC interface.
The following JDBC URL format: jdbc: presto://host: port jdbc: presto://host: port/catalog jdbc: presto://host: port/catalog/schema
For example, use the following URL to connect to Presto running on a example.net port with a directory and schema: jdbc: presto://example.net:8080/hive/sales
You can use the URL above to create a connection.
String url = "jdbc:presto://example.net:8080/hive/sales"; Connection connection = DriverManager.getConnection(url, "test", **null**);

server

Enter the connection address for the server

Port

Enter the port number for the server.

Authentication method

• Username and password: If you choose the form of username + password for verification, just enter it directly.
• Kerberos: If the authentication method is selected Kerberos.
  • Server, port, keytab, krb5 are provided by the data source.
  • Principal: The principal here refers to the user level, which can generally be viewed through the keytab file. The command is (take dlcdp.keytab as an example):

    • mac：ktutil --keytab=dlcdp.keytab list

    • linux：klist -kt dlcdp.keytab

      The execution result of the Mac platform:
      

      

As can be seen from the figure above, the principal corresponding to the file dlcdp.keytab is dlcdp@CDH.COM.

1. Connection method:

user name

Enter the account name used to log in

password

Enter the password corresponding to the specified username

database

Enter the database name