1. 首先安裝presto

安裝教程可以參考官網(wǎng)及下面這篇文章
官方文檔
presto安裝及連接mysql

完畢可以連接mysql測試一下是否安裝成功

2. 下載presto-clickhouse

這里已有大佬實現(xiàn)presto-clickhouse的Connectors,我們直接下載來用就好
https://github.com/zeeshanabid94/presto/tree/presto-clickhouse/presto-clickhouse

3. 編譯presto-clickhouse

我們只需要編譯presto-clickhouse部分,這里有兩種方式
直接在下載的項目里編譯,不過有很多check,對maven忆绰、jdk版本進行檢測,這些按照官網(wǎng)要求來,當然也可以在主pom中關掉check
也可以直接新建一個項目編譯
這里我選擇新建項目

①:新建項目,拷貝代碼

這里我們選擇新建一個項目,把下載的presto_clickhouse中的代碼拷貝進去

拷貝代碼

②:添加clickhouse Connector

在resource下新建META-INF/services 目錄,在此目錄下新建com.facebook.presto.spi.Plugin文件,在文件中添加com.facebook.presto.plugin.clickhouse.ClickhousePlugin,如下圖
這一步主要是為了ConnectorFactory能識別clcikhouse的Connector

配置ClickhousePlugin

③:修改pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>base_module</artifactId>
        <groupId>idea_workspace</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>

    <modelVersion>4.0.0</modelVersion>

    <artifactId>presto-clickhouse</artifactId>


    <dependencies>

        <!--- Clickhouse JDBC Driver -->
        <dependency>
            <groupId>ru.yandex.clickhouse</groupId>
            <artifactId>clickhouse-jdbc</artifactId>
            <version>0.1.50</version>
        </dependency>

        <dependency>
            <groupId>com.facebook.presto</groupId>
            <artifactId>presto-spi</artifactId>
            <version>0.223</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-annotations</artifactId>
            <version>2.9.7</version>
        </dependency>

        <dependency>
            <groupId>io.airlift</groupId>
            <artifactId>log</artifactId>
            <version>0.178</version>
        </dependency>

        <dependency>
            <groupId>io.airlift</groupId>
            <artifactId>configuration</artifactId>
            <version>0.178</version>
        </dependency>

        <dependency>
            <groupId>javax.inject</groupId>
            <artifactId>javax.inject</artifactId>
            <version>1</version>
        </dependency>


        <dependency>
            <groupId>com.google.guava</groupId>
            <artifactId>guava</artifactId>
            <version>24.1-jre</version>
        </dependency>


        <dependency>
            <groupId>com.google.inject</groupId>
            <artifactId>guice</artifactId>
            <version>4.2.0</version>
        </dependency>

        <dependency>
            <groupId>com.facebook.presto</groupId>
            <artifactId>presto-base-jdbc</artifactId>
            <version>0.223</version>
        </dependency>



    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-shade-plugin</artifactId>
                <version>2.4.3</version>
                <executions>
                    <execution>
                        <phase>package</phase>
                        <goals>
                            <goal>shade</goal>
                        </goals>
                        <configuration>
                            <filters>
                                <filter>
                                    <artifact>*:*</artifact>
                                    <excludes>
                                        <exclude>META-INF/*.SF</exclude>
                                        <exclude>META-INF/*.DSA</exclude>
                                        <exclude>META-INF/*.RSA</exclude>
                                    </excludes>
                                </filter>
                            </filters>
                        </configuration>
                    </execution>
                </executions>
            </plugin>

        </plugins>
        <finalName>presto-clickhouse-0.223</finalName>
    </build>

</project>

④:打包上傳

將上述修改好的項目打成jar
在presto安裝目錄的plugin目錄下新建clickhouse目錄
mkdir /opt/soft/presto-server-0.223/plugin/clickhouse
將打好的jar上傳至該目錄
然后在catalog下新建clickhouse.properties

vim /opt/soft/presto-server-0.223/etc/catalog/clickhouse.properties


#寫入clickhouse的連接信息
connector.name=clickhouse
connection-url=jdbc:clickhouse://ip:8123
connection-user=
connection-password=

然后前臺啟動presto

bin/launcher run 

如果出現(xiàn)server started證明clickhouse Connector注冊成功

image.png

下面用客戶端測試
java -jar presto-cli-0.224-executable.jar --server localhost:9000 --catalog clickhouse --schema test
執(zhí)行show tables;

image.png