videoods.topic.sql 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  1. -- Task: imp.topic ID: 1001894077 Type: DI
  2. {
  3. "extend":{
  4. "mode":"wizard",
  5. "resourceGroup":"group_42901"
  6. },
  7. "transform":false,
  8. "type":"job",
  9. "version":"2.0",
  10. "steps":[
  11. {
  12. "stepType":"mysql",
  13. "copies":1,
  14. "parameter":{
  15. "envType":1,
  16. "column":[
  17. "id",
  18. "name",
  19. "introduction",
  20. "image_1_1_path",
  21. "image_16_9_path",
  22. "image_9_16_path",
  23. "audit_status",
  24. "is_participatory",
  25. "distribution_state",
  26. "create_uid",
  27. "hot_score",
  28. "participant_num",
  29. "data_status",
  30. "create_time",
  31. "update_time"
  32. ],
  33. "tableComment":"社区-话题",
  34. "where":"",
  35. "connection":[
  36. {
  37. "datasource":"longvide_read",
  38. "table":[
  39. "topic"
  40. ]
  41. }
  42. ],
  43. "splitPk":"id"
  44. },
  45. "name":"Reader",
  46. "gui":{
  47. "x":100,
  48. "y":100
  49. },
  50. "category":"reader"
  51. },
  52. {
  53. "stepType":"odps",
  54. "copies":1,
  55. "parameter":{
  56. "truncate":true,
  57. "envType":1,
  58. "datasource":"odps_first",
  59. "column":[
  60. "id",
  61. "name",
  62. "introduction",
  63. "image_1_1_path",
  64. "image_16_9_path",
  65. "image_9_16_path",
  66. "audit_status",
  67. "is_participatory",
  68. "distribution_state",
  69. "create_uid",
  70. "hot_score",
  71. "participant_num",
  72. "data_status",
  73. "create_time",
  74. "update_time"
  75. ],
  76. "emptyAsNull":false,
  77. "tableComment":"社区-话题",
  78. "table":"topic"
  79. },
  80. "name":"Writer",
  81. "gui":{
  82. "x":100,
  83. "y":200
  84. },
  85. "category":"writer"
  86. },
  87. {
  88. "copies":1,
  89. "parameter":{
  90. "nodes":[],
  91. "edges":[],
  92. "groups":[],
  93. "version":"2.0"
  94. },
  95. "name":"Processor",
  96. "gui":{
  97. "x":100,
  98. "y":300
  99. },
  100. "category":"processor"
  101. }
  102. ],
  103. "order":{
  104. "hops":[
  105. {
  106. "from":"Reader",
  107. "gui":{
  108. "sourceAnchor":1,
  109. "targetAnchor":0
  110. },
  111. "to":"Writer"
  112. }
  113. ]
  114. },
  115. "setting":{
  116. "errorLimit":{
  117. "record":""
  118. },
  119. "locale":"zh_CN",
  120. "speed":{
  121. "throttle":false,
  122. "concurrent":2
  123. }
  124. }
  125. }
  126. -- Task: imp.topic ID: 1001894077 Type: DI
  127. {
  128. "extend":{
  129. "mode":"wizard",
  130. "resourceGroup":"group_42901"
  131. },
  132. "transform":false,
  133. "type":"job",
  134. "version":"2.0",
  135. "steps":[
  136. {
  137. "stepType":"mysql",
  138. "copies":1,
  139. "parameter":{
  140. "envType":1,
  141. "column":[
  142. "id",
  143. "name",
  144. "introduction",
  145. "image_1_1_path",
  146. "image_16_9_path",
  147. "image_9_16_path",
  148. "audit_status",
  149. "is_participatory",
  150. "distribution_state",
  151. "create_uid",
  152. "hot_score",
  153. "participant_num",
  154. "data_status",
  155. "create_time",
  156. "update_time"
  157. ],
  158. "tableComment":"社区-话题",
  159. "where":"",
  160. "connection":[
  161. {
  162. "datasource":"longvide_read",
  163. "table":[
  164. "topic"
  165. ]
  166. }
  167. ],
  168. "splitPk":"id"
  169. },
  170. "name":"Reader",
  171. "gui":{
  172. "x":100,
  173. "y":100
  174. },
  175. "category":"reader"
  176. },
  177. {
  178. "stepType":"odps",
  179. "copies":1,
  180. "parameter":{
  181. "truncate":true,
  182. "envType":1,
  183. "datasource":"odps_first",
  184. "column":[
  185. "id",
  186. "name",
  187. "introduction",
  188. "image_1_1_path",
  189. "image_16_9_path",
  190. "image_9_16_path",
  191. "audit_status",
  192. "is_participatory",
  193. "distribution_state",
  194. "create_uid",
  195. "hot_score",
  196. "participant_num",
  197. "data_status",
  198. "create_time",
  199. "update_time"
  200. ],
  201. "emptyAsNull":false,
  202. "tableComment":"社区-话题",
  203. "table":"topic"
  204. },
  205. "name":"Writer",
  206. "gui":{
  207. "x":100,
  208. "y":200
  209. },
  210. "category":"writer"
  211. },
  212. {
  213. "copies":1,
  214. "parameter":{
  215. "nodes":[],
  216. "edges":[],
  217. "groups":[],
  218. "version":"2.0"
  219. },
  220. "name":"Processor",
  221. "gui":{
  222. "x":100,
  223. "y":300
  224. },
  225. "category":"processor"
  226. }
  227. ],
  228. "order":{
  229. "hops":[
  230. {
  231. "from":"Reader",
  232. "gui":{
  233. "sourceAnchor":1,
  234. "targetAnchor":0
  235. },
  236. "to":"Writer"
  237. }
  238. ]
  239. },
  240. "setting":{
  241. "errorLimit":{
  242. "record":""
  243. },
  244. "locale":"zh_CN",
  245. "speed":{
  246. "throttle":false,
  247. "concurrent":2
  248. }
  249. }
  250. }