Open cydenghua opened 1 year ago
streamis-job-manager
运行从一个mysql表读数据写到另外一个mysql表,如: CREATE TABLE IF NOT EXISTS cold_45a_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_modeltest','username' = 'pieeco','password' = 'pi-7988100');
CREATE TABLE IF NOT EXISTS cold_45t_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_dh','username' = 'pieeco','password' = 'pi-7988100');
INSERT INTO cold_45t_mod_x7 SELECT column_lgbm,column_yyzzbh,column_dwmc FROM cold_45b_mod_x7;
任务运行成功,但是最后任务显示失败。
linux
CREATE TABLE IF NOT EXISTS cold_45a_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_modeltest','username' = 'pieeco','password' = 'pi-7988100');
No response
同样的问题,请问有解决吗?
I use flink have no problem
I use flink CDC
Search before asking
Streamis Component
streamis-job-manager
What happened + What you expected to happen
运行从一个mysql表读数据写到另外一个mysql表,如: CREATE TABLE IF NOT EXISTS cold_45a_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_modeltest','username' = 'pieeco','password' = 'pi-7988100');
CREATE TABLE IF NOT EXISTS cold_45t_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_dh','username' = 'pieeco','password' = 'pi-7988100');
INSERT INTO cold_45t_mod_x7 SELECT column_lgbm,column_yyzzbh,column_dwmc FROM cold_45b_mod_x7;
任务运行成功,但是最后任务显示失败。
Relevent platform
linux
Reproduction script
CREATE TABLE IF NOT EXISTS cold_45a_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_modeltest','username' = 'pieeco','password' = 'pi-7988100');
CREATE TABLE IF NOT EXISTS cold_45t_mod_x7(column_lgbm String, column_yyzzbh String, column_dwmc String) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://101.30.9.14:3306/dmp','table-name' = 'tb_dh','username' = 'pieeco','password' = 'pi-7988100');
INSERT INTO cold_45t_mod_x7 SELECT column_lgbm,column_yyzzbh,column_dwmc FROM cold_45b_mod_x7;
Anything else
No response
Are you willing to submit a PR?