Couchbase 4010错误 [英] Couchbase 4010 Error

问题描述

我一直在测试Couchbase 5，并创建了一个名为 fp-conversion-data 的存储桶，其中包含一些JSON数据。我一直在尝试运行一些简单的查询，例如：

I've been testing Couchbase 5 and created a bucket called fp-conversion-data which has some JSON data in it. I have been trying to run some simple queries such as:

SELECT * FROM fp-conversion-data limit 5;

没有得到预期的结果，而是不断出现此错误：

Instead of getting the expected results, I keep getting this error:

[
  {
    "code": 4010,
    "msg": "FROM expression term must have a name or alias",
    "query_from_user": "SELECT * FROM fp-conversion-data limit 5;"
  }
]

推荐答案

I认为问题在于您的存储桶名称中有破折号。

I think the problem is that you have dashes in the name of the bucket. Use backticks (`) around the bucket name.

尝试以下操作：

SELECT *
FROM `fp-conversion-data`
LIMIT 5;

这篇关于Couchbase 4010错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！