×

Notice

The forum is in read only mode.

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

1 year 4 months 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.
1 year 4 months ago #2491 by strohmeier
Those are lost (hardware outage).
1 year 4 months 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.
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!