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

andrerg01
Topic Author
Offline
New Member

1 year 3 months 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)

strohmeier
Offline
Administrator

1 year 3 months 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.