英文:
Unable to run the most basic query in cosmosdb Data Explorer?
问题
新面板中的默认查询是select * from c。
但是当我在新面板中创建新查询时，它不起作用。
错误信息：
> 消息：{"errors":[{"severity":"错误","location":{"start":15,"end":16},"code":"SC1001","message":"语法错误，* 附近的语法不正确。"}]} ActivityId: b5f1fde9-f18f-48c3-aa0b-e0dd97067e0f，Microsoft.Azure.Documents.Common/2.14.0
更新 这个操作成功了还是失败了？存在矛盾的信息。如果成功了：
- 为什么会有错误消息？
- 那12行在哪里？
英文:
The default query in a new panel is select * from c
But when I create a new query in a new panel , that does not work?
Error text:
> Message: {"errors":[{"severity":"Error","location":{"start":15,"end":16},"code":"SC1001","message":"Syntax error, incorrect syntax near '*'."}]} ActivityId: b5f1fde9-f18f-48c3-aa0b-e0dd97067e0f, Microsoft.Azure.Documents.Common/2.14.0
Update Did this work or fail? There are conflicting messages. If it worked:
- why is there an error message
- where are those 12 rows?
答案1
得分: 0
这显然是在 Azure 的 CosmosDB 数据资源管理器 中的一个错误。我已经创建了一个新的面板，并成功地在其中显示了结果。实际上，查询内容并不重要，只要是有效的即可。以下是我使用的内容：
SELECT c.registered ?? ''-'' as registered, c.lastName ?? ''-'' as lastName,
c.id, c._ts from c
在发生错误后，数据输出面板不再显示，而是错误会一直保留在 Sql 编辑器选项卡中。请注意，下面的查询与之前的截图中的内容完全相同。但是先前查询的错误仍然显示出来。
我正在 macOS 上使用 Chrome 浏览器。
英文:
This is apparently a bug in the CosmosDB Data Explorer for Azure. I have created a new panel and successfully shown results in it. It does not really matter which query, as long as it is valid. Here is what I used:
SELECT c.registered ?? '-' as registered, c.lastName ?? '-' as lastName,
c.id, c._ts from c
After an error occurs the data output panel no longer is displayed and instead the error remains there .. permanently for that Sql Editor tab. Notice the query below is precisely the same as in the prior screenshot. But the error from a prior query is still shown instead.
I am using chrome on macOS .
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论