You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by ma...@apache.org on 2022/12/04 22:14:06 UTC
[pinot-site] branch dev updated: Updated 'Joins using Trino or PrestoDB' section contents on landing page (#76)
This is an automated email from the ASF dual-hosted git repository.
mayanks pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/pinot-site.git
The following commit(s) were added to refs/heads/dev by this push:
new 767255b Updated 'Joins using Trino or PrestoDB' section contents on landing page (#76)
767255b is described below
commit 767255b74274c9440b671f65bf4caf5c4099da98
Author: Gaurav Joshi <68...@users.noreply.github.com>
AuthorDate: Sun Dec 4 14:14:01 2022 -0800
Updated 'Joins using Trino or PrestoDB' section contents on landing page (#76)
* Updated 'Joins using Trino or PrestoDB' section contents on landing page
* Updated 'Joins using Trino or PrestoDB' section contents on other pages
* Updated 'Joins using Trino or PrestoDB' section contents
* Updated links
---
website/docs/about/what_is_pinot.md | 2 +-
website/docs/user-guide/pql.md | 4 ++--
website/src/pages/index.js | 11 +++++++----
3 files changed, 10 insertions(+), 7 deletions(-)
diff --git a/website/docs/about/what_is_pinot.md b/website/docs/about/what_is_pinot.md
index 7b3a8cc..5681d3a 100644
--- a/website/docs/about/what_is_pinot.md
+++ b/website/docs/about/what_is_pinot.md
@@ -15,7 +15,7 @@ Pinot is designed to answer OLAP queries with low latency. It is suited in conte
## When should I not use it?
-Pinot is not a replacement for your database, nor a search engine. It addresses fast analytics on immutable data and it is not thought by design, to handle data updates or deletions. Joins are currently not supported, but this problem can be overcome by using [Trino](<(https://trino.io/)>) or [PrestoDB](<(https://prestodb.io/)>) for querying Pinot.
+Pinot is not a replacement for your database, nor a search engine. It addresses fast analytics on immutable data and it is not thought by design, to handle data updates or deletions. Apache Pinot supports dimension [lookup joins](https://docs.pinot.apache.org/users/user-guide-query/lookup-udf-join) currently. [Full SQL join](https://github.com/apache/pinot/issues/8260) support in Apache Pinot is [coming soon](https://startree.ai/blog/apache-pinot-native-join-support). In the interim, ful [...]
For more information about [Trino Pinot Connector](https://trino.io/docs/current/connector/pinot.html), see [Trino Pinot Integration](https://docs.pinot.apache.org/integrations/trino).
diff --git a/website/docs/user-guide/pql.md b/website/docs/user-guide/pql.md
index cf032aa..15fdf5f 100644
--- a/website/docs/user-guide/pql.md
+++ b/website/docs/user-guide/pql.md
@@ -7,14 +7,14 @@ draft: true
import Alert from '@site/src/components/Alert';
-PQL is a derivative of SQL derivative that supports selection, projection, aggregation, grouping aggregation. There is no support for Joins or Subqueries. Specifically, for Pinot:
+PQL is a derivative of SQL derivative that supports selection, projection, aggregation, grouping aggregation. There is no support for Subqueries. Specifically, for Pinot:
- Aggregations are computed in parallel
- Results of aggregations with large amounts of group keys (>1M) are approximated
## PQL Limitations
-PQL is only a derivative of SQL, and it does not support Joins nor Subqueries. In order to support them, we suggest to rely on [Trino](https://trino.io/) or [PrestoDB](https://prestodb.io/), although Subqueries are not completely supported by PrestoDB at the moment of writing.
+PQL is only a derivative of SQL and Apache Pinot supports dimension [lookup joins](https://docs.pinot.apache.org/users/user-guide-query/lookup-udf-join) currently. [Full SQL join](https://github.com/apache/pinot/issues/8260) support in Apache Pinot is [coming soon](https://startree.ai/blog/apache-pinot-native-join-support). In the interim, full SQL joins can be performed by querying Pinot via the [Trino](https://trino.io/) or [PrestoDB](https://prestodb.io/) connector.
## PQL Examples
diff --git a/website/src/pages/index.js b/website/src/pages/index.js
index 136bda3..93a6b44 100755
--- a/website/src/pages/index.js
+++ b/website/src/pages/index.js
@@ -94,14 +94,17 @@ const features = [
description: <>Horizontally scalable and fault tolerant</>,
},
{
- title: "Joins using Trino or PrestoDB",
+ title: "JOINS in Pinot",
icon: "shuffle",
description: (
<>
- Joins are currently not supported, but this problem can be
- overcome by using{" "}
+ Apache Pinot supports dimension{" "}
+ <Link to="https://docs.pinot.apache.org/users/user-guide-query/lookup-udf-join">lookup joins</Link> currently.{" "}
+ <Link to="https://github.com/apache/pinot/issues/8260">Full SQL join</Link> support in Apache Pinot is{" "}
+ <Link to="https://startree.ai/blog/apache-pinot-native-join-support">coming soon.</Link>{" "}
+ In the interim, full SQL joins can be performed by querying Pinot via the{" "}
<Link to="https://trino.io/">Trino</Link> or{" "}
- <Link to="https://prestodb.io/">PrestoDB</Link> for querying
+ <Link to="https://prestodb.io/">PrestoDB</Link> connector.
</>
),
},
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org