Thank you Jia Fan for your reply
Yes, the variable substitution feature is available in SeaTunnel Engine. If
the job were created manually, there would be no issues. However, the
problem arises when a job is created through SeaTunnel Web.
In SeaTunnel Web, how can I create a source step with a query like "SELECT
name, age FROM test.test_table WHERE age > ${ageParam}"? Do you think this
is possible through the SeaTunnel Web?
Thanks & Regards
Mohammad Arshad
On Thu, Aug 29, 2024 at 7:32 AM Jia Fan <[email protected]> wrote:
> One way is to use our config variable feature in
>
> https://seatunnel.apache.org/docs/2.3.7/concept/config#config-variable-substitution
> .
>
> Arshad, Mohammad <[email protected]> 于2024年8月28日周三 19:27写道：
>
> > 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
> >
> >
>
