We are getting a "Table not found" error while runing the following script:
avg(field2) as average1 from abc
where field1 in (50224, 50225)
and timestamp >= to_epoch(date_trunc('day',_now() - interval '1 day'))
and timestamp < to_epoch(date_trunc('day',_now()))
group by 1;
store dt_c into dt_c.qvd;
drop table dt_c_tmp;
We have several scripts written exactly the same way, and they are running without any problem. We have tried to run this in different folder locations, and even typing the file path in the store statement. We also restarted the server. However, the error message keeps showing, and the qvd file is not generated.
What are we missing here?
Thanks in advance,