[Bug] [SQL Task]Remove trailing semicolons from a SQL sentence.

[iamcaoxudong]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

If a SQL task only has one SQL sentence, then this line will not ended with a ";/n" or ";/r/n". Instead it just has a trailing ";". In this case we need to manually remove the trailing ";", or it may cause a syntax error in some JDBC implementations (e.g. Hive JDBC).

What you expected to happen

If a SQL task only contains one single line, then we need to manully remove the trailing ";"

How to reproduce

1. Create a SQL task that has only one line
   

2. Run this task, then we can see a syntax error in som JDBC implementations (below is the HIVE case)
   

Anything else

No response

Version

dev

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

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

[ruanwenjun]

If you only have one sql, you should remove the ; here.