mysql - 如何将复杂的 JSON 批量上传到 MySQL

Question

我有一个 JSON 文件，我正在尝试将其批量上传到 MySql。该文件约为50GB。是否有一种简单的方法可以将所有数据导入 MySql？我尝试在 youtube 上观看有关如何执行此操作的视频，但所有教程都是针对没有此类嵌套数据的超级简单 json 数据。任何帮助都会很棒。这是一个示例，因此您可以查看它的结构：

{
  "PatentData": [


{
  "patentCaseMetadata": {
    "applicationNumberText": {
      "value": "16315092",
      "electronicText": "16315092"
    },
    "filingDate": "2019-07-03",
    "applicationTypeCategory": "Utility",
    "partyBag": {
      "applicantBagOrInventorBagOrOwnerBag": [
        {
          "applicant": [
            {
              "contactOrPublicationContact": [
                {
                  "name": { "personNameOrOrganizationNameOrEntityName": [ { "organizationStandardName": { "content": [ "SEB S.A." ] } } ] },
                  "cityName": "ECULLY",
                  "geographicRegionName": {
                    "value": "",
                    "geographicRegionCategory": "STATE"
                  },
                  "countryCode": "FR"
                }
              ]
            }
          ]
        },
        {
          "inventorOrDeceasedInventor": [
            {
              "contactOrPublicationContact": [
                {
                  "name": {
                    "personNameOrOrganizationNameOrEntityName": [
                      {
                        "personStructuredName": {
                          "firstName": "Johan",
                          "middleName": "",
                          "lastName": "SABATTIER"
                        }
                      }
                    ]
                  },
                  "cityName": "Mornant",
                  "geographicRegionName": {
                    "value": "",
                    "geographicRegionCategory": "STATE"

最终目标是将 JSON 文件保存在 MySQL 数据库中，格式如下：

Name | Address | State | Country ... | Abstract
Tim  - 23 North-  TX   - US      ... | The tissue...
Tom  - 33 North-  TX   - US      ... | The engineer...
Kim  - 78 North-  TX   - US      ... | The lung...
Bob  - 123 North-  TX   - US      ... | The tissue...
Rob  - 93 North-  TX   - US      ... | The scope...

标签： mysqlsqljsonbigdatamysql-workbench