Hi All,
I'm interested in creating a job that includes a conditional query, yet it
appears that this option is currently unavailable in SeaTunnel-Web.
To illustrate, suppose we have a test_table with fields name and age. My
objective is to transfer all records from test_table to another table, but only
for those entries where age is greater than 25.
At present, SeaTunnel-Web enables the creation of jobs with queries such as
“SELECT `name`, `age` FROM `test`.`test_table`”. However, it does not provide
an option for creating queries like
“SELECT `name`, `age` FROM `test`.`test_table` where `age` > 25” or “SELECT
`name`, `age` FROM `test`.`test_table` where `age` >$ {ageParam}”
Could there be something I'm overlooking? Are there any alternative methods to
accomplish this?
An attempt is made to add support for this feature at execution time as part of
the pull request at https://github.com/apache/seatunnel-web/pull/193.
However, it might be more efficient if the conditional query could be supported
directly at the job creation stage. Only some parameters to be changed at
execution time, not the whole query.
Does anyone have any ideas or suggestions on how to implement this feature?
Thanks & Regards
Mohammad Arshad
