You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by si...@apache.org on 2023/02/08 02:20:32 UTC
[pinot] branch master updated: adding inequality join condition test and specifically exclude unsupported syntax (#10242)
This is an automated email from the ASF dual-hosted git repository.
siddteotia pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/pinot.git
The following commit(s) were added to refs/heads/master by this push:
new 5e0a8dbaa1 adding inequality join condition test and specifically exclude unsupported syntax (#10242)
5e0a8dbaa1 is described below
commit 5e0a8dbaa11986079c8801b9f423fc49b5681205
Author: Rong Rong <ro...@apache.org>
AuthorDate: Tue Feb 7 18:20:25 2023 -0800
adding inequality join condition test and specifically exclude unsupported syntax (#10242)
Co-authored-by: Rong Rong <ro...@startree.ai>
---
.../src/test/resources/queries/TableExpressions.json | 16 ++++++++++++++++
1 file changed, 16 insertions(+)
diff --git a/pinot-query-runtime/src/test/resources/queries/TableExpressions.json b/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
index 765cd687e0..d5e8085bad 100644
--- a/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
+++ b/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
@@ -101,6 +101,12 @@
{ "sql": "SELECT strCol FROM {tbl1} GROUP BY strCol, intCol" },
{ "sql": "SELECT strCol, intCol FROM {tbl1} GROUP BY strCol, intCol" },
{ "sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.strCol > b.strCol1" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.intCol = b.intCol WHERE a.strCol > b.strCol1" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.intCol = b.intCol AND a.strCol > b.strCol1" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.strCol BETWEEN b.strCol1 AND b.strCol2" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.intCol = b.intCol WHERE a.strCol BETWEEN b.strCol1 AND b.strCol2" },
+ { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON a.intCol = b.intCol AND a.strCol BETWEEN b.strCol1 AND b.strCol2" },
{ "sql": "SELECT strCol, b.strCol2, (sum(a.intCol) * b.intCol) AS colAlias FROM {tbl1} a INNER JOIN {tbl2} b ON a.strCol = b.strCol1 GROUP BY strCol, b.strCol2, b.intCol" },
{ "sql": "SELECT MOD(b.intCol, 2), sum(a.intCol) AS colAlias FROM {tbl1} a INNER JOIN {tbl2} b ON a.strCol = b.strCol1 GROUP BY MOD(b.intCol, 2)" },
{ "sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol HAVING SUM(intCol) > 3" },
@@ -115,6 +121,16 @@
"ignored": true,
"comment": "correlation is not supported. SOME is only supported if expand = false",
"sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol HAVING AVG(intCol) >= ANY (SELECT AVG(intCol) FROM {tbl1} GROUP BY strCol)"
+ },
+ {
+ "ignored": true,
+ "comments": "where clause inequality join condition is not supported",
+ "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b WHERE a.intCol > b.intCol"
+ },
+ {
+ "ignored": true,
+ "comments": "where clause inequality join condition is not supported yet",
+ "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b WHERE a.strCol BETWEEN b.strCol1 AND b.strCol2"
}
]
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org