对于hive分区表同步到mysql，为啥hive中的分区字段同步过去的都是null呢？

[ocean-zhc]

期待回复

[wdx-best]

我也遇到了这个问题，请问找到原因解决了吗？

[wdx-best]

https://blog.csdn.net/qq_46893497/article/details/111221503这个链接可以有点帮助

[dingxiaobo]

把需要的分区分区值，配置成常量即可

例如：

{
    "name": "hdfsreader",
    "parameter": {
        "path": "/user/hive/warehouse/mytable01/pt=20230215",
        "defaultFS": "hdfs://xxx:port",
        "column": [
            {
                "index": 0,
                "type": "long"
            },
            {
                "index": 1,
                "type": "boolean"
            },
            {
                "type": "string",
                "value": "20230215"
            },
            {
                "index": 2,
                "type": "double"
            }
        ],
        "fileType": "orc",
        "encoding": "UTF-8",
        "fieldDelimiter": ","
    }
}