[Bug]: The catalog cannot be used properly when querying based on Amoro0.6.0+Kyuubi1.8.1+Flink

[liuzyou6]

What happened?

when I execute query at Amoro terminal based on Amoro0.6.0+Kyuubi1.8.1+Flink, occurs an error like this, but on kyuubi, this query is right

Affects Versions

0.6.0

What engines are you seeing the problem on?

AMS

How to reproduce

create catalog on Amoro

config the item of kyuubi.engine.session.initialize.sql in kyuubi-default.conf

execute query on amoro terminal, you can see the error. This is probably because FLink and Spark have different syntax when using catalog

Relevant log output

No response

Anything else

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct