SQL Fails on LINQPAD NoSQL data

[tanthiamhuat]

I have this (https://imgur.com/cBwr366), which shows the result of the query. But when I try this (https://imgur.com/fwCFuop) , it fails, why? The data is generated from this book, Guide to NoSQL with Azure Cosmos DB, page 42 for id=1 and pages 47-48 for id=2, which is available at https://pdfs.semanticscholar.org/a575/7f6392e110b1250e7e0e21d82c0d08aa8adb.pdf

[conwid]

The images make reproducing the problem quite hard. Please simply paste the query as text, also the exact error message as text, and upload the data in json so that I can use the data migration tool to create the database and container (also would need the container's name).

[tanthiamhuat]

videogame1_01.json file: { "id": "1", "name": "Battle Royale Kingdoms", "lastCompetitionDate": "2018-09-29T04:36:22.7251173Z", "tags": [ "mobile", "2D", "card game" ], "levels": [ { "title": "Training Camp for Dummies", "towers": 2, "towerPower": 30 }, { "title": "Jungle Arena", "towers": 2, "towerPower": 40 }, { "title": "Legendary World", "towers": 5, "towerPower": 100 } ], "highestScores": [ { "player": { "nickName": "Brandon in Wonderland", "clan": "Wonderland Warriors" }, "score": "750" } ] }

videogame1_02.json file: { "id": "2", "name": "Fortnite vs Zombies", "lastCompetitionDate": "2018-09-30T03:31:20.7251173Z", "tags": [ "3D", "battle royale", "monsters", "shooter" ], "platforms": [ "PS4", "XBox", "PC", "Switch", "iPad", "iPhone", "Android" ], "levels": [ { "title": "Dancing in the storm", "maximumPlayers": 50, "minimumExperienceLevel": 30 }, { "title": "Rainbows after the storm", "maximumPlayers": 30, "minimumExperienceLevel": 60 }, { "title": "The last of us", "maximumPlayers": 10, "minimumExperienceLevel": 100 } ], "highestScores": [ { "player": { "nickName": "PlaystationBoy", "clan": "USA Players", "experienceLevel": 140 }, "score": "5600" }, { "player": { "nickName": "KevinSwitchMan", "clan": "Italian Warriors", "experienceLevel": 125 }, "score": "3300" } ] } The SQL query which fails is: VideoGames1: SELECT * FROM VideoGames1 The container's name is Competition The exact error message: One or more errors occurred.

[tanthiamhuat]

any updated information? Thanks.

[conwid]

Unfortunately I'm swamped with work, not sure when I'll have the time to look into this in more detail. I will check it out as soon as I can.