flights_data5 query error

1 week 1 day ago #2753 by nhinze
The following query on flights_data5 using :

SELECT * FROM flights_data5 WHERE estdepartureairport='KBJC' AND firstseen>=1712210400 AND firstseen<1712296800

Error:

Query 20240625_194245_83918_jtdt5 failed: Not valid Parquet file: s3a://opensky-hdfs-backup/tables_v5/flights/day=1620172800/: PAR1 got:

Please Log in or Create an account to join the conversation.

1 week 21 hours ago #2754 by strohmeier
Works now, missed some cleanup there from our outage. Note that this is still very much a beta table.

Also you'll get a much faster response if you use "day" instead/with your query. You would likely not even have run into the error as the query wouldn't have had to search the whole database.

Please Log in or Create an account to join the conversation.

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!