Facing Error in executing SQL query in GridDB

Question

I am working with GridDB and trying to execute a SQL query, but I am getting an error. I have created a container and added some data to it. When I try to execute the query, I get an error message saying "Syntax error near 'query'". I have tried multiple times with different queries but getting the same error.

// 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'"

L. Connell · Accepted Answer · 2024-07-01 19:55:59Z

0

What's the type you are querying? I ask because if you're querying a num/int/bool type, the single quotes will cause the query to fail. so if it's not a string type, remove the single quotes.

if it's timestamp type, of course you will need to do more transforming or share more info here

answered Jul 1, 2024 at 19:55

L. Connell

1601 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Facing Error in executing SQL query in GridDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related