linkis icon indicating copy to clipboard operation
linkis copied to clipboard

[Feature][Entrance] run count hql needs to be removed limit

Open sjgllgh opened this issue 2 years ago • 3 comments

Search before asking

  • [X] I had searched in the issues and found no similar feature requirement.

Problem Description

When I execute the count statement using the hive engine, automatically add a limit 5000,eg:

SCRIPT CODE select count(*) from default.test limit 5000; SCRIPT CODE This syntax will increase SQL time consumption

Description

change category: linkis-computation-governance/linkis-entrance/src/main/scala/org/apache/linkis/entrance/interceptor/impl/Explain.scala add: Add restrictions and exclude count syntax when determining whether SQL needs to add limits

Use case

No response

Solutions

No response

Anything else

No response

Are you willing to submit a PR?

  • [X] Yes I am willing to submit a PR!

sjgllgh avatar Sep 01 '23 08:09 sjgllgh

:blush: Welcome to the Apache Linkis community!!

We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context. We will be here shortly.

If you are interested in contributing to our website project, please let us know! You can check out our contributing guide on :point_right: How to Participate in Project Contribution.

Community

WeChat Assistant WeChat Public Account

Mailing Lists

Name Description Subscribe Unsubscribe Archive
[email protected] community activity information subscribe unsubscribe archive

github-actions[bot] avatar Sep 01 '23 08:09 github-actions[bot]

This prevents slow queries when querying large amounts of data. There are parameters in the code to control the removal of this restriction.

aiceflower avatar Sep 05 '23 03:09 aiceflower

Only the count syntax needs to remove the limit restriction. This type does not have parameter control. If so, please let me know

sjgllgh avatar Sep 08 '23 05:09 sjgllgh