liunaijie commented on issue #6888:
URL: https://github.com/apache/seatunnel/issues/6888#issuecomment-2126466971
1. the gived config is not complete
it should be ( still ignore som config) :
```
source {
xxx {
result_table_name = "source_result"
....
}
}
transform {
sql {
query = ""
source_table_name = "source_result"
result_table_name = "sql_res1"
}
sql {
query = ""
source_table_name = "sql_res1"
result_table_name = "sql_res2" // your exception is this config
missing parameters
}
}
sink {
xxx {
source_table_name = "sql_res2"
......
}
}
```
2. in your second query, *you want query from sink table, this is not right.
you can only query from the source table.*
data flow is `source -> transform -> sink`
and also not support query with multiple table using like `join`
3. for your case, your can try (i am not sure it can work, just suggestion)
a. `select data.A as data.B from source`
b. using json tranform
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
