Database Error Disk I/O error: Failed to open HDFS file on most prompts

8 months 1 week ago #2566 by andrerg01
I'm getting this error most of the time, but every now and again the querry works and returns the data requested.

Querry:SELECT time, lat, lonFROM state_vectors_data4WHERE time > 1693785764;

Error:ERROR: Disk I/O error: Failed to open HDFS file hdfs://nameservice1/user/opensky/tables_v4/state_vectors/hour=1691424000/(2): No such file or directoryRoot cause: RemoteException: File does not exist: /user/opensky/tables_v4/state_vectors/hour=1691424000/(:66)at (:56)at (:2157)at (:2127)at (:2040)at (:583)at (:94)at (:377)at $ClientNamenodeProtocol$()at $Server$(:617)at $(:1073)at $Handler$(:2281)at $Handler$(:2277)at (Native Method)at (:422)at (:1920)at $(:2275)

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

8 months 4 days ago #2568 by strohmeier
Typically, a specific recent hour (or several) do not work. We'll fix it, of course. In the meantime, if you leave those out of the query it works.

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

Powered by Kunena Forum