You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@linkis.apache.org by GitBox <gi...@apache.org> on 2022/03/03 03:33:32 UTC
[GitHub] [incubator-linkis] Fuu3214 opened a new issue #1594: [Feature] [entrance] remove 'limit' in sql for non-interactive jobs
Fuu3214 opened a new issue #1594:
URL: https://github.com/apache/incubator-linkis/issues/1594
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-linkis/issues) and found no similar feature requirement.
### Problem Description
Linkis automatically added "limit 5000" for all sqls. This releases computation overhead for interactive jobs. But for non-interactive jobs especially batch jobs, we‘d like to receive all of the results.
为了降低交互式任务负载，Linkis为每一个SQL自动添加 limit 5000，但是对于非交互式任务，需要返回全部结果
### Description
remove 'limit' in sql for non-interactive jobs
非交互式任务去掉‘limit’
### Use case
Submit a SQL with more than 5000 rows result via non-interactive front-end(not scriptis). Results-set returned by linkis should be more than 5000 rows.
非交互式前端提交结果超过5000行的sql，返回超过5000行诗句
### solutions
Identify non-interactive jobs by user-creator label or sourceMap and do not append limit in SQL.
通过user-creator label或sourceMap 识别非交互式任务，不添加‘limit’
### Anything else
_No response_
### Are you willing to submit a PR?
- [ ] Yes I am willing to submit a PR!
--
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@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@linkis.apache.org
For additional commands, e-mail: commits-help@linkis.apache.org
[GitHub] [incubator-linkis] peacewong closed issue #1594: [Feature] [entrance] remove 'limit' in sql for non-interactive jobs
Posted by GitBox <gi...@apache.org>.
peacewong closed issue #1594:
URL: https://github.com/apache/incubator-linkis/issues/1594
--
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: dev-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For additional commands, e-mail: dev-help@linkis.apache.org