This is an automated email from the ASF dual-hosted git repository. lzljs3620320 pushed a commit to branch release-0.4 in repository https://gitbox.apache.org/repos/asf/incubator-paimon.git
commit 16e2eb84830d75e3c15a9df8539cca1b2db19f17 Author: s7monk <[email protected]> AuthorDate: Sun Apr 23 14:01:33 2023 +0800 [doc] add presto doc (#954) --- docs/content/engines/overview.md | 1 + docs/content/engines/presto.md | 97 ++++++++++++++++++++++++++++++++++++++++ docs/content/project/download.md | 6 +++ 3 files changed, 104 insertions(+) diff --git a/docs/content/engines/overview.md b/docs/content/engines/overview.md index 462baef32..ea546d955 100644 --- a/docs/content/engines/overview.md +++ b/docs/content/engines/overview.md @@ -39,5 +39,6 @@ Apache Spark and Apache Hive. | Spark | 3.3/3.2/3.1 | batch read, batch write, create/drop table, create/drop database | Projection, Filter | | Spark | 2.4 | batch read | Projection, Filter | | Trino | 388/358 | batch read, create/drop table, create/drop database | Projection, Filter | +| Presto | 0.236 and above | batch read | Projection, Filter | [Download Link]({{< ref "project/download#engine-jars" >}}) \ No newline at end of file diff --git a/docs/content/engines/presto.md b/docs/content/engines/presto.md new file mode 100644 index 000000000..3fadb6a57 --- /dev/null +++ b/docs/content/engines/presto.md @@ -0,0 +1,97 @@ +--- +title: "Presto" +weight: 5 +type: docs +aliases: +- /engines/presto.html +--- +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +This documentation is a guide for using Paimon in Presto. + +## Version + +Paimon currently supports Presto 0.236 and above. + +## Preparing Paimon Jar File + +{{< stable >}} + +Download the jar file with corresponding version. + +| Version | Jar | +|------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| +| [0.236,0.268) | [paimon-presto-0.236-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.236/{{< version >}}/paimon-presto-0.236-{{< version >}}.jar) | +| [0.268,0.273) | [paimon-presto-0.268-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.268/{{< version >}}/paimon-presto-0.268-{{< version >}}.jar) | +| [0.273,0.279] | [paimon-presto-0.273-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.273/{{< version >}}/paimon-presto-0.273-{{< version >}}.jar) | + +{{< /stable >}} + +{{< unstable >}} + +| Version | Jar | +|------------------|-------------------------------------------------------------------------------------------------------------------------------------------| +| [0.236,0.268) | [paimon-presto-0.236-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.236/{{< version >}}/) | +| [0.268,0.273) | [paimon-presto-0.268-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.268/{{< version >}}/) | +| [0.273,0.279] | [paimon-presto-0.273-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.273/{{< version >}}/) | + +{{< /unstable >}} + +You can also manually build bundled jar from the source code. + +To build from source code, [clone the git repository]({{< github_repo >}}). + +Build bundled jar with the following command. + +``` +mvn clean install -DskipTests +``` + +You can find Presto connector jar in `./paimon-presto/paimon-presto-<presto-version>/target/paimon-presto-*.jar`. + +Then, copy `paimon-presto-*.jar and flink-shaded-hadoop-*-uber-*.jar` to plugin/paimon. + +## Configure Paimon Catalog + +Catalogs are registered by creating a catalog properties file in the etc/catalog directory. For example, create etc/catalog/paimon.properties with the following contents to mount the paimon connector as the paimon catalog: + +``` +connector.name=paimon +warehouse=file:/tmp/warehouse +``` + +If you are using HDFS, choose one of the following ways to configure your HDFS: + +- set environment variable HADOOP_HOME. +- set environment variable HADOOP_CONF_DIR. +- configure fs.hdfs.hadoopconf in the properties. + +You can configure kerberos keytag file when using KERBEROS authentication in the properties. + +``` +security.kerberos.login.principal=hadoop-user +security.kerberos.login.keytab=/etc/presto/hdfs.keytab +``` + +## Query + +``` +SELECT * FROM paimon.default.MyTable +``` \ No newline at end of file diff --git a/docs/content/project/download.md b/docs/content/project/download.md index bd9c1f118..83e4ce84e 100644 --- a/docs/content/project/download.md +++ b/docs/content/project/download.md @@ -47,6 +47,9 @@ This documentation is a guide for downloading Paimon Jars. | Hive 2.2 | [paimon-hive-connector-2.2-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-hive-connector-2.2/{{< version >}}/) | | Hive 2.1 | [paimon-hive-connector-2.1-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-hive-connector-2.1/{{< version >}}/) | | Hive 2.1-cdh-6.3 | [paimon-hive-connector-2.1-cdh-6.3-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-hive-connector-2.1-cdh-6.3/{{< version >}}/) | +| Presto 0.236 | [paimon-presto-0.236-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.236/{{< version >}}/) | +| Presto 0.268 | [paimon-presto-0.268-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.268/{{< version >}}/) | +| Presto 0.273 | [paimon-presto-0.273-{{< version >}}.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-presto-0.273/{{< version >}}/) | {{< /unstable >}} @@ -67,6 +70,9 @@ This documentation is a guide for downloading Paimon Jars. | Hive 2.2 | [paimon-hive-connector-2.2-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-hive-connector-2.2/{{< version >}}/paimon-hive-connector-2.2-{{< version >}}.jar) | | Hive 2.1 | [paimon-hive-connector-2.1-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-hive-connector-2.1/{{< version >}}/paimon-hive-connector-2.1-{{< version >}}.jar) | | Hive 2.1-cdh-6.3 | [paimon-hive-connector-2.1-cdh-6.3-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-hive-connector-2.1-cdh-6.3/{{< version >}}/paimon-hive-connector-2.1-cdh-6.3-{{< version >}}.jar) | +| Presto 0.236 | [paimon-presto-0.236-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.236/{{< version >}}/paimon-presto-0.236-{{< version >}}.jar) | +| Presto 0.268 | [paimon-presto-0.268-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.268/{{< version >}}/paimon-presto-0.268-{{< version >}}.jar) | +| Presto 0.273 | [paimon-presto-0.273-{{< version >}}.jar](https://repo.maven.apache.org/maven2/org/apache/paimon/paimon-presto-0.273/{{< version >}}/paimon-presto-0.273-{{< version >}}.jar) | {{< /stable >}}
