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

Attention: Support team.

I would like to raise an Ops I/O issue when accessing  the Impala "state_vectors_data4" table yesterday and today (27/06).

Thanks.

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*5)) and (extract(epoch from now()) - (3600*24*0))
group by rth_date order by rth_date desc;

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

Thanks. I'll check now.

The query run and returned the expected results. Thanks. However it ran very slowly perhaps due to lots of other catch-up processing running in the background.

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

PS. Are you looking for remote part time developers/analysts because I'm keen to help keep your platform up and running.