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.