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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
