hi，godfrey： Thanks for your reply 1. I have seen the -u parameter, but my sql file may not only include 'insert into select ....', but also SET, DDL, etc.
2. I may not have noticed this issue. I took a look at this issue. I think this issue may have some problems. For example, he finally called the CliClient.callCommand method. But I think that many options in callCommand are not completely suitable for sql files, such as HELP, CLEAR, SELECT, etc. The select operation opens a window to display the results, obviously this is not suitable for executing sql files godfrey he <godfre...@gmail.com> 于2020年7月29日周三 上午9:56写道： > hi Jun, > > Currently, sql client has supported -u option, just like: > ./bin/sql-client.sh embedded -u "insert_statement". > > There is already a JIRA [1] that wants to support -f option > > [1] https://issues.apache.org/jira/browse/FLINK-12828 > > Best, > Godfrey > > Jun Zhang <zhangjunemail...@gmail.com> 于2020年7月29日周三 上午9:22写道： > >> I want to execute some flink sql batch jobs regularly, such as 'insert >> into >> select .....', but I can't find a suitable method so far, so reference >> hive, I changed the source code and add a '--filename' parameter so >> that we can execute a sql file. >> >> like this: >> >> /home/flink/bin/sql-client.sh embedded -f flink.sql >> >> what about any ideas or plans for this feature community? >> >
