You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/06/17 08:55:29 UTC
[GitHub] [incubator-doris] BePPPower opened a new issue, #10217: [Feature] support table valued function.
BePPPower opened a new issue, #10217:
URL: https://github.com/apache/incubator-doris/issues/10217
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
A table-valued function (TVF) is a function that returns a relation or a set of rows. There are two types of TVFs :
- a TVF that can be specified in a FROM clause, e.g. range;
- a TVF that can be specified in SELECT/LATERAL VIEW clauses, e.g. explode.
Just like the definition of spark and clickhouse：
- spark: https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select-tvf.html.
- clickhouse: https://clickhouse.com/docs/en/sql-reference/table-functions. Currently Clickhouse only support from clause table function
The table valued function can be used to test our vector engines performance.
### Use case
The table valued function works like this：
MySQL [(none)]> select sum(number) from (select number from numbers("1000") where number < 10) as c;
+---------------+
| sum(number) |
+---------------+
| 45 |
+---------------+
That is: numbers("1000") returns a temporary table which only has one column named 'number' and it's row-values are from 0 to 1000.
### Related issues
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] yiguolei closed issue #10217: [Feature] support table valued function.
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #10217: [Feature] support table valued function.
URL: https://github.com/apache/doris/issues/10217
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org