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

9 months 2 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 2 weeks ago #2491 by strohmeier
Those are lost (hardware outage).

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

9 months 2 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 1 week ago #2493 by strohmeier

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

Powered by Kunena Forum
This website uses cookies to offer you the best experience of our services. By using this website you agree to our privacy policy!