×

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