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

andrerg01
Topic Author
Offline
New Member

7 months 3 weeks ago #2566 by andrerg01

Database Error Disk I/O error: Failed to open HDFS file on most prompts was created 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.

strohmeier
Away
Administrator

7 months 3 weeks ago #2568 by strohmeier

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

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.