测试数据

以下是操作准备的测试数据，以方法后续操作查询

backet: tutorial

{
      "tutorial": {
        "age": 46,
        "children": [
          {
            "age": 17,
            "fname": "Aiden",
            "gender": "m"
          },
          {
            "age": 2,
            "fname": "Bill",
            "gender": "f"
          }
        ],
        "email": "[email protected]",
        "fname": "Dave",
        "hobbies": [
          "golf",
          "surfing"
        ],
        "lname": "Smith",
        "relation": "friend",
        "title": "Mr.",
        "type": "contact"
      }
    },
    {
      "tutorial": {
        "age": 46,
        "children": [
          {
            "age": 17,
            "fname": "Xena",
            "gender": "f"
          },
          {
            "age": 2,
            "fname": "Yuri",
            "gender": "m"
          }
        ],
        "email": "[email protected]",
        "fname": "Earl",
        "hobbies": [
          "surfing"
        ],
        "lname": "Johnson",
        "relation": "friend",
        "title": "Mr.",
        "type": "contact"
      }
    },
    {
      "tutorial": {
        "age": 18,
        "children": null,
        "email": "[email protected]",
        "fname": "Fred",
        "hobbies": [
          "golf",
          "surfing"
        ],
        "lname": "Jackson",
        "relation": "coworker",
        "title": "Mr.",
        "type": "contact"
      }
    },
    {
      "tutorial": {
        "age": 20,
        "email": "[email protected]",
        "fname": "Harry",
        "lname": "Jackson",
        "relation": "parent",
        "title": "Mr.",
        "type": "contact"
      }
    },
    {
      "tutorial": {
        "age": 56,
        "children": [
          {
            "age": 17,
            "fname": "Abama",
            "gender": "m"
          },
          {
            "age": 21,
            "fname": "Bebama",
            "gender": "m"
          }
        ],
        "email": "[email protected]",
        "fname": "Ian",
        "hobbies": [
          "golf",
          "surfing"
        ],
        "lname": "Taylor",
        "relation": "cousin",
        "title": "Mr.",
        "type": "contact"
      }
    },
    {
      "tutorial": {
        "age": 40,
        "contacts": [
          {
            "fname": "Fred"
          },
          {
            "fname": "Sheela"
          }
        ],
        "email": "[email protected]",
        "fname": "Jane",
        "lname": "Edwards",
        "relation": "cousin",
        "title": "Mrs.",
        "type": "contact"
      }
    }

ARRAY_CONCAT Query:

SELECT ARRAY_CONCAT(children[0:1], children[0:1]) FROM tutorial

结果：

{
  "results": [
    {
      "$1": [
        {
          "age": 17,
          "fname": "Aiden",
          "gender": "m"
        },
        {
          "age": 17,
          "fname": "Aiden",
          "gender": "m"
        }
      ]
    },
    {
      "$1": [
        {
          "age": 17,
          "fname": "Xena",
          "gender": "f"
        },
        {
          "age": 17,
          "fname": "Xena",
          "gender": "f"
        }
      ]
    },
    {
      "$1": null
    },
    {},
    {
      "$1": [
        {
          "age": 17,
          "fname": "Abama",
          "gender": "m"
        },
        {
          "age": 17,
          "fname": "Abama",
          "gender": "m"
        }
      ]
    },
    {}
  ]
}