一、源端
    1、ConsumerKafka

    1. @param hostList
    2. @param topicName
    3. @param groupId

    2、JoltTransformJSON

    1. @param jolt transform
      1. 宁夏
        1. 单条Json解析规则示例: ```json // 实际数据 { “goldenId”:1603782, “pointTime”:”2022-01-07 16:06:22”, “tagName”:”QSFJ.NX_GD_QSF_FJ_P1_L3_032_AI0002”, “valueDouble”:1.600000023841858, “valueInt”:0, “valueType”:”Double” }

    // 解析规则 [{ “operation”: “shift”, “spec”: { “pointTime”: “pointTime”, “valueDouble”: “valueDouble”, “tagName”: “tagName” } }]

    // 解析结果 { “pointTime”: “1970-01-01 00:00:00”, “valueDouble”: 1.0, “tagName”: “GDNXFD_P1_L1_A0921” }

    1. 2. 列表Json模式解析示例:
    2. ```json
    3. // 实际数据
    4. {
    5. "dataCount":29,
    6. "data":[
    7. {
    8. "key": "AAAAAAA",
    9. "dataType": 10,
    10. "time": "2021-01-01 00:00:00",
    11. "data":66.983154296875
    12. },{
    13. "key":"BBBBBBB",
    14. "dataType":10,
    15. "time":"2021-01-01 00:00:01",
    16. "data":66.91868591308594
    17. }
    18. ]
    19. }
    20. // 解析规则
    21. [{
    22. "operation": "shift",
    23. "spec": {
    24. "data": {
    25. "*": {
    26. "time": "result[#2].pointTime",
    27. "data": "result[#2].valueDouble",
    28. "key": "result[#2].tagName"
    29. }
    30. }
    31. }
    32. }]
    33. // 解析结果
    34. {
    35. "result": [
    36. {
    37. "pointTime": "2021-01-01 00:00:00",
    38. "valueDouble": 66.983154296875,
    39. "tagName": "AAAAAAA"
    40. },
    41. {
    42. "pointTime": "2021-01-01 00:00:00",
    43. "valueDouble": 66.91868591308594,
    44. "tagName": "BBBBBBB"
    45. }
    46. ]
    47. }
    1. 3. othre
    1. [{
    2. "operation": "shift",
    3. "spec": {
    4. "Result": {
    5. "*": {
    6. "*": {
    7. "$1": "&2[#2].tagName",
    8. "Time": "&2[#2].pointTime",
    9. "Value": "&2[#2].valueDouble"
    10. }
    11. }
    12. }
    13. }
    14. }]
    15. [{
    16. "operation": "shift",
    17. "spec": {
    18. "Result": {
    19. "*": {
    20. "TagFullName": "&2[#2].tagName",
    21. "Time": "&2[#2].pointTime",
    22. "Value": "&2[#2].valueDouble"
    23. }
    24. }
    25. }
    26. }]

    二、目标端
    1、NIFI Flow
    2、ExecuteGroovyScript

    1. @param TDUrl(必填)
    2. @param DBName(必填)
    3. @param STBName(可选,当且仅当子表已存在)
    4. @param model json的模式(single|list)

    三、附页
    1、附1页