How to apply variables in clickhouse sql Task db

[liusy-bd]

For example, I output the variable env: test in test_para, but in the ods sql task it becomes 'test' with double quotes

[liusy-bd]

hive sql also reports errors

[zhongjiajie]

hi @liusy-bd it seem not related to sdk but dolphinscheduler itself. Which version do you use in this case?

[liusy-bd]

你好@liusy-bd它似乎与sdk无关，而是dolphinscheduler本身。在这种情况下您使用哪个版本？

ds :3.1.8 pyds: 4.0.4

Do you have any ideas?

[zhongjiajie]

你好@liusy-bd它似乎与sdk无关，而是dolphinscheduler本身。在这种情况下您使用哪个版本？

ds :3.1.8 pyds: 4.0.4

Do you have any ideas?

I had check the related version, seems dolphinscheduler can not replace the table name and some of field name correctly. Could you add an issue to apache/dolphinscheduler?

[liusy-bd]

你好@liusy-bd它与 sdk 关联，而 dolphinscheduler 似乎本身。在这种情况下您使用哪个版本？

ds：3.1.8 pyds：4.0.4 你有什么想法？

我检查了相关版本，似乎dolphinscheduler无法正确替换表名和一些字段名。您可以向 apache/dolphinscheduler 添加问题吗？

Updated to dolphinscheduler！！！

https://github.com/apache/dolphinscheduler/issues/15457

[fuchanghai]

hi @liusy-bd maybe we can use !{} #15238 cc @zhongjiajie

[zhongjiajie]

hi @liusy-bd maybe we can use !{} #15238 cc @zhongjiajie

@fuchanghai Got it and thanks for you clarification, cc @liusy-bd and I would like to close this issue