[Bug] jdbc task cannot obtain the set variable value when the task takes a long time

[Keven0Liu]

Search before asking

• I searched the issues and found no similar issues.

Linkis Component

linkis-engineconnn-plugin

Steps to reproduce

1, create a jdbc job ,then publish to schedulis;
2, the jdbc job have set variable like below:
set yesterday= date_sub(current_date,1);
3, used variable like :
select * from xxx where usetime>= ${hiveconf:yesterday}
4, server get the code right.
select * from xxx where usetime>= ${hiveconf:yesterday}
5, but the final conversion sql is:
select * from xxx where usetime>=

Expected behavior

final conversion sql is:
select * from xxx where usetime>= date_sub(current_date,1)

Your environment

• Linkis version used: 1.1.1
• Environment name and version:
  • cdh-6.3.2
  • hive-2.1.1
  • spark-2.4 & 3.2
  • jdk 1.8.0_121

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
[email protected]	community activity information	subscribe	unsubscribe	archive