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

[sjgllgh]

Search before asking

• 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?

• Yes I am willing to submit a PR!

[github-actions]

😊 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
👉 How to Participate in Project Contribution.

Community

WeChat Assistant	WeChat Public Account

Mailing Lists

Name	Description	Subscribe	Unsubscribe	Archive
dev@linkis.apache.org	community activity information	subscribe	unsubscribe	archive

[aiceflower]

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

[sjgllgh]

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