gistfile1.txt

{"offset":0,"size":0,"pageNum":0,"step":0,"dagId":"69aa185218e9452d872ed1f5413601ec","dagName":"MDB","dagDesc":"","dagOwner":"admin","dagFlag":null,"startDate":null,"endDate":null,"updateDate":null,"dagStatus":"7","dagParam":{},"remark":null,"tasks":[{"offset":0,"size":0,"pageNum":0,"step":0,"taskId":"2bb41bdff72349ee896d262a03ece268","dagId":"69aa185218e9452d872ed1f5413601ec","taskName":"MDB","parentId":"72b421d6a87742879b56f4bf294fcf73","taskType":"multiTable_convert","taskDesc":null,"taskOwner":null,"startDate":null,"endDate":null,"taskParam":{"relationType":"内联","positionType":"deal","name":"多表关联","treeData":[{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo3","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo3-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo3","name":"mm","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo3-mm"}],"name":"demo3","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo3"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","isRelate":"不关联","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","isRelate":"不关联","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"sex","position":"3","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-sex"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","isRelate":"不关联","name":"age","position":"4","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-age"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"department","position":"5","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-department"}],"name":"student0","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student","name":"age","position":"3","type":"int(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student-age"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student","name":"score","position":"4","type":"int(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student-score"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student","name":"gender","position":"5","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student-gender"}],"name":"demo1student","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo1student"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student","name":"age","position":"3","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student-age"}],"name":"student","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student2","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student2-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student2","name":"id1","position":"2","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student2-id1"}],"name":"student2","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student2"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student1","isRelate":"id","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student1-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student1","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student1-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student1","name":"age","position":"3","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student1-age"}],"name":"student1","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student1"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"id","position":"1","type":"int(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"age","position":"3","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-age"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"id1","position":"4","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-id1"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"name1","position":"5","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-name1"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student4","name":"age1","position":"6","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4-age1"}],"name":"student4","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student4"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student3","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student3-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student3","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student3-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student3","name":"age","position":"3","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student3-age"}],"name":"student3","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student3"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo2","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo2-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-demo2","name":"score","position":"2","type":"int(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo2-score"}],"name":"demo2","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-demo2"}]},"remark":null,"deleteFlag":null,"posTop":426,"posLeft":526},{"offset":0,"size":0,"pageNum":0,"step":0,"taskId":"5b682b8dad6c456695b98b8973745b82","dagId":"69aa185218e9452d872ed1f5413601ec","taskName":"MDB","parentId":"2bb41bdff72349ee896d262a03ece268","taskType":"DB","taskDesc":null,"taskOwner":null,"startDate":null,"endDate":null,"taskParam":{"dataBaseMsg":{"owner":"root","offset":0,"positionType":1,"ip":"10.160.32.5","dbName":"test_ww","dbType":"mysql","pageNum":0,"password":"Pass1234","size":0,"port":"3306","name":"mysql_环境_target","step":0,"id":"d25223f24dd04f61aeeef8e2fe39859d","businessType":0,"createDate":"2020-03-31T10:43:55.965+0000","username":"root"},"positionType":"target","selectedRowKeys":["d25223f24dd04f61aeeef8e2fe39859d-student2-id","d25223f24dd04f61aeeef8e2fe39859d-student2"],"dataType":5,"selectedRows":[{"parent":"d25223f24dd04f61aeeef8e2fe39859d-student2","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"d25223f24dd04f61aeeef8e2fe39859d-student2-id"},{"children":[{"parent":"d25223f24dd04f61aeeef8e2fe39859d-student2","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"d25223f24dd04f61aeeef8e2fe39859d-student2-id"},{"parent":"d25223f24dd04f61aeeef8e2fe39859d-student2","name":"id1","position":"2","type":"int(11)","isLeaf":true,"key":"d25223f24dd04f61aeeef8e2fe39859d-student2-id1"}],"name":"student2","position":"","type":"","isLeaf":false,"key":"d25223f24dd04f61aeeef8e2fe39859d-student2"}],"name":"DB","sourceName":"mysql_环境_target","fieldsMsg":[{"tableLocation":"hdfs://chaonao06:8020/user/hive/warehouse/test.db/student2","field":[{"parent":"620266fc5add47ceae242596e0c9d696-student2","name":"age","position":"4","type":"int","isLeaf":true,"key":"620266fc5add47ceae242596e0c9d696-student2-age"},{"parent":"620266fc5add47ceae242596e0c9d696-student2","name":"department","position":"5","type":"string","isLeaf":true,"key":"620266fc5add47ceae242596e0c9d696-student2-department"},{"parent":"620266fc5add47ceae242596e0c9d696-student2","name":"id","position":"1","type":"int","isLeaf":true,"key":"620266fc5add47ceae242596e0c9d696-student2-id"},{"parent":"620266fc5add47ceae242596e0c9d696-student2","name":"name","position":"2","type":"string","isLeaf":true,"key":"620266fc5add47ceae242596e0c9d696-student2-name"},{"parent":"620266fc5add47ceae242596e0c9d696-student2","name":"sex","position":"3","type":"string","isLeaf":true,"key":"620266fc5add47ceae242596e0c9d696-student2-sex"}],"tableName":"student2"}]},"remark":null,"deleteFlag":null,"posTop":389,"posLeft":829},{"offset":0,"size":0,"pageNum":0,"step":0,"taskId":"72b421d6a87742879b56f4bf294fcf73","dagId":"69aa185218e9452d872ed1f5413601ec","taskName":"MDB","parentId":null,"taskType":"DB","taskDesc":null,"taskOwner":null,"startDate":null,"endDate":null,"taskParam":{"dataBaseMsg":{"owner":"root","offset":0,"positionType":0,"ip":"10.160.32.5","dbName":"test_ww","dbType":"mysql","pageNum":0,"password":"Pass1234","size":0,"port":"3306","name":"mysql_环境_source","step":0,"id":"fd7cf41ae6fd4f05a50163d62ed55f05","businessType":0,"createDate":"2020-03-31T10:42:51.436+0000","username":"root"},"positionType":"source","selectedRowKeys":["fd7cf41ae6fd4f05a50163d62ed55f05-student0-id","fd7cf41ae6fd4f05a50163d62ed55f05-student0"],"dataType":"hive","selectedRows":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-id"},{"children":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"sex","position":"3","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-sex"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"age","position":"4","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-age"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"department","position":"5","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-department"}],"name":"student0","position":"","type":"","isLeaf":false,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0"}],"name":"DB","sourceName":"mysql_环境_source","fieldsMsg":[{"field":[{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"id","position":"1","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-id"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"name","position":"2","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-name"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"sex","position":"3","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-sex"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"age","position":"4","type":"int(11)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-age"},{"parent":"fd7cf41ae6fd4f05a50163d62ed55f05-student0","name":"department","position":"5","type":"varchar(255)","isLeaf":true,"key":"fd7cf41ae6fd4f05a50163d62ed55f05-student0-department"}],"tableName":"student0"}]},"remark":null,"deleteFlag":null,"posTop":428,"posLeft":357}],"connectors":[{"dagId":"69aa185218e9452d872ed1f5413601ec","sourceTaskId":"2bb41bdff72349ee896d262a03ece268","targetTaskId":"5b682b8dad6c456695b98b8973745b82","anchors":null,"color":null},{"dagId":"69aa185218e9452d872ed1f5413601ec","sourceTaskId":"72b421d6a87742879b56f4bf294fcf73","targetTaskId":"2bb41bdff72349ee896d262a03ece268","anchors":null,"color":null}]}