1
   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?

eshirvana
  • 23,227
  • 3
  • 22
  • 38
John Woods
  • 71
  • 2

1 Answers1

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';
Lajos Arpad
  • 64,414
  • 37
  • 100
  • 175