Getting empty documents

SQL++
3

Your query

select subscriptionFeature from `silver-spoon`

does not remove objects, where subscriptionFeature is on the third level deep in the document. Like this:

  {
    "silver-spoon": {
      "history": {
        "action": "CREATE",
        "data": {
          "subscriptionFeature": {
            "featureCategory": "string",
            "featureCode": "string8",
            "featureDescription": "string",
            "featureName": "string"
          }
        },
        "roles": [
          "DEVELOPER"
        ],
        "time": "Mar 28, 2017 1:47:57 AM",
        "type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
        "user": "Abhideep"
      }
    }
  }

This is why you see the empty objects in the second query. When you have added limit, you just take first records, which happened all empty. Try

select subscriptionFeature from `silver-spoon` LIMIT 14

And you will see first non-empty result.