在GridDB中执行SQL查询时遭遇语法错误求助

问题情况 #

已创建GridDB容器并添加数据，但执行SQL查询时持续报错，提示语法无效，错误信息显示最终执行的查询语句缺失容器名和字段名。

原代码示例 #

// Connect to GridDB cluster
GridStore *store = GridStoreFactory::get_instance()->get_gridstore("your_ip_address", 31810, "your_cluster_name", "your_username", "your_password");

// Get a collection
Collection<Row> *collection = store->get_collection<Row>("Data");

// Create a query object
Query<Row> queryObj = collection->query("SELECT * FROM your_container_name WHERE your_column_name = 'your_value'");

// Execute the query
RowSet<Row> *rs = queryObj.fetch();

// Iterate over the result set
while (rs->has_next()) {
    Row *row = rs->next();
    // Do something with the data
}

// Release the resources
delete rs;
delete collection;
store->close();

错误信息 #

Griddb::Exception: Code: 4, Reason: GS_ERROR_QUERY_INVALID_SYNTAX, Invalid syntax for the specified query. (unknown error code): query="SELECT * FROM WHERE = 'value'"

解决步骤 #

• 替换占位符为实际值：代码中的your_container_name、your_column_name、your_value都是占位符，必须替换成你实际创建的容器名称、存在的字段名以及要匹配的真实值。错误信息里的空容器名和字段名，就是因为占位符没替换导致的。
• 确认容器类型与代码匹配：如果你的容器是时间序列类型，不能用Collection<Row>，要改用Timeseries<Row>来获取容器，否则会导致查询异常。
• 校验GridDB SQL语法：GridDB的SQL有特定规则，比如字段名含特殊字符时要用双引号包裹，字符串值用单引号，确保语句没有拼写错误。
• 添加容器存在性检查：获取容器后先判断是否为空，避免因容器不存在导致后续查询出错，示例代码如下：

  if (collection == nullptr) {
      std::cerr << "目标容器不存在" << std::endl;
      store->close();
      return -1;
  }
  

修正后的示例代码 #

// Connect to GridDB cluster
GridStore *store = GridStoreFactory::get_instance()->get_gridstore("192.168.1.10", 31810, "myCluster", "admin", "admin");

// Get a collection (替换为实际容器名)
Collection<Row> *collection = store->get_collection<Row>("SensorData");

// 检查容器是否存在
if (collection == nullptr) {
    std::cerr << "目标容器不存在" << std::endl;
    store->close();
    return -1;
}

// Create a query object (替换实际字段名和查询值)
Query<Row> queryObj = collection->query("SELECT * FROM SensorData WHERE temperature > 30");

// Execute the query
RowSet<Row> *rs = queryObj.fetch();

// Iterate over the result set
while (rs->has_next()) {
    Row *row = rs->next();
    // 处理数据，示例：读取temperature字段值
    int temp;
    row->get("temperature", temp);
    std::cout << "当前温度: " << temp << std::endl;
}

// Release the resources
delete rs;
delete collection;
store->close();

内容的提问来源于stack exchange，提问作者Muaaz Hasni