Hi Team,

I have a problem with Hdfs query on Drill. When I run a "SHOW FILES in
root.`tmp/` ", I can list the files correctly.
Bu when I run a select query like "Select * from root.`tmp/` it throws
below error.
Notes:
- I have already checked the state of hdfs health(via dfsadmin and hdfs ui)
and there is no any corruption or block error.
- Drillbits are on the same cluster with Hadoop. So I think any network
problem is impossible.
- I have also set dfs.client.use.datanode.hostname as true (
https://stackoverflow.com/a/55290406/7894534 )

org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR:
Could not obtain block: BP-2026912985-<namenode_ip>-
1569935018133:blk_1073842201_101390 file=/tmp/2015-summary.csv
File Path: hdfs://<drillbit_ip>:8020/tmp/2015-summary.csv
Fragment: 0:0 [Error Id: 466835bd-6512-4854-b231-eaa439eba6f2 on
<drillbit_ip>:31010]

Thank you.
-- 
Mehmet ERSOY

Reply via email to