×

Notice

The forum is in read only mode.

flights_data5 query error

4 months 4 weeks 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:
4 months 4 weeks 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.
Powered by Kunena Forum