I/O issues with the Impala "state_vectors_data4" historic data table

9 months 3 weeks ago #2490 by Herson
Attention: Support team.

I would like to raise an Ops I/O issue when accessing  the Impala "state_vectors_data4" table.  The data I'm attempting to access is between 21st Jun 2023 and 22nd Jun 2023

Proof:

select count(*), FROM_unixtime(hour, 'yyyy/MM/dd') as rth_date, 'WINCHESTER-WEST' as area_of_record
FROM state_vectors_data4 where lat between 51.06152 and 51.09048
and lon between -1.366071 and -1.320889
and hour between (extract(epoch from now()) - (3600*24*29)) and (extract(epoch from now()) - (3600*24*27))
group by rth_date order by rth_date desc;

Thanks all.

Richard Herson - Founder of       www.AircraftTrafficSurvey.com   , a Not-For-Profit organisation serving UK communities.

Please Log in or Create an account to join the conversation.

9 months 3 weeks ago #2491 by strohmeier
Those are lost (hardware outage).

Please Log in or Create an account to join the conversation.

9 months 3 weeks ago #2492 by Herson
Lost forever or until restored? Does this also imply that data will be lost to the aircraft/airport APIs too?

Thanks.

Richard.

Please Log in or Create an account to join the conversation.

9 months 3 weeks ago #2493 by strohmeier

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum