Trino Connector连接器集成各种数据库(Clickhouse、Kudu)

1. Clickhouse

在所有Trino服务的etc/catalog目录下，新建配置文件clickhouse.properties，内容如下

[root@bigdata001 catalog]# cat clickhouse.properties
connector.name=clickhouse
# 只能连接一个clickhouse server
connection-url=jdbc:clickhouse://bigdata001:8123/
connection-user=default
connection-password=default123

# 将clickhouse的string类型，映射为trino的varchar类型
clickhouse.map-string-as-varchar=true
[root@bigdata001 catalog]#

然后重启所有Trino服务

2. Kudu

允许insert、delete、query数据

在所有Trino服务的etc/catalog目录下，新建配置文件kudu.properties，主要修改参数kudu.client.master-addresses，内容如下

[root@bigdata001 catalog]# cat kudu.properties
connector.name=kudu

## Defaults to NONE
kudu.authentication.type = NONE

## List of Kudu master addresses, at least one is needed (comma separated)
## Supported formats: example.com, example.com:7051, 192.0.2.1, 192.0.2.1:7051,
##                    [2001:db8::1], [2001:db8::1]:7051, 2001:db8::1
kudu.client.master-addresses=bigdata001:7051,bigdata002:7051,bigdata003:7051

## Kudu does not support schemas, but the connector can emulate them optionally.
## By default, this feature is disabled, and all tables belong to the default schema.
## For more details see connector documentation.
#kudu.schema-emulation.enabled=false

## Prefix to use for schema emulation (only relevant if `kudu.schema-emulation.enabled=true`)
## The standard prefix is `presto::`. Empty prefix is also supported.
## For more details see connector documentation.
#kudu.schema-emulation.prefix=

###########################################
### Advanced Kudu Java client configuration
###########################################

## Default timeout used for administrative operations (e.g. createTable, deleteTable, etc.)
#kudu.client.default-admin-operation-timeout = 30s

## Default timeout used for user operations
#kudu.client.default-operation-timeout = 30s

## Disable Kudu client's collection of statistics.
#kudu.client.disable-statistics = false
[root@bigdata001 catalog]#

然后重启所有Trino服务