命令说明
| 操作 | 命令 | 描述 |
|---|---|---|
| 通过客户端访问trino组件/Simple认证 | /usr/local/service/trino/client/trino-cli --server http://{coordinator_ip}:9000 --user hadoop --catalog hive --schema default --file ~/test.sql --execute "select * from city;" --debug |
user: 必选，指定用户名 catalog：可选，指定默认访问的数据源 server：必选，指定访问coordinator URL schema：可选，指定默认访问的数据库 file: 可选，指定需要执行sql的文件路径 execute: 可选，指定执行sql命令 debug： 可选，开启客户端debug日志，方便定位问题 |
| 通过客户端访问trino组件/ldap认证 | /usr/local/service/trino/client/trino-cli --server https://{coordinator_ip}:9443 --user hadoop --catalog hive --schema default --insecure --password | user: 必选，指定用户名 insecure: 必选，开启https访问 password：必选，表示需要输入密码进行身份认证 server：必选，指定访问coordinator URL catalog：可选，指定默认访问的数据源 schema：可选，指定默认访问的数据库 file: 可选，指定需要执行sql的文件路径 execute: 可选，指定执行sql命令 debug： 可选，开启客户端debug日志，方便定位问题 |
| 通过客户端访问trino组件/kerberos认证 | /usr/local/service/trino/client/trino-cli --server https://10.206.17.113:9443 --user hadoop --krb5-config-path /etc/krb5.conf --krb5-principal hadoop/10.206.17.113@TBDS-2NGVYEHH --krb5-keytab-path /var/krb5kdc/emr.keytab --krb5-remote-service-name hadoop --krb5-disable-remote-service-hostname-canonicalization --catalog hive --schema default --insecure | user: 必选，指定用户名 insecure: 必选，开启https访问 krb5-config-path：必选，客户端的krb5.conf配置路径，缺省值/etc/krb5.conf krb5-principal：必选，客户端的principal krb5-keytab-path: 必选，客户端的keytab路径 krb5-remote-service-name：必选，coordinator用于kerberos认证的服务名 krb5-disable-remote-service-hostname-canonicalization：可选，对于coordinator 的kerberos认证，若未使用规范化的主机名，一般需要带上该参数 server：必选，指定访问coordinator URL catalog：可选，指定默认访问的数据源 schema：可选，指定默认访问的数据库 file: 可选，指定需要执行sql的文件路径 execute: 可选，指定执行sql命令 debug： 可选，开启客户端debug日志，方便定位问题 |
命令示例
Simple认证
# 1 直接执行sql
[root@10 ~]# /usr/local/service/trino/client/trino-cli --server http://10.206.0.67:9000 --user hadoop --catalog hive --schema default --execute "select * from city;"
"4","city4"
"3","city3"
"1","city1"
"2","city2"
"4","city4"
# 2 进入交互终端，执行sql
[root@10 ~]# /usr/local/service/trino/client/trino-cli --server http://10.206.0.67:9000 --user hadoop --catalog hive --schema default
trino:default>
trino:default> select * from city;
id | name
----+-----------
4 | city4
3 | city3
2 | city2
1 | city1
4 | city4
(5 rows)
Query 20231128_091610_00011_bbiwe, FINISHED, 3 nodes
Splits: 21 total, 21 done (100.00%)
0.29 [5 rows, 1.86KB] [17 rows/s, 6.44KB/s]
trino:default>
trino:default>
Kerberos认证
[root@10 etc]# /usr/local/service/trino/client/trino-cli --server https://10.206.17.113:9443 --user hadoop --krb5-config-path /etc/krb5.conf --krb5-principal hadoop/10.206.17.113@TBDS-2NGVYEHH --krb5-keytab-path /var/krb5kdc/emr.keytab --krb5-remote-service-name hadoop --krb5-disable-remote-service-hostname-canonicalization --catalog hive --schema default --insecure --execute "select * from city;"
"1","city1"
"2","city2"
"3","city3"
[root@10 etc]# /usr/local/service/trino/client/trino-cli --server https://10.206.17.113:9443 --user hadoop --krb5-config-path /etc/krb5.conf --krb5-principal hadoop/10.206.17.113@TBDS-2NGVYEHH --krb5-keytab-path /var/krb5kdc/emr.keytab --krb5-remote-service-name hadoop --krb5-disable-remote-service-hostname-canonicalization --catalog hive --schema default --insecure
trino:default> select * from city;
id | name
----+----------
1 | city1
2 | city2
3 | city3
(3 rows)
Query 20240204_174308_00029_fwpar, FINISHED, 1 node
Splits: 1 total, 1 done (100.00%)
0.31 [3 rows, 386B] [9 rows/s, 1.22KB/s]
LDAP认证
[root@10 etc]# /usr/local/service/trino/client/trino-cli --server https://10.206.17.113:9443 --user hadoop --catalog hive --schema default --insecure --password --execute "select * from city;"
Password:
"1","city1"
"2","city2"
"3","city3"
trino:default> select * from city;
id | name
----+----------
1 | city1
2 | city2
3 | city3
(3 rows)
Query 20240204_174059_00025_fwpar, FINISHED, 1 node
Splits: 1 total, 1 done (100.00%)
0.27 [3 rows, 386B] [11 rows/s, 1.4KB/s]