seatunnel icon indicating copy to clipboard operation
seatunnel copied to clipboard

[Bug] [Seatunnel-web] transform:table name not found

Open llzzyy123 opened this issue 1 year ago • 4 comments

Search before asking

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

What happened

When integrating data using mysql jdbc in seatunnel web, the query section in the transform generated by the SQL module, select * from xxxx where xxx Error table name xxxx not found will be reported. May I ask how to solve it

SeaTunnel Version

2.3.3

SeaTunnel Config

1

Running Command

1

Error Exception

1

Zeta or Flink or Spark Version

No response

Java or Scala Version

No response

Screenshots

No response

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

llzzyy123 avatar Apr 19 '24 02:04 llzzyy123

创建同步任务-选择数据集成-选择source、sql、sink ,source连接sql连接sink,source选择表A(数据库中有此表),sql中输入select * from A where age<20 执行任务时报错,table name A not found ,选择这个sql模块时conf文件中会写入transform代码块,不知道这个功能是这样用的吗,还是没开发好呢?

llzzyy123 avatar Apr 19 '24 02:04 llzzyy123

我记得web端生成配置文件时,会随机生成result_table_name,这样会导致下游找不到表名,你可以看下运行时打印的配置文件,看下是不是result_table_name是一个随机的。 然后你可以看下source端有没有设置result_table_name的选项,把这个给一个固定值

liunaijie avatar Apr 22 '24 06:04 liunaijie

我记得web端生成配置文件时,会随机生成result_table_name,这样会导致下游找不到表名,你可以看下运行时打印的配置文件,看下是不是result_table_name是一个随机的。 然后你可以看下source端有没有设置result_table_name的选项,把这个给一个固定值 result_table_name是随机的,手动改可以,但是页面上貌似没有设置的地方

llzzyy123 avatar Apr 23 '24 05:04 llzzyy123

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

github-actions[bot] avatar May 24 '24 00:05 github-actions[bot]