linkis icon indicating copy to clipboard operation
linkis copied to clipboard

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

Open Keven0Liu opened this issue 1 year ago • 1 comments

Search before asking

  • [X] 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>= sqlerror

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?

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

Keven0Liu avatar Feb 27 '23 09:02 Keven0Liu