Description
Preflights of latest Morpheus manifest for Capella Analytics is yielding test failures re: schema inference, due to the addition of a ~meta property to each type inferred:
e.g. for:
WITH n1ql as (
|
LET qOut=$result
|
SELECT VALUE { 'flavor':inferSchema.Flavor,
|
'properties': (
|
SELECT VALUE {'propertyName':property.name,
|
'propertyInfo': (
|
SELECT VALUE propertyInfo
|
FROM OBJECT_PAIRS(property.`value`) propertyInfo
|
WHERE propertyInfo.name = "type"
|
)
|
}
|
FROM OBJECT_PAIRS(inferSchema.properties) AS property)
|
}
|
FROM qOut AS inferSchema)
|
SELECT VALUE n1ql;
|
..., I get:
[
|
{
|
"properties": [ |
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "number" |
}
|
],
|
"propertyName": "abv" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "brewery_id" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "category" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "description" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "number" |
}
|
],
|
"propertyName": "ibu" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "name" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "number" |
}
|
],
|
"propertyName": "srm" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "style" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "type" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "number" |
}
|
],
|
"propertyName": "upc" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "updated" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "object" |
}
|
],
|
"propertyName": "~meta" |
}
|
],
|
"flavor": "`type` = \"beer\"" |
},
|
{
|
"properties": [ |
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "array" |
}
|
],
|
"propertyName": "address" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "city" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "code" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "country" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "description" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "object" |
}
|
],
|
"propertyName": "geo" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "name" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "phone" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "state" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "type" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "updated" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "string" |
}
|
],
|
"propertyName": "website" |
},
|
{
|
"propertyInfo": [ |
{
|
"name": "type", |
"value": "object" |
}
|
],
|
"propertyName": "~meta" |
}
|
],
|
"flavor": "`type` = \"brewery\"" |
}
|
]
|