Error when querying time series data from GridDB using SQL in Ubuntu

Question

   SELECT * 
   FROM my_time_series_table 
   WHERE timestamp >= '2023-01-01' AND timestamp <= '2023-02-01';

I am trying to query time series data from my GridDB database using SQL in Ubuntu. However, I keep encountering an error when executing the query. The error message I receive is:

"Unknown column 'timestamp' in 'where clause'".

I have already confirmed that the 'timestamp' column exists in the 'my_time_series_table'. What could be causing this error and how can I resolve it?

Lajos Arpad · Accepted Answer · 2023-05-21 01:13:05Z

1

Timestamp is a type in Grid DB, so you will need to wrap quotes around your column name to let the db management system know it's a name:

   SELECT * 
   FROM my_time_series_table 
   WHERE "timestamp" >= '2023-01-01' AND "timestamp" <= '2023-02-01';

answered May 21, 2023 at 1:13

Lajos Arpad

80.5k42 gold badges124 silver badges235 bronze badges

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

Collectives™ on Stack Overflow

Error when querying time series data from GridDB using SQL in Ubuntu

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