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/02/28 04:43:54 UTC

[GitHub] [incubator-linkis] peacewong opened a new issue #1573: [Feature] [Entrance]Support to remove the limit limit added by default in sql according to the configured Creator

peacewong opened a new issue #1573:
URL: https://github.com/apache/incubator-linkis/issues/1573


   ### 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
   
   Now, when submitting sql/hql by default, the limit of 5000 will be added. However, for many non-interactive analysis scenarios, the limit limit should not be added by default, otherwise, the user task data will be wrong.
   
   现在默认提交sql/hql都会加上limit 5000的限制,但是对于很多非交互式分析的场景来说,默认不应该加入limit限制,不然会造成用户任务数据有误。只有对特定场景加上5000,比如Scriptis页面使用,为了更好的性能。
   
   ```sql
   select * from users 
   ## Limit will be added after entrance
   select * from users limit 5000
   ```
   
   ### Description
   
   Adding parameters can configure only a specific Creator to add a limit limit(增加参数可以配置只有特定的Creator才加上limit限制)
   
   ### Use case
   
   _No response_
   
   ### solutions
   
   Add the following parameters, only the Creator configured in it has a limit limit(增加以下参数,只有配置在里面的Creator才有limit限制)
   `val SQL_LIMIT_CREATOR = CommonVars("linkis.sql.limit.creator", "IDE,Visualis")`
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [X] 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