×

Notice

The forum is in read only mode.

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

1 year 5 months ago #2458 by Herson
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.
1 year 5 months ago #2463 by strohmeier
1 year 5 months ago #2466 by Herson
1 year 5 months ago #2468 by Herson
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.
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!